Re: MsSQL LIMIT limit
| From: | Uioreanu Calin | Date: | Fri, 22 Dec 2000 07:21:58 +0000 |
| Subject: | Re: MsSQL LIMIT limit | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-31549@lists.php.net to get a copy of this message | ||
The problem is that I use MsSQL through ODBC, so I will
have to figure out a way to simulate LIMIT through standard SQL.
--
Cordialement,
Uioreanu Calin
-------------------------------------
udmsromkt@mail.dntcj.ro
uioreanu@hotmail.com
Tel: +4094477589
Web: http://www.ecomert.f2s.com
DMS Team Cluj-Napoca Romania
------------------------------------------------
"Joe Koontz" <koontz-koontz@flashcom.net> wrote in message
news:20001221233112.20193.cpmta@c014.sfo.cp.net...
> Try this SET ROWCOUNT 25 ... then the rest of your sql statement.
>
> From the help in SQLExec;
> SET {ANSI_DEFAULTS {ON | OFF}
> | ANSI_NULLS {ON | OFF}
> | ANSI_PADDING {ON | OFF}
> | ANSI_WARNINGS {ON | OFF}
> | CURSOR_CLOSE_ON_COMMIT {ON | OFF}
> | DISABLE_DEF_CNST_CHK {ON | OFF}
> | FIPS_FLAGGER {level | OFF}
> | IMPLICIT_TRANSACTIONS {ON | OFF}
> | NUMERIC_ROUNDABORT {ON | OFF}
> | REMOTE_PROC_TRANSACTIONS {ON | OFF}
> | ROWCOUNT {number | @int_variable}
> | XACT_ABORT{ON | OFF}}
>
> joe
>
> On Thu, 21 December 2000, "Guilherme Mendes" wrote:
>
> >
> > Hi,
> >
> > Some months ago, I tried to use "LIMIT" on MS-SQL too, but didn't work
right....
> > Command like "top" don't work right as "limit" on mySQL.
> >
> > Unfortunately, I needed to choose another bd to my system .......
> >
> > Good Luck
> >
............................................................................
....
> > Guilherme A. Mendes
> > #ICQ: 23662971
> > guilherme.mendes@mailbr.com.br
> >
............................................................................
....
> >
> > ----- Original Message -----
> > From: Uioreanu Calin <uioreanu@hotmail.com>
> > To: <php-general@lists.php.net>
> > Sent: Thursday, December 21, 2000 7:03 PM
> > Subject: [PHP] MsSQL LIMIT limit
> >
> >
> > > Hello,
> > >
> > > I have built a backend system with MySQL and ODBC/MySQL
> > > and , in viewing search results, for buttons like Back and Next
> > > I used MySQL specific LIMIT. Thing is I have to port the system
> > > on MsSQL.
> > > Now I have to rewrite some code and I suppose I could do 2 things.
> > > 1. Rewrite entire code before calling database object's ExecuteQuery
> > > method and not base on LIMIT anymore. (sometimes it was really
> > > necessary, sometimes only for speed reasons)
> > > 2. Rewrite the ExecuteQuery method of database object the way
> > > that when he sees LIMIT manually generates desired output.
> > >
> > > What would be the option you would follow if you were me?
> > > Do you have other solutions?
> > >
> > > Regards,
> > > Uioreanu Calin
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > 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
> > >
> > >
> >
> >
> >
> >
> > --
> > 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
>
>
>
> --
> 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
>