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
