Hi Bernhard,
thank you for information!
Regards,
Johannes
On 25 Okt., 21:41, Bernhard Schussek <[EMAIL PROTECTED]> wrote:
> Hi Johannes!
>
> Lately I was told on the #doctrine IRC channel, that the correct
> constant to use in this case is Doctrine::HYDRATE_ARRAY. It is only by
> chance that Doctrine::HYDRATE_ARRAY and Doctrine::FETCH_ARRAY share the
> same integer value, but should one of both constants change in a future
> release, your application will probably break.
>
> Regards
> Bernhard
>
> Am Donnerstag, den 25.10.2007, 06:45 -0700 schrieb Johannes Schmidt:
>
> > 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);
>
> > 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
-~----------~----~----~----~------~----~------~--~---
