MsSQL LIMIT limit
| From: | Uioreanu Calin | Date: | Thu, 21 Dec 2000 21:02:30 +0000 |
| Subject: | MsSQL LIMIT limit | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5393@lists.php.net to get a copy of this message | ||
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