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]
