search

fishjerky / phalcon-mssql

phalcon mssql pdo db adapter
22 stars 17 forks source link

Invalid parameter number: no parameters were bound #6

Open ruudboon opened 8 years ago

ruudboon commented 8 years ago

When loading a model with findFirst() I get an error about invalid parameter number.

$result = MyModel::findFirst(1); SQLSTATE[HY093]: Invalid parameter number: no parameters were bound.

Dumping some data I see in the query method the following.

parent::query($sql, $bindParams, $bindTypes);

filled with:

$sql = "SELECT TOP :APL0 mymodel.mymodel_id, mymodel.name FROM mymodel WHERE mymodel.mymodel_id = 1" $bindParams = array ( [APL0] => 1 ) $bindTypes = array ( [APL0] => 1 )

fishjerky commented 8 years ago

are you using phalcon-mssql version 2.x? it's not working now.

ruudboon commented 8 years ago

Ah ok. I'm on 2.0 indeed. I woud love to contribute to this project and get a fullstack MSSQL extension for Phalcon.