You have to resort to stored procedures to do paging with Microsoft SQL server. This is an example: http://weblogs.asp.net/pwilson/archive/2003/10/10/31456.aspx.
Maybe you should consider MySQL? It offers a very convenient "Limit offset, limit" clause for paging. Regards, Yee _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 January 2006 9:37 PM To: [email protected] Subject: RE: SQL paging with dataScroller Paging at the database level is feasible sometimes natively but it depends what you are using. For example, it's easy with Oracle but not with SQL Server natively. However, that means that any changes in sorting dynamically require reordering your recordset to output it properly. In this case, depending how it's done, it could mean running the query again with a different SORT clause, which means it could be pretty less efficient than keeping a map/list of results in a "buffer" that you just play with. But of course different cases call for different solutions. Maybe you can elaborate a bit on what you want to do exactly and what you need to provide (sorting, size of recordsets, etc...)? If it applies, then I think it should be fairly easy to implement using a datascroller that is plugged on a bean method that retrieves the required data on get() probably? I've never personally done it but I believe some people do it here. Greg -----Original Message----- From: Rafael Nami [mailto:[EMAIL PROTECTED] Sent: Tue 1/3/2006 8:23 AM To: MyFaces Discussion Cc: Subject: SQL paging with dataScroller
<<attachment: winmail.dat>>
