On Fri, 2006-05-05 at 11:07 +1000, Andy Todd wrote: > On 5/5/06, Oleg Broytmann <[EMAIL PROTECTED]> 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/ [EMAIL > > PROTECTED] > > 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.
Oops, I guess I sent this reply to Oleg off-list about that earlier (gotta remember which lists don't set the reply-to): Unfortunately ROWNUM is not the same since it it calculated before the results are ordered. Doing LIMIT and OFFSET is doable, but messy: select col1, col2 from (select col1, col2, rownum rnum from (select col1, col2 from CLAIM_STATUS order by col1)) where rnum between :offset + 1 and :limit + :offset -- Matt Good <[EMAIL PROTECTED]> ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
