Re: Query with NULL
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 31 Dec 2009 13:31:54 +0000 (UTC)
Message-ID: <hhi94a$ncu$4_at_news.eternal-september.org>
On Tue, 29 Dec 2009 21:19:22 +0100, bob123 wrote:
Date: Thu, 31 Dec 2009 13:31:54 +0000 (UTC)
Message-ID: <hhi94a$ncu$4_at_news.eternal-september.org>
On Tue, 29 Dec 2009 21:19:22 +0100, bob123 wrote:
>>select * from bxat.no5
>>WHERE (no0_session_id = :wp18 OR :wp18 IS NULL) AND (tbname = :wp19 OR
>>:wp19 IS NULL)
I would advise against checking whether an external variable is NULL in the SQL. I am aware that Hibernate sometimes does that, but that can be reworked.
-- http://mgogala.byethost5.comReceived on Thu Dec 31 2009 - 07:31:54 CST