Re: SQL Syntax error [message #2222 is a reply to message #2221] |
Thu, 16 July 2009 12:21 |
AJM
Messages: 2373 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
Yes, you can use scriptNext() instead of append2ScriptSequence(). You need to choose the one you want depending on what behaviour is best for you. If the next task is a batch task then append2ScriptSequence() is best.
BTW, I've decided that instead of having to create your own code to save the contents of the $where string which was passed down from the parent LIST2 task it would be much easier if I saved the value inside std.search1.inc so that it is automatically available inside _cm_post_search(). I haved changed line 57 to read as follows:
if (!empty($selection)) {
$dbobject->sql_selection = $selection;
} else {
$dbobject->sql_selection = $where;
} // if
$dbobject->sql_selection will be made available as the $selection argument inside the _cm_post_search() method.
This means that the contents of $where will only be used if $selection is empty. You should not need any custom code inside _cm_initialise() to save the contents of either $where or $selection.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|