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/?[EMAIL PROTECTED]
>> --
>> E-mail: [EMAIL PROTECTED]
>> URL: http://www.mlemos.e-na.net/
>> PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
>> --
>>
>--
>-----------------------------------------------------------------------------
>-- Joe Stump, PHP Hacker, [EMAIL PROTECTED]
> -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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?[EMAIL PROTECTED]
--
E-mail: [EMAIL PROTECTED]
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
