|
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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
