Re: MsSQL LIMIT limit

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 > >