It wouldn't be whereIn('f.id', array(1,7,8,9)), because 1,7,8,9 are the ids
of the panels.
So I tried fetching the first request as an array (that I did hope would be
an array of Ids) and using that array in whereIn('f.id', $furnitureIdArray)
But it turns out this array is like this: [ 0 => [ 'id' => '1' ,
'furniture_id' => 7 ] , 1 => [ 'id' => '8' , 'furniture_id' => 79 ] ]
So the only solution I found from there was to go through that whole array
and build an array where I only have the furniture ids for my second
request.
Still I don't like that solution in that:
- I have to query the DB 2 times instead of using a subquery
- I have to loop through my first query results to build the arguments of
the second query.
- Something seems pretty wrong in here when I do all this!
2010/8/26 Georg <[email protected]>
> try whereIn('f.id', array(1,7,8,9))
>
> Am 26.08.2010 11:12, schrieb Sebastien Armand [Pink]:
> > 'IN' being one of the worst possible keyword to search online ever, I
> > found nothing interesting to solve my problem, so here it goes:
> >
> > My query should look something like this:
> >
> > Doctrine_Query::create()->from('Furniture f')->where('f.id <http://f.id>
> > IN (SELECT pa.furniture_id FROM Panel pa WHERE pa.id <http://pa.id> IN ?
> > )', array(array(1,7,8,9));
> >
> > so each 'furniture' has many panels, and a panel has a furniture_id. I
> > received a list of panel ids and want to get all the furnitures (sorry
> > for the awful plural) linked to those panels.
> >
> > Doing it this way, when I output the DQL, I see: IN (?,?,?,?), but then
> > have an error:
> >
> >
> > Invalid parameter number: number of bound variables does not match
> > number of tokens
> >
> > If I change the double array into just one array, then the DQL only
> > reads: IN ? and I get the same error since I have 4 parameters but only
> > 1 question mark.
> >
> > I also tried creating another doctrine query on panels:
> > $panQuery = Doctrine_Query::create()->
> > select('pa.furniture_id')->
> > from('Panel pa')->
> > whereIn('pa.id <http://pa.id>', array(1,7,8,9));
> >
> > and having my global query like this:
> > $q =Doctrine_Query::create()
> > ->from('Furniture f')
> > ->where('f.id <http://f.id> IN (?) ', $panQuery->getDql());
> >
> > The output Dql is something I can get, put in my phpMyAdmin and I will
> > get 2 results. I get 0 through doctrine though.
> >
> > Any advice on how to use IN within subqueries is very much welcome!
> >
> > --
> > If you want to report a vulnerability issue on symfony, please send it
> > to security at symfony-project.com
> >
> > You received this message because you are subscribed to the Google
> > Groups "symfony users" group.
> > To post to this group, send email to [email protected]
> > To unsubscribe from this group, send email to
> > [email protected]<symfony-users%[email protected]>
> > For more options, visit this group at
> > http://groups.google.com/group/symfony-users?hl=en
>
> --
> If you want to report a vulnerability issue on symfony, please send it to
> security at symfony-project.com
>
> You received this message because you are subscribed to the Google
> Groups "symfony users" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]<symfony-users%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en
>
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
