Re: case insensitive LIKE and addLike vs addSQL

[Armin Waibel]

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]