Re: Paging support using MS SQL
Mahalie Stackpole <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Thank you for being gentle. I am successfully connected - the engine is on...just don't know how to drive. I should probably find a PHP database list... The guy in charge of the MS SQL db I am accessing is giving me stored procedures and wants me to use recordset paging the way he does with ASP using ADO, specifically pagesize & absolutepage properties. I am reading about the ADOdb library for PHP now. Sorry about the off-topic post! On Thu, Apr 7, 2011 at 12:00 PM, Ken Collins <[email protected]> wrote: > > This is technically a question for another list since FreeTDS is just a means of connecting, not what you do with that connection. That said, Wikipedia might be a good place for you to start before Googling onward. > > http://en.wikipedia.org/wiki/Select_(SQL)#Limiting_result_rows > > I use the TOP and ROW_NUMBER for limit/offset support in the SQL Server Adapter for ActiveRecord. > https://github.com/rails-sqlserver/activerecord-sqlserver-adapter > > > - Ken > >> I apologize in advance for a (probably) RTFM question - have limited >> access to the DB guy for the remote MS SQL server I've been connecting >> to using FreeTDS on CentOS and having trouble finding the right docs >> (answer), have only done simple form processing in the past myself. >> Can someone point me to the correct docs on how to use paging, if >> supported? >> >> I'm currently able to execute stored procedures and handle simple recordsets. > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > -- @mahalie http://23rdworld.com