Torque testing for null columns

[Byron Foster <bf...@base2.cc>]

I was wondering if there is any status on testing if a column is null in
a general DB independent way.  This is a fairly common operation and
would certainly add utility to Torque.  I was considering implementing
it through the DB Adaptors.  the method isNull(String column) would be
added to the Criteria object so that the is null test could be bundled
with other criteria.  The documentation criteria-howto.html specifies
that the SQL necessary to test for null "vary fairly widely".  How
widely does it very?  Does it still come down to appending text to test
for null at the end of a SQL query for any given DB?

Thanks,
Byron 


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: Torque testing for null columns

[Byron Foster <bf...@base2.cc>]

Nevermind, I found out you can use: Criteria.add(BaseFooPeer.BAR, null)

Byron



> 
> I was wondering if there is any status on testing if a column is null in
> a general DB independent way.  This is a fairly common operation and
> would certainly add utility to Torque.  I was considering implementing
> it through the DB Adaptors.  the method isNull(String column) would be
> added to the Criteria object so that the is null test could be bundled
> with other criteria.  The documentation criteria-howto.html specifies
> that the SQL necessary to test for null "vary fairly widely".  How
> widely does it very?  Does it still come down to appending text to test
> for null at the end of a SQL query for any given DB?
> 
> Thanks,
> Byron 
> 




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>