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]
