Hi,
How come "X=null" is not the same as "X is null"? I got a few selects with
queries like this:
select * from foo where customer=#customer# or (#customer# is null and customer
is null)
Without the last part, it will not correctly match null customers.
PS. I am using the ibatis framework for java, so the #customer# gets translated
to ? and the whole thing made into a prepared statement.
Thanks,
Baldur
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.