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