Re: [PHP] MSSQL - Previous/Next Paging Results
> > -Original Message- > > MSSQL seems to be a little bit messier that MySQL..e.g limit clause etc > > > > Anyone know of articles/examples that specifically deal with this issue? > > Look into the Top() function for MSSQL. It goes something like: > > SELECT Top(10) * FROM table > > You should be able to find some info under the msdn.microsoft.com page. > Or, MS has several hundred newsgroups, they should have one for MSSQL. Use TOP in conjuction with mssql_data_seek() to get where you need. Since you can't specify a starting point with TOP like you can with LIMIT, you seek() to the starting point. All other concepts still apply. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MSSQL - Previous/Next Paging Results
Hi, > -Original Message- > MSSQL seems to be a little bit messier that MySQL..e.g limit clause etc > > Anyone know of articles/examples that specifically deal with this issue? Look into the Top() function for MSSQL. It goes something like: SELECT Top(10) * FROM table You should be able to find some info under the msdn.microsoft.com page. Or, MS has several hundred newsgroups, they should have one for MSSQL. -Dan Joseph -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] MSSQL - Previous/Next Paging Results
MSSQL seems to be a little bit messier that MySQL..e.g limit clause etc Anyone know of articles/examples that specifically deal with this issue? Any insight appreciated. Craig -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php