Re: MsSQL LIMIT limit

I don't know about ODBC, but I would try and stick with the LIMIT(x,y) command, otherwise you are going to have to wade through more data than you really need. Just a thought. Jeremy Brand :: Sr. Software Engineer :: 408-245-9058 :: jeremy@nirvani.net http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more Get your own Free, Private email at http://www.smackdown.com/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - "<body>" -- Quoted from Yahoo! homepage, http://www.yahoo.com On Thu, 21 Dec 2000, Uioreanu Calin wrote: > Date: Thu, 21 Dec 2000 23:03:00 +0200 > From: Uioreanu Calin <uioreanu@hotmail.com> > To: php-general@lists.php.net > 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 > >