Le 19/08/2015 09:20, Bruno Ziegler a écrit :
Following simple example works fine:
|
$stmt =$this->conn->executeQuery(
'SELECT * FROM tableXYZ WHERE id IN (?)',
[[1,4,11]],
[\Doctrine\DBAL\Connection::PARAM_INT_ARRAY]
);
$result =$stmt->fetchAll();
|
why does the named parameter version not work?
|
$stmt =$this->conn->executeQuery(
'SELECT * FROM tableXYZWHERE id IN (:ids)',
['ids'=>[1,4,11]],
[\Doctrine\DBAL\Connection::PARAM_INT_ARRAY]
);
$result =$stmt->fetchAll();
|
Error: Notice: Array to string conversion
This is because you are not saying that the "ids" parameter is an array
(you are saying it for the "0" parameter, which does not exist). Keys in
the list of types must match keys in the list of parameters
--
Christophe | Stof
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
