We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. Database

Mssql adapter

Hi, all

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[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near '@P1'.

any help?



145.0k


79.0k

MSSQL adapter - nice, but IMHO we need full MongoDB support ASAP.



145.0k

Isn'nt MongoDB fully supported in incubator?



79.0k

Incubator, yes. it should be supported out of the box w/o third party libs.



145.0k

It's impossible without breaking BC. MongoDB is fully supported, just for php 5.x, not php 7.x