Hi Thomas,
Geike, Thomas wrote:
Hi all,
I am having trouble to generate case insensitive LIKE sql clauses with
ojb.
The SQL I want to produce in the end should look something like this:
SELECT * FROM <table> WHERE UPPER(<column>) LIKE UPPER(<user_input>);
....
Does anyone know a solution to this problem?
Any help appreciated. Thanks a lot in advance.
Sorry no. Currently OJB doesn't analyze query parameter values (e.g.
"LIKE UPPER(<user_input>)") for sql-functions.
By the way, is it allowed to use function expressions as parameter value
in a PreparedStatement?
regards,
Armin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
