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 <rnan...@me.com> 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 <s.me...@improve.fr> 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 <rnan...@me.com> 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 <ch...@global-village.net> 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 <rnan...@me.com> 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 <rnan...@me.com> 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 <s.me...@improve.fr> 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 <rnan...@me.com> 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 <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/rnaneon%40me.com >>>>>>> >>>>>>> This email sent to rnan...@me.com >>>>> _______________________________________________ >>>>> 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/chill%40global-village.net >>>>> >>>>> This email sent to ch...@global-village.net >>>> >>>> -- >>>> 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 (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