Re: [SQLObject] Oracle driver

[Andy T. <an...@gm...>]

On 5/5/06, Oleg Broytmann <ph...@ph...> wrote:
> Hello!
>
> On Mon, Apr 24, 2006 at 09:23:42AM -0400, Eric Moore wrote:
> > I put one in the SVN repository a week or two ago, and it's mostly
> > complete.  The unit tests for unicode, BLOBS, and Pickled objects
> > don't pass
>
>    Why? Any problem fixing it?
>
> > http://svn.colorstudy.com/SQLObject/branches/trunk-oracle/
>
>    I don't use Oracle but I looked up on the Net that Oracle supports
> ROWNUM instead of OFFSET/LIMIT, so you can fix that too.
>
> Oleg.
> --
>      Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
>            Programmers don't die, they just GOSUB without RETURN.
>
>

Indeed Oracle has a ROWNUM pseudo-column but it doesn't work in the
same way as OFFSET/LIMIT. ROWNUM is only useful after a query has
returned rows so you can't, for instance, say 'give me rows 100-199
from the is query'. If you try something like that you'll get a NULL
result set.

Regards,
Andy
--
From the desk of Andrew J Todd esq