FreeTDS Development Group

[Mahalie Stackpole <mail AT mahalie.com>]

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 <ken AT metaskills.net> 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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
@mahalie
http://23rdworld.com