Radicore Forum: Bug Reports » SQL Syntax error

Home » RADICORE development » Bug Reports » SQL Syntax error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: SQL Syntax error [message #2218 is a reply to message #2217]

Thu, 16 July 2009 09:52

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

I have just checked what is happening on my system, and I cannot see the problem you are having. When I press the SUBMIT button in the SEARCH screen and see what is available in the _cm_post_search() method I have the following:

the $where string contains whatever was selected in the current SEARCH screen.
the $selection string identifies whatever entries were selected in the screen prior to the SEARCH.

When the OUTPUT1 task is activated these strings are available in the _cm_pre_getData() method as:

$where contains the $selection string in the SEARCH task.
$this->sql_search contains the $where string in the SEARCH task.

You might want to try the attached files as I have made some slight alterations since the last release.

(attachment deleted, updated in later post)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

[Updated on: Thu, 16 July 2009 11:26]

Report message to a moderator

[Message index]

		SQL Syntax error By: gpatti on Wed, 15 July 2009 19:15
		Re: SQL Syntax error By: AJM on Thu, 16 July 2009 05:33
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 05:47
		Re: SQL Syntax error By: AJM on Thu, 16 July 2009 06:08
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 06:24
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 07:13
		Re: SQL Syntax error By: AJM on Thu, 16 July 2009 09:52
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 10:48
		Re: SQL Syntax error By: AJM on Thu, 16 July 2009 11:41
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 12:03
		Re: SQL Syntax error By: AJM on Thu, 16 July 2009 12:21
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 12:27
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 12:37
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 12:53
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 13:02
		Re: SQL Syntax error By: AJM on Thu, 16 July 2009 13:12
		Re: SQL Syntax error By: gpatti on Thu, 16 July 2009 13:20

Previous Topic:	New Hosting Account Bug
Next Topic:	Where is where

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jul 08 23:18:01 EDT 2025

Total time taken to generate the page: 0.10294 seconds