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
-~----------~----~----~----~------~----~------~--~---

Reply via email to