Re: MsSQL LIMIT limit

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