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/archive%40mail-archive.com This email sent to arch...@mail-archive.com