Okay, here's my question: are you looking at it and thinking, based on your understanding of the query, that it will only ever return the first 20 rows, or are you actually attempting to navigate from page to page, and actually experiencing that it will only return the first 20 rows?
On Apr 13, 6:23 pm, "Joshua Benner" <[EMAIL PROTECTED]> wrote: > Please note, I don't know if this is a bug... if feedback suggests it > is, then I'll submit a bug report -- but I'd like to seek input from > others first. > > I'm using the scaffolding on a very basic table for inputting some > support data. However, the scaffold does not seem to paginate > properly, showing the first 20 records while on page two. The query it > sends for page one is straightforward enough... but then the query it > sends for page 2 is along the following lines: > > select * from (select top 20 * from (select top 20 field1 as > field1,... from table where 1=1) as Set1) as Set 2 > > I'm not sure what it's trying to do there... but that query will > return just the first twenty rows, not the second set of twenty. Is it > possible I have something configured wrong? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [EMAIL PROTECTED] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
