I'm working on the same thing right now so I don't have a quick and dirty working example, although it doesn't look to be too difficult to use server side cursors in MSSQL.
Here is a related a link to a similar question at phpbuilder:
http://www.phpbuilder.com/mail/php-db/2001062/0055.php
Snijders, Mark wrote:
$start = 10; $numbers_to_show = 25; $sql = "SELECT * FROM bla Limit $start, $numbers_to_show"; or just go to mysql.com and use the manual :) -----Original Message----- From: Noam Giladi [mailto:noam@i-com-it.com] Sent: woensdag 19 februari 2003 16:00 To: php-db@lists.php.net Subject: "LIMIT" problem MSSQL I'm trying to split results into different pages and number the pages accordingly. I've been able to build a fairly intelligent page numbering system which knows which rows it should pull (at least by numbering each row numerically) but I don't know how to construct a SQL query to pull 10 results starting at a certain number. please did anyone wrote a proc that do it?.
-- John Krewson Programmer - SWORPS -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
