Thanks for the quick response.
-----Original Message-----
From: Armin Waibel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 12, 2005 11:59 AM
To: OJB Users List
Subject: Re: query on null value
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
