Hi,
I'm trying to call the following using Doctrine from within Symfony:
$result= Doctrine_Query::create()
->select('E.*')
->from('EventInstance EI')
->where('((SELECT MONTH(EI.datePerformed)) = ?)',
$date->month)
->execute(array(), Doctrine::HYDRATE_ARRAY);
However I get an error back and one portion of the stack looks like
this:
at Doctrine_Connection->execute('SELECT e.dateperformed AS
e__dateperformed, e.memberid AS e__memberid, e.eventname AS
e__eventname, e.amount AS e__amount, e.notes AS e__notes FROM
eventinstance e WHERE () = ?', array(9))in SF_ROOT_DIR\lib\vendor
\symfony\lib\plugins\sfDoctrinePlugin\lib\vendor\doctrine\Doctrine
\Query\Abstract.php line 992 ...
Notice the subquery on MONTH() has vanished from the query string. Is
this a bug or have I done something wrong here? I'm pretty sure the
SQL logic here is correct. I ran it through the mysql command line and
it worked fine.
Any suggestiong would be appreciated. Thanks.
D T
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
