[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ojb-user
Subject:    Re: case insensitive LIKE and addLike vs addSQL
From:       Armin Waibel <arminw () apache ! org>
Date:       2008-02-27 13:55:26
Message-ID: 47C56BCE.8050905 () apache ! org
[Download RAW message or body]

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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]