Re: Next page...odbc style

Hello Digital, On 29-Jun-00 02:01:37, you wrote: >I've seen a lot of snippets for present say 10 results of a query and >then the next 10, etc. All seem to focus on MySQL and its LIMIT >function. >Haven't been able to find a snippet that'll do the same thing with an >ODBC connection to SQL Server 7. >Anyone have any suggestions? Thanks. In MS-SQL it is not that simple. You need to use server side cursors to just retrieve the rows you want. You may want to try Metabase database abstraction package that comes with a MS-SQL driver that supports the retrieval of runtime defined row ranges. With Metabase it is as simple as calling the function MetabaseSetRowRange($database,$start,$limit); before executing your select queries. Take a look here: http://phpclasses.UpperDesign.com/browse.html/package/20 Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --