Re: SQL Syntax error [message #2218 is a reply to message #2217] |
Thu, 16 July 2009 09:52 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to previous message](/theme/default/images/down.png) |
AJM
Messages: 2361 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
|
|
|