Re: Fetch specification and raw SQL
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