Re: query on null value

[Armin Waibel]

Ziv Yankowitz wrote:
Hi,
we are using OJB 1.0.1 and 
are trying to query all column in which a value is null using the ODMG Api

The query: select all from A where txt is null
query.create("select allA from " + A.class.getName() + " where 
is_undefined(txt)");

or
query.create("select allA from " + A.class.getName() + " where txt = nil");
have a look in OJB test-suite under 
db-ojb/src/test/org/apache/ojb/odmg/OQLTest.java you can find examples 
of oql-Query.

regards,
Armin

the error is: txt unexpected token.
can someone please help as to what needs to be done.
Thanks Ziv.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]