• 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
Re: Fetch specification and raw SQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Fetch specification and raw SQL


  • Subject: Re: Fetch specification and raw SQL
  • From: Kushnir Gennady <email@hidden>
  • Date: Wed, 3 Aug 2005 18:06:15 +0400

You can try to fetch programmatically (not using named Fetch Specifications)
Or try to use fetch spec with qualifier (not row SQL) but set row row fetching.


Gennady

On 02.08.2005, at 16:54, Pascal Robert wrote:


Le 05-08-01, à 11:43, Arturo Perez a écrit :


Pascal Robert wrote:

Hi list,
In
EOModel, I specified 'Use Raw SQL Expression' and I tried thw following WHERE clause :
WHERE CONTAINS(AEA_TEXTE, '?', 0) > 0
and in my code :
...WHERE CONTAINS(AEA_TEXTE, ?, 0) > 0 ">:




IIRC, you can't use variables/bindings in raw SQL via a fetch spec. One of the worst features/lack thereof in EOF.


:-/ Well, I guess my only choice is to move the CLOB in an another table. I also tried to fetch the Primary Key as Raw Rows, and creating EO objects in a loop, it's even slower than fetching all data with a fetch specification.


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
408ka.mipt.ru


This email sent to email@hidden


_______________________________________________ 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
References: 
 >Fetch specification and raw SQL (From: Pascal Robert <email@hidden>)
 >Re: Fetch specification and raw SQL (From: Arturo Perez <email@hidden>)
 >Re: Fetch specification and raw SQL (From: Pascal Robert <email@hidden>)

  • Prev by Date: Re: synchronizing models
  • Next by Date: Re: synchronizing models
  • Previous by thread: Re: Fetch specification and raw SQL
  • Next by thread: MEETING: Chicago - Tuesday, August 2nd
  • Index(es):
    • Date
    • Thread