RE: [PHP] (OT) MSSQL - get records #n...n+10?
| From: | James Moore | Date: | Thu, 14 Dec 2000 00:28:46 +0000 |
| Subject: | RE: [PHP] (OT) MSSQL - get records #n...n+10? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-30222@lists.php.net to get a copy of this message | ||
Hmm its late sorry misread MSSQL as MySQL.. Interesting cross post ASP and
PHP group :)
Cheers,
James
P.S. you sure Limit doesnt work in mssql IIRC it is part of SQL92.
> -----Original Message-----
> From: Josh G [mailto:josh@gfunk007.com]
> Sent: 14 December 2000 00:20
> To: PHP User Group
> Subject: Re: [PHP] (OT) MSSQL - get records #n...n+10?
>
>
> No, i already know about it, I'm trying to find the same sort of thing
> in sql server 7
>
> Gfunk
>
> http://www.gfunk007.com/
> ----- Original Message -----
> From: "James Moore" <jmoore@php.net>
> To: "Josh G" <josh@gfunk007.com>; "PHP User Group"
> <php-general@lists.php.net>; "ASP" <activeserverpages@list.15seconds.com>
> Sent: Thursday, December 14, 2000 11:24 AM
> Subject: RE: [PHP] (OT) MSSQL - get records #n...n+10?
>
>
> > You want to look up LIMIT in the Mysql Manual.
> >
> > James
> > --
> > James Moore
> > PHP Quality Assurance Team
> > jmoore@php.net
> >
> > > -----Original Message-----
> > > From: Josh G [mailto:josh@gfunk007.com]
> > > Sent: 14 December 2000 00:12
> > > To: PHP User Group; ASP
> > > Subject: [PHP] (OT) MSSQL - get records #n...n+10?
> > >
> > >
> > > Hi, just wondering, is there an easy way in MS-SQL to get records
> > > #n...#n+10 like mysql's limit keyword?
> > >
> > > Cheers,
> > >
> > > Gfunk
> > >
> > > http://www.gfunk007.com/
> > >
> >
>
>
> --
> 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