isnull clause being filtered out of $where with scriptNext() [message #2236] |
Tue, 04 August 2009 12:35 ![Go to next message Go to previous message](/theme/default/images/down.png) |
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
|
|
|