http://www.oracle.com/technology/oramag/oracle/07-jan/o17asktom.html
;) On 6/25/07, Gwyn Evans <[EMAIL PROTECTED]> wrote: > On Monday, June 25, 2007, 9:54:58 PM, Landry <[EMAIL PROTECTED]> wrote: > > > A problem remains, however : i don't know how to implement > > IDataProvider.iterator(int first, int count). > > Must be something like this in oracle : "select * from mytable where > rownum>>=first and rownum <count " > > Actually, in Oracle, it's significantly more complex than the above, > but let's not go there (unless you're actually doing that in Oracle?). > > > But how to do this in mysql ? (row_id could do the thing, but it is only > > available when your primary key is integer). > > I've not used MySQL for years, but I think it's > select * from mytable order by whatever limit first, count > where 'first' is from 0. > > /Gwyn > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Wicket-user mailing list > Wicket-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wicket-user > -- Scott Swank reformed mathematician ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
