EOFetchSpecification text to number conversion
EOFetchSpecification text to number conversion
- Subject: EOFetchSpecification text to number conversion
- From: Frédéric JECKER <email@hidden>
- Date: Mon, 07 Jul 2008 16:19:03 +0200
Hi,
I recently changed a table primary key column from NUMBER(6) to
NUMBER(12) for a legacy app.
After this change I had a lot of bugs and discovered that search
queries where returning zero rows.
In this legacy app, a lot of fetch specifications are written like this
:
String pid="806000022"; //for the
example, in real life this value is read from a text file.
new EOFetchSpecification("Patient",
EOQualifier.qualifierWithQualifierFormat("nip = " + pid, null), null);
With debugging on, this gives the following query which returns 0 rows :
<SELECT (...) FROM Pat_Patient t0 WHERE t0.nip =
?"
withBindings: 1:8.06E8(nip)>
Now, when using an Integer instead a String :
String pid=":806000022";
new EOFetchSpecification("Patient",
EOQualifier.qualifierWithQualifierFormat("nip = " +
Integer.valueOf(pid), null), null);
Gives the following query which returns the awaited rows.
<SELECT (...) FROM Pat_Patient t0 WHERE t0.nip = ?" withBindings: 1:806000022(nip)>
Any idea which could avoid me rewriting the 200+ fetch
specifications of this app ?
Thanks
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden