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.class
Ray
Ray
Envoyé depuis iCloud
Le 23 jan 2013 à 09:32, Chuck Hill <ch...@global-village.net> a écrit :
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_ 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 <rnan...@me.com> 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 <s.me...@improve.fr> 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 <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/rnaneon%40me.com
>>>
>>> This email sent to rnan...@me.com
>>>
> _______________________________________________
> 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/chill%40global-village.net
>
> This email sent to ch...@global-village.net
--
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 (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
