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