[rt-devel] DBIx::SearchBuilder ApplyLimits for Oracle

Brook Schofield B.Schofield at mailbox.gu.edu.au
Wed Mar 12 22:27:05 EST 2003


>+     if ($per_page) {
>+         # Oracle orders from 1 not zero
>+         $first++;
>+         # Make current query a sub select
>+         $$statementref = "SELECT * FROM ( SELECT oraquery.*,rownum rn 
>FROM ( $$statementref ) oraquery WHERE rownum <= " . ($first + $per_page - 
>1) . " ) WHERE rn => " . $first;
>+     }
>+ }
>+
>+ # }}}

That should read:

WHERE rn >= " . $first;
          ^^
rather than

WHERE rn => " . $first;
          ^^

-Brook

=========================================================================
=     _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/  _/ Brook Schofield                =
=    _/  _/ _/  _/ _/  _/ _/  _/ _/ _/   B.Schofield at griffith.edu.au    =
=   _/_/   _/_/_/ _/  _/ _/  _/ _/_/     Ph: +61 7 387 53779 - WCN 0.28 =
=  _/  _/ _/ _/  _/  _/ _/  _/ _/ _/     Directory Services Integration =
= _/_/_/ _/  _/ _/_/_/ _/_/_/ _/  _/     Griffith University QLD 4111   =
=========================================================================




More information about the Rt-devel mailing list