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