[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