Hi Matthias,
thank you very much - works fine. I really don't know what effect
$params in
execute ([$params = array()], [ $hydrationMode = null])
has...
Regards,
Johannes
On 25 Okt., 16:28, Matthias Nothhaft <[EMAIL PROTECTED]> wrote:
> Johannes Schmidt schrieb:
>
> > Hi all,
>
> > I'm using sfDoctrine and have the following problem concerning
> > prepared statements and Doctrine::FETCH_ARRAY. I wrote:
>
> > $q = new Doctrine_Query();
> > ...
> > ->where('utc.community_id = :cid AND utc.role = 0', array(':cid'=>
> > $cid));//$cid = 3
> > ...
> > $founder = $q->execute(array(1), Doctrine::FETCH_ARRAY);
>
> try this:
> $founder = $q->execute(array(), Doctrine::FETCH_ARRAY);
>
> Regards,
> Matthias
>
> > The array contains 1 alias :cid.
> > Symfony throws an exception then:
>
> > [Doctrine_Connection_Mysql_Exception]
> > SQLSTATE[HY093]: Invalid parameter number: number of bound variables
> > does not match number of tokens
> > ...
> > at Doctrine_Connection->execute('SELECT DISTINCT u3.id FROM user u3
> > INNER JOIN user_to_community u4 ON u3.id = u4.user_id WHERE
> > (u4.community_id = :cid AND u4.role = 0) LIMIT 1', array(':cid' =>
> > '3', '1'))
>
> > What happens is that the array containing the alias :cid is filled
> > with with the "1" from the array in the execute-function.
> > So writing $founder = $q->execute(array(2), Doctrine::FETCH_ARRAY)
> > leads to:
> > ... array(':cid' => '3', '2')
>
> > Does anybody know this problem? Is that a PDO or a Doctrine bug?
>
> > Regards,
> > Johannes
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
