• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
EOFetchSpecification text to number conversion
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: EOFetchSpecification text to number conversion
      • From: Chuck Hill <email@hidden>
  • Prev by Date: Re: Back To Basics : Databases Active Editing Context
  • Next by Date: 5.4 can't connect to database
  • Previous by thread: Re: [OT] Objective-c library that would resemble EO talking to SQLite
  • Next by thread: Re: EOFetchSpecification text to number conversion
  • Index(es):
    • Date
    • Thread