Re: db paging with MS Sql

I was just meaning plain SQL - can't microsoft say ANSI? All I ask for is a simple little standard and for people to follow it - I'm not asking for every feature of the standard - just a following. --Joe On Sun, Feb 04, 2001 at 10:43:37PM -0300, Manuel Lemos wrote: > Hello Joe, > > On 04-Feb-01 21:18:55, you wrote: > > >AFAIK this is more of a SQL thing than a DB specific thing. Just look up the > >LIMIT equivilent in MS SQL (should just be LIMIT) and use that for paging, > >once you get the hang of it it's quite easy. > > >You can look through my paging class at www.miester.org/software - it goes > >one deeper and does [ prev ] [1] [2] [3] [ next ] and then only shows X > >ammount of pages so when you get to page 10 it would show [9] [10] [11] > > I suppose you mean MySQL and not MS (MicroSoft) SQL . They are not > compatible. > > > Regards, > Manuel Lemos > > Web Programming Components using PHP Classes. > Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org > -- > E-mail: mlemos@acm.org > URL: http://www.mlemos.e-na.net/ > PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp > -- > -- ------------------------------------------------------------------------------- Joe Stump, PHP Hacker, joestump98@yahoo.com -o) http://www.miester.org http://www.care2.com /\\ "It's not enough to succeed. Everyone else must fail" -- Larry Ellison _\_V -------------------------------------------------------------------------------