Radicore Forum: Bug Reports » isnull clause being filtered out of $where with scriptNext()

Home » RADICORE development » Bug Reports » isnull clause being filtered out of $where with scriptNext()

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

isnull clause being filtered out of $where with scriptNext() [message #2236]

Tue, 04 August 2009 12:35

gpatti
Messages: 283
Registered: August 2008

Senior Member

Tony,

This is further to the recent topic about the use of scriptNext(). I have now added an ' AND isnull(column_name)' clause to $where which is used in a scriptNext() call.

When I look at the generated SQL this has been filtered out of the where clause (just the statements before the final AND remain) so I have too many rows returned. I seem able to add other statements successfully, but isnull is being filtered out.

Is there any reason for this, or a way I can work around it?

Thanks,

Graham

Report message to a moderator

[Message index]

		isnull clause being filtered out of $where with scriptNext() By: gpatti on Tue, 04 August 2009 12:35
		Re: isnull clause being filtered out of $where with scriptNext() By: AJM on Tue, 04 August 2009 19:26
		Re: isnull clause being filtered out of $where with scriptNext() By: gpatti on Wed, 05 August 2009 05:10

Previous Topic:	Where is where
Next Topic:	Losing $where when fixed selection is not present

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jan 09 16:54:56 EST 2025

Total time taken to generate the page: 0.00991 seconds