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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to