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 #2221 is a reply to message #2212]

Thu, 16 July 2009 12:03

gpatti
Messages: 287
Registered: August 2008

Senior Member

Actually Tony, that's exactly what I've done regarding $where to get the right data passed to the next task. I've also used that technique to get $selection passed through also (although I will see if the updated files make that unnecessary). So the functionality is working correctly now.

There is a side effect of using append2ScriptSequence() rather than scriptNext().

With scriptNext() once my output task is completed (it's an output3) control returns to the dummy add screen and I can change the additional selection criteria and SUBMIT to run another output, or CANCEL the screen to return to the LIST2.

With append2ScriptSequence() after the output is completed control also returns (to the search screen this time), but now on pressing SUBMIT or CLEAR I am always returned to the LIST2 screen, and the list is now filtered, which I don't want.

I used append2ScriptSequence() because of the notes in your example. Can scriptNext() be used instead, or would you suggest an alternative way of changing the behaviour?

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: Wed Oct 21 03:59:12 EDT 2026

Total time taken to generate the page: 0.01199 seconds