Re: db paging with MS Sql

Joe, Does SQL92 count? Best regards, Andrew --------------------------------------- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com On 2/4/01 8:09 PM, "Joe Stump" <jstump@zebulon.miester.org> wrote: > 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 >> -- >>