SQLSRV Query Result Limit

[B1Q]

Hello, i was wondering if fluentpdo will support LIMIT for SQLSRV not MySQL i doubt you don't know this but i will explain using queries

MySQL: select * from _table where col1 = '123' Limit 10 MSSQL: select TOP 10 * from _table where col1='123'

i tried to mess with the src to get the result i wanted but i couldn't do it haha

Regards

[cbornhoft]

The only way this could be done would be for Fluent to be aware of the database environment by either using a detection system, or a user-supplied argument passed to the constructor.

[B1Q]

yeah hopefully they would consider doing that

[hapm]

There is a very good overview of possible result limitations on wikipedia. How about implementing some of them and allow to configure the behaviour to use from php on the FleuntPDO object like debug and convertTypes? So it is the applications responsibility to set the behaviour correctly.