Hi Stéphan,
Thanks for your help and I want to know if it returns rawrowSql or EOEntity
data?
How can I use this class in my EOQualifier expression? An example I mean
Ray
Envoyé depuis iCloud
Le 20 déc. 2012 à 15:31, Stéphan Mertz <s.me...@improve.fr> a écrit :
> Hi,
>
> I subclass OracleExpression like this :
>
> public class IVOracleExpression extends OracleExpression {
>
> public IVOracleExpression(EOEntity in_entity) {
> super(in_entity);
> }
>
> public String sqlStringForCaseInsensitiveLike(String in_s, String in_s1) {
> String l_str = _NSStringUtilities.concat("CONVERT(upper(", in_s1, "),
> 'US7ASCII') LIKE CONVERT(upper(", in_s, "), 'US7ASCII')");
>
> return l_str;
> }
> }
>
> Le 14 déc. 2012 à 11:20, Raymond NANEON <rnan...@me.com> a écrit :
>
>> Hi List,
>>
>> I have a little data fetching problem. In our data base we have names with
>> accent and other do not. So when we do a SQL request in our WHERE CLAUSE we
>> surround the instruction with the function func_enleve_accent which removes
>> accents.
>>
>> i.e
>> SELECT nom, prenom WHERE upper(fonc_enleve_accents(i.prenom)) like
>> upper(fonc_enleve_accents('severine')) )
>>
>> With this request we have all names with accents or not (sévérine or
>> severine)
>>
>> In WO I try to reproduce the same thing but it does not work properly. When
>> I have a name with accent like 'séverine' it works (we all names) but with
>> 'severine' we have only name without accent.
>>
>> Here my qualifier
>>
>> // CLAUSE WHERE "PRENOM LIKE ..."
>> private static EOQualifier qualForPrenomLike(String prenom) {
>> String prenom_a = StringCtrl.chaineSansAccents(prenom, "?");
>> return PRENOM.like(prenom).or(PRENOM.like(prenom_a));
>> }
>>
>> How can I modify my qualifier to have the same result like SQL request?
>>
>> Thanks for you help
>> Envoyé depuis iCloud
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
>> Help/Unsubscribe/Update your Subscription:
>> https://lists.apple.com/mailman/options/webobjects-dev/s.mertz%40improve.fr
>>
>> This email sent to s.me...@improve.fr
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
