LIMIT with ODBC

[mr_zog]

I am trying to limit my results for a query. I am using PHP on a Win2k box running IIS. THe database is a MsSql DB. I am interfacing with it using the ODBC drivers in php and am running in to errors whenever I use the LIMIT statement. Is there a issue with this? Do I need to modify the php.ini to enable this with the ODBC drivers?

Any help would be appreciated.

[Lars_Berg]

It has nothing to do with ODBC.

MSSQL does not understand limit as that clause is specific to Mysql/Postgres.

Use

select top 212 * from ogrish order by ...

[mr_zog]

Thanks , I will give it a spin in a little and get back to you.