Re: problem of accents on FR data
Re: problem of accents on FR data
- Subject: Re: problem of accents on FR data
- From: Raymond NANEON <email@hidden>
- Date: Sun, 27 Jan 2013 00:30:45 +0100
Ok Stéphan,
I go to change the init call expression. I tell you on monday at my office.
Thanks
Envoyé de mon iPad
Le 26 janv. 2013 à 17:03, Stéphan Mertz <email@hidden> a écrit :
> Is your class in the application classpath ?
> To be sure, could you change the init call with :
> ERXJDBCAdaptor.setExpressionClassName(IVOracleExpression.class.getName(), ERXJDBCAdaptor.class.getName());
>
> Le 26 janv. 2013 à 16:07, Raymond NANEON <email@hidden> a écrit :
>
>> Hello Stéphan,
>>
>> I put breakpoint in my class but the override method never read. Did I forget something?
>> I go to upgrade to latest wonder (6) on monday and retry
>>
>> Envoyé de mon iPhone
>>
>> Le 26 janv. 2013 à 11:02, Stéphan Mertz <email@hidden> a écrit :
>>
>>> 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