Re: Using Fetch Limits with MySQL
Re: Using Fetch Limits with MySQL
- Subject: Re: Using Fetch Limits with MySQL
- From: Paul D Yu <email@hidden>
- Date: Fri, 25 Feb 2011 20:02:05 -0500
John
Are you using ERBatchingDisplayGroup?
Paul
On Feb 25, 2011, at 7:59 PM, Johnny Miller wrote:
> Hi,
>
> I have a database with a single table with a lot of rows (millions). I need to query the database and only return the first few rows. Unfortunately, using a FetchSpecification with setFetchLimit does not do the trick. I'm running into a similar problem described here: http://www.codefab.com/2006/02/11/webobjectseof-patch-better-way-to-limit-fetches-with-openbase/
>
> The same is true if I just use EOUtilities.rawRowsForSQL - for some reason EOF takes out the LIMIT clause I throw in.
>
> Does anybody know of a work around?
>
> Thanks in advance,
>
> Johnny Miller
> Kahalawai Media Corp
> http://www.kahalawai.com
>
>
>
> _______________________________________________
> 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
_______________________________________________
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