Using Fetch Limits with MySQL
Using Fetch Limits with MySQL
- Subject: Using Fetch Limits with MySQL
- From: Johnny Miller <email@hidden>
- Date: Fri, 25 Feb 2011 14:59:11 -1000
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