Re: problem of accents on FR data
Re: problem of accents on FR data
- Subject: Re: problem of accents on FR data
- From: Stéphan Mertz <email@hidden>
- Date: Sat, 26 Jan 2013 11:02:15 +0100
Hello Raymond,
I don't see why the override is not used in your code.
Did you put a breakpoint in the override method ?
Le 24 janv. 2013 à 11:06, Raymond NANEON <email@hidden> a écrit :
> My package is etudiants.utt.fr.util.IVOracleExpression and I the this ERXJDBCAdaptor.setExpressionClassName("etudiants.utt.fr.util.IVOracleExpression", "er.extensions.jdbc.ERXJDBCAdaptor"); expression in my init off Application.class
>
> Ray
> Envoyé depuis iCloud
>
> Le 23 jan 2013 à 09:32, Chuck Hill <email@hidden> a écrit :
>
>>
>> On 2013-01-23, at 5:49 AM, Raymond NANEON wrote:
>>
>> > Hi All,
>> >
>> > Can I have help on my problem? I stuck on it since 3 weeks.
>> >
>> > Thanks
>> > Envoyé depuis iCloud
>> >
>> > Le 07 jan 2013 à 02:20, Raymond NANEON <email@hidden> a écrit :
>> >
>> >> Hi Stephan,
>> >>
>> >> I added the expression ERXJDBCAdaptor.setExpressionClassName(
>>
>> >> "com.resurgences.utils.IVOracleExpression"
>>
>> Is that really the package name and class that you put your code in?
>>
>>
>> Chuck
>>
>>
>> >> , "er.extensions.jdbc.ERXJDBCAdaptor"); in my Application class init method and I used these qualifiers "EOQualifier quaPrenom = EOQualifier.qualifierWithQualifierFormat(PRENOM_KEY+" LIKE %@", new NSArray(prenom));" or "PRENOM.like(prenom)" to get sqlStringForCaseInsensitiveLike method in the SQL expression but I have allways the sqlStringForCaseInsensitiveLike method of EOSQLExpression class in my SQL. Have I forget something?
>> >>
>> >> Thanks
>> >> Envoyé depuis iCloud
>> >>
>> >> Le 21 déc 2012 à 01:07, Raymond NANEON <email@hidden> a écrit :
>> >>
>> >>> Hi Stéphan,
>> >>> Thanks a lot. I am in holydays. I go to try it when I will go back at office.
>> >>> Have nice day
>> >>>
>> >>> Envoyé de mon iPhone
>> >>>
>> >>> Le 20 déc. 2012 à 16:25, Stéphan Mertz <email@hidden> a écrit :
>> >>>
>> >>> > And add this in the Application init to replace the original OracleExpression (you must change the IVOracleExpression class name and package with yours):
>> >>> > ERXJDBCAdaptor.setExpressionClassName("com.resurgences.utils.IVOracleExpression", "er.extensions.jdbc.ERXJDBCAdaptor");
>> >>> >
>> >>> >
>> >>> > Le 20 déc. 2012 à 15:37, Raymond NANEON <email@hidden> a écrit :
>> >>> >
>> >>> >> 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 <email@hidden> 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 <email@hidden> 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 (email@hidden)
>> >>> >>>> Help/Unsubscribe/Update your Subscription:
>> >>> >>>>
>> >>> >>>> This email sent to email@hidden
>> >>> >
>> >>>
>> >>> _______________________________________________
>> >>> Do not post admin requests to the list. They will be ignored.
>> >>> Webobjects-dev mailing list (email@hidden)
>> >>> Help/Unsubscribe/Update your Subscription:
>> >>>
>> >>> This email sent to email@hidden
>> >>>
>> > _______________________________________________
>> > Do not post admin requests to the list. They will be ignored.
>> > Webobjects-dev mailing list (email@hidden)
>> > Help/Unsubscribe/Update your Subscription:
>> >
>> > This email sent to email@hidden
>>
>> --
>> Chuck Hill Senior Consultant / VP Development
>>
>> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
>> http://www.global-village.net/gvc/practical_webobjects
>>
>> Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing Companies in B.C!
>> Global Village Consulting ranks 76th in 24th annual PROFIT 200 ranking of Canada’s Fastest-Growing Companies by PROFIT Magazine!
>>
>>
>>
>>
>>
>>
>>
>>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden