Hi Raymond, What does the SQL look like that is output in your console?
-G On Jan 23, 2013, at 5:49 AM, Raymond NANEON <[email protected]> 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", >> "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/mastermind%40knuckleheads.net > > 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]
