I have looked through the archives and have not found any mention of
this. I have used even the latest code, but with no success.
Basically, I have a query that contains parentheses like so:
OQLQuery oql = db.getOQLQuery("CALL SQL select * from a where a.b
> (select MAX(x) from y) AS classA");
What I have noticed is that when I have SQL with parens in it,
everything within the parens is removed. If I try this:
OQLQueryImpl oqli = (OQLQueryImpl)oql;
System.out.println("query=<"+oqli.getSQL()+">");
I see that the SQL which is created looks like this:
SQL select * from a where a.b > ()
Why is this? How can I use nested queries and/or SQL with ANY parens in
them and pass this to getOQLQuery and exceute them? Any help is
MUCH appreciated. Also, I am not on the mailing list, so please reply
directly.
TIA!
Jon
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
