On Sun, Nov 11, 2007 at 12:46:05AM +0300, [EMAIL PROTECTED] wrote:
> 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.
Don't reply to an existing message to start a new thread, your mail will
get lost.
--
Matt S Trout Need help with your Catalyst or DBIx::Class project?
Technical Director http://www.shadowcat.co.uk/catalyst/
Shadowcat Systems Ltd. Want a managed development or deployment platform?
http://chainsawblues.vox.com/ http://www.shadowcat.co.uk/servers/
_______________________________________________
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]
