mirror of
https://github.com/doctrine/orm.git
synced 2026-03-24 06:52:09 +01:00
DDC-2177: WHERE IN not working #2741
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @doctrinebot on GitHub (Nov 28, 2012).
Originally assigned to: @beberlei on GitHub.
Jira issue originally created by user userfriendly:
I'm going by the docs, trying to get a WHERE IN type of query working with the query builder.
I've got a flat array of IDs, e.g. something like this:
$IDs = array( 228052, 265635, 344498, 391761, 329203, 317911, 305961, 299939, 249429, 344706 );
I've tried the following ways to get this working:
using the Expr class:
$qb->add( 'where', $qb->expr()->in( 'c.id', ':IDs' ));
$qb->setParameter( 'IDs', $IDs );
alternatively:
$qb->add( 'where', $qb->expr()->in( 'c.id', $IDs ));
even direct DQL:
$qb->where( 'c.id IN (:IDs)' );
$qb->setParameter( 'IDs', $IDs );
The generated DQL looks fine:
SELECT c FROM MyEntity c WHERE c.id IN('228052', '265635', '344498', '391761', '329203', '317911', '305961', '299939', '249429', '344706')
But when I call execute() on that query, all these variations give me the following error:
Expected argument of type "Doctrine\ORM\QueryBuilder", "array" given
@doctrinebot commented on GitHub (Nov 28, 2012):
Comment created by userfriendly:
never mind.... it was something i was doing wrong. :) thank god...
@doctrinebot commented on GitHub (Nov 28, 2012):
Issue was closed with resolution "Invalid"
@doctrinebot commented on GitHub (Nov 28, 2012):
Comment created by @ocramius:
[~userfriendly] what was it exactly?
@doctrinebot commented on GitHub (Nov 29, 2012):
Comment created by userfriendly:
The error was thrown by the Symfony Form Framework, not Doctrine. Sorry about that. :-/