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 protected]> 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 protected]> 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 protected]> 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 protected]> 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 protected]> 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 protected]> 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 protected]> 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 protected]> 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 protected]> 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 protected]> 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 protected]> 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 protected]) >>>>>>>>>>>> Help/Unsubscribe/Update your Subscription: >>>>>>>>>>>> https://lists.apple.com/mailman/options/webobjects-dev/s.mertz%40improve.fr >>>>>>>>>>>> >>>>>>>>>>>> This email sent to [email protected] >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Do not post admin requests to the list. They will be ignored. >>>>>>>> Webobjects-dev mailing list ([email protected]) >>>>>>>> Help/Unsubscribe/Update your Subscription: >>>>>>>> https://lists.apple.com/mailman/options/webobjects-dev/rnaneon%40me.com >>>>>>>> >>>>>>>> This email sent to [email protected] >>>>>> _______________________________________________ >>>>>> Do not post admin requests to the list. They will be ignored. >>>>>> Webobjects-dev mailing list ([email protected]) >>>>>> Help/Unsubscribe/Update your Subscription: >>>>>> https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >>>>>> >>>>>> This email sent to [email protected] >>>>> >>>>> -- >>>>> 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 protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> https://lists.apple.com/mailman/options/webobjects-dev/s.mertz%40improve.fr >>>> >>>> This email sent to [email protected] > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
