No, I don't have a SQL script for that. I work on MS SQL at the office and MySQL here at the house. The table structure is fairly straightforward by looking at the query. The ID field is an autonumber identity field. I'm going to have to take a deeper look at the link you forwarded. The example I used is something I had tested from an article that I had found on MSDN (which I promptly lost after discovering it), so I'll definitely need to look at this from 4guys. They usually have some bang up SQL tips. Thanks for the link.
-- Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _____________________________ http://blog.cutterscrossing.com --------------- The Past is a Memory The Future a Dream But Today is a Gift That's why they call it The Present On 6/17/07, Web Specialist <[EMAIL PROTECTED]> wrote:
Thanks Steve. Looks very interesting. Do you can share the SQL tblUsers script? ID is an identity field in that table? Do you found any bottlenecks for that SQL paginations approach? Please look this article for pagination in SQL Server: http://www.4guysfromrolla.com/webtech/042606-1.shtml Thanks. 2007/6/17, Steve Blades < [EMAIL PROTECTED]>: > > I have a (currently) six part tutorial on paging the ExtJS DataGrid > component, with JQuery, on my blog: > > http://blog.cutterscrossing.com/index.cfm/My-First-ExtJS-DataGrid > > Steve 'Cutter' Blades > Adobe Certified Expert > Advanced Macromedia ColdFusion MX 7 Developer > ____________ > > http://blog.cutterscrossing.com > > > "The best way to predict the future is to help create it" > > > > On 6/17/07, Web Specialist <[EMAIL PROTECTED] > wrote: > > > > I'm looking an example using jquery for grid pagination with > > ajax(database hits) support. > > > > http://makoomba.altervista.org/grid/ haves a great example but using > > xml data. I'll want to use json instead. > > > > Do you know? > > > > Cheers > > > > > > > > > -- > Steve "Cutter" Blades > Adobe Certified Professional > Advanced Macromedia ColdFusion MX 7 Developer > _____________________________ > http://blog.cutterscrossing.com > --------------- > The Past is a Memory > The Future a Dream > But Today is a Gift > That's why they call it > The Present