Rép : Re: problem of accents on FR data [RESOLVED]

Hi Stéphan,The new argument works very well.Thanks a lot :)Envoyé depuis iCloudLe 26 jan 2013 à 15:30, Raymond NANEON a écrit :Ok Stéphan, I go to change the init call _expression_. I tell you on monday at my office. Thanks Envoyé de mon iPad Le 26 janv. 2013 à 17:03, Stéphan Mertz

Re: problem of accents on FR data

Ok Stéphan, I go to change the init call expression. I tell you on monday at my office. Thanks Envoyé de mon iPad Le 26 janv. 2013 à 17:03, Stéphan Mertz a écrit : > Is your class in the application classpath ? > To be sure, could you change the init call with : > ERXJDBCAdaptor.setExpressionC

Re: problem of accents on FR data

Is your class in the application classpath ? To be sure, could you change the init call with : ERXJDBCAdaptor.setExpressionClassName(IVOracleExpression.class.getName(), ERXJDBCAdaptor.class.getName()); Le 26 janv. 2013 à 16:07, Raymond NANEON a écrit : > Hello Stéphan, > > I put breakpoint in

Re: problem of accents on FR data

Hello Stéphan, I put breakpoint in my class but the override method never read. Did I forget something? I go to upgrade to latest wonder (6) on monday and retry Envoyé de mon iPhone Le 26 janv. 2013 à 11:02, Stéphan Mertz a écrit : > Hello Raymond, > > I don't see why the override is not us

Re: problem of accents on FR data

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 a écrit : > My package is etudiants.utt.fr.util.IVOracleExpression and I the this > ERXJDBCAdaptor.setExpressionClassName("etudiants.

Rép : Re: Re: problem of accents on FR data

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.classRayEnvoyé depuis iCloudLe 23 jan 2013 à 09:32, Chuck Hill a écr

Re: Rép : Re: problem of accents on FR data

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 a écrit : > >> Hi Stephan, >> >> I added the expression ERXJDBCAdaptor.setExpressionClassNa

Re: problem of accents on FR data

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 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 a écrit : >

Rép : Re: problem of accents on FR data

Hi All,Can I have help on my problem? I stuck on it since 3 weeks.ThanksEnvoyé depuis iCloudLe 07 jan 2013 à 02:20, Raymond NANEON a écrit :Hi Stephan,I added the _expression_ ERXJDBCAdaptor.setExpressionClassName("com.resurgences.utils.IVOracleExpression", "er.extensions.jdbc.ERXJDBCAdaptor"); in

Rép : Re: problem of accents on FR data

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+"

Rép : Re: problem of accents on FR data

Hi List,Happy new year, all my best whishes. So stéphan, I am back to my office and I would like to know How I use sqlStringForCaseInsensitiveLike (return String) method as a EOQualifier method?ThanksEnvoyé depuis iCloudLe 20 déc 2012 à 06:37, Raymond NANEON a écrit :Hi Stéphan,Thanks for your hel

Re: problem of accents on FR data

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 a écrit : > And add this in the Application init to replace the original OracleExpression > (you must change the IVOracleExpressio

Re: problem of accents on FR data

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:

Re: problem of accents on FR data

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 a écrit : > Hi, > > I subclass OracleExpression like this

Re: problem of accents on FR data

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 = _N

problem of accents on FR data

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