There is a bug of SQL::Abstract::Limit.
In my case DB it is SQL Server. But I thibk it's common bug for all
DBD. As I suggest SQL::Abstract::Limit don't consider Data::Page
params generating SQL for DB.
Simplest query it's
SELECT * FROM
(
SELECT TOP $rows * FROM
(
SELECT TOP ($rows*$page}) $sql $order_by_up
) AS foo
$order_by_down
) AS bar
$order_by_up
SQLAL don't consider Data::Page entries_on_this_page.
Possible decision it's make a generation of query depend on Data::Page
params.
Maybe someone have already done this?
If not, I'll be trying myself to do it.
--
dreel mailto:[EMAIL PROTECTED]
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
