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: 287
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