Re: Fetch Specs and Limits
Re: Fetch Specs and Limits
- Subject: Re: Fetch Specs and Limits
- From: Arturo Pérez <email@hidden>
- Date: Wed, 11 May 2005 21:04:40 -0400
Hi Greg,
Not everyone thinks display groups are bad. They are very useful but
one needs to be aware of their limitations.
BTW, if you're using postgresql and want to fetch by groups then you
should be aware of the LIMIT clause for pgSQL selects.
On May 11, 2005, at 8:48 PM, Greg wrote:
Thanks for the replies. I have seen on the list that display groups
are bad so I should have EOQualified my question! I have just finished
implementing the display group browser Deirdre sent, but will now try
using raw rows.
Greg
On 12/05/2005, at 10:44 AM, Deirdre Saoirse Moen wrote:
On Wed, 11 May 2005, Robert Walker wrote:
You are correct. EOF does not support a starting index for fetch
limits (as far as I can tell). Possibly due to the need for broad
support for SQL servers that may not support the feature (not sure).
Here's my suggestion: Fetch using EOUtilities.rawRowsForSQL(...) so
you can do your fetch limits in the SQL statement.
I wasn't reading clearly enough earlier -- yes, if you need to get the
next 1000 of N-thousand, this is the better answer.
_______________________________________________
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