Re: Query with NULL

From: Mladen Gogala <>
Date: Thu, 31 Dec 2009 13:31:54 +0000 (UTC)
Message-ID: <hhi94a$ncu$>

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.

Received on Thu Dec 31 2009 - 07:31:54 CST

Original text of this message