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

2013-01-28 Thread Raymond NANEON
Hi Stéphan,The new argument works very well.Thanks a lot :)Envoyé depuis iCloudLe 26 jan 2013 à 15:30, Raymond NANEON rnan...@me.com 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

Re: problem of accents on FR data

2013-01-26 Thread Stéphan Mertz
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 rnan...@me.com a écrit : My package is etudiants.utt.fr.util.IVOracleExpression and I the this

Re: problem of accents on FR data

2013-01-26 Thread Raymond NANEON
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 s.me...@improve.fr a écrit : Hello Raymond, I don't see why the

Re: problem of accents on FR data

2013-01-26 Thread Stéphan Mertz
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 rnan...@me.com a écrit : Hello Stéphan, I put

Re: problem of accents on FR data

2013-01-26 Thread Raymond NANEON
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 s.me...@improve.fr a écrit : Is your class in the application classpath ? To be sure, could you change the init call with :

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

2013-01-24 Thread Raymond NANEON
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

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

2013-01-23 Thread Raymond NANEON
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 rnan...@me.com a écrit :Hi Stephan,I added the _expression_ ERXJDBCAdaptor.setExpressionClassName("com.resurgences.utils.IVOracleExpression",

Re: problem of accents on FR data

2013-01-23 Thread George Domurot
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 rnan...@me.com 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

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

2013-01-23 Thread Chuck Hill
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 rnan...@me.com a écrit : Hi Stephan, I added the expression

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

2013-01-07 Thread Raymond NANEON
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 rnan...@me.com a écrit :Hi

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

2013-01-07 Thread Raymond NANEON
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+"

Re: problem of accents on FR data

2012-12-21 Thread Raymond NANEON
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 s.me...@improve.fr a écrit : And add this in the Application init to replace the original OracleExpression (you must change the

Re: problem of accents on FR data

2012-12-20 Thread Stéphan Mertz
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 =

Re: problem of accents on FR data

2012-12-20 Thread Raymond NANEON
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

Re: problem of accents on FR data

2012-12-20 Thread Stéphan Mertz
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,

problem of accents on FR data

2012-12-14 Thread Raymond NANEON
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