Re: How to use SQL functions with parameters?

2007-02-02 Thread Armin Waibel
Hi Francesco, the oql-support isn't fully implemented. http://db.apache.org/ojb/status.html Maybe it's possible to do a workaround by using the Criteria-API http://db.apache.org/ojb/docu/guides/odmg-guide.html#no-oql http://db.apache.org/ojb/docu/guides/query.html#subqueries regards, Armin Fr

How to use SQL functions with parameters?

2007-01-31 Thread Francesco Martinelli
Dear all, I need to filter a query using an SQL function. In SQL this would be achieved with the following statement: select * from myTable where key in (select * from myFunc(myParam)) I tried the same with ODB-ODBC, and this worked using the following query string: String oqlQuery = "sel