On each (of two) pages (there are right now 21 records), it will show only the first twenty records.
When it loads page one, it sends a simple select top 20 statement to the DB. When loading page two, it sends the odd one I pointed out above. Should I enter a bug report, or should I work on tracking down the issue a bit? On Apr 14, 4:20 pm, "nate" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
