Re: OQL Query by date

[Brian McCallister]

Here is the problem:

from src/java/org/apache/ojb/odmg/oql/OQLLexerTokenTypes.txt

LITERAL_date="date"=61

the word "date" is a token in OQL =(

-Brian

On Mar 25, 2004, at 5:00 PM, Angus Berry wrote:

(rc5)
From everything I've read I think this should work. I'm trying to 
select
an object by it's id & date:

query.create("select invoice from " + InvoiceBO.class.getName() + "
where invoiceID = $1 and date = $2");
Before I even get to bind the query values (query.bind(invNum)), I get
an error saying:
line 1: unexpected token: and
The following select also fails:
query.create("select invoice from " + InvoiceBO.class.getName() + "
where date = $1");
line 1: unexpected token: date
However, if I use a line like the one below it will select OK (given 
the
correct params):
query.create("select invoice from " + InvoiceBO.class.getName() + "
where invoiceID = $1 and clientName = $2");

Have done a bad thing by have a property called 'date' in my class, or
is my syntax incorrect for a date select.
thanks



---------------------------------------------------------------------
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]