I'm trying to implement Mssql adapter on Phalcon 3.1, and encounter a problem with limit when i try
Robots::find(array( 'limit' => 2));
i will get the following sql statment
SELECT TOP :APL0 robots.id, robots.name, robots.type, robots.year FROM "robots"
I thought it will subsitute later, but it didn't, so i got the following error message:
PDOException: SQLSTATE: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near ' @P1'.