Re: db paging with MS Sql

Hello Joe, On 04-Feb-01 22:01:37, you wrote: >I was just meaning plain SQL - can't microsoft say ANSI? All I ask for is a I don't think there is a standard way of achieving what the LIMIT clause can that works for all or at least most databases. >simple little standard and for people to follow it - I'm not asking for every >feature of the standard - just a following. Well, if you use Metabase you can tell the range of rows that you want to retrieve just by calling MetabaseSetSelectedRowRange($database_handle,$first,$limit) before executing your query. AFAIK, Metabase is the only abstraction layer, not just for PHP but for any other language, that I know that provide this facility portably that is very important for Web application development. Enjoy and be proud of using it. Manuel Lemos >--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 >----------------------------------------------------------------------------- >-- >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net >For additional commands, e-mail: php-general-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net 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 --