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/archive%40mail-archive.com This email sent to [email protected]
