I changed the addWhere to addHaving:
$q->addSelect('c.starts_at + c.minutes_long*60 AS
finishes_at');
$q->addHaving("finishes_at >= ?", time());
And It doesn't work yet. I get the following error:
SQLSTATE[HY000]: General error: 1 no such column: c__0
I am using sqllite, could that be the problem?
On Mar 10, 7:21 pm, Jim Krehl <[email protected]> wrote:
> On 03/10/2010 01:10 PM, miguelSantirso wrote:
>
> > Hi, I have a starts_at field that keeps the date in which certain
> > event starts or has started (in UNIX seconds). Also, I have a
> > minutes_long field. I need to filter all the objects that are already
> > finished and I tried adding the following to my original query:
>
> > $q->addSelect('c.starts_at + c.minutes_long*60 AS finishes_at');
> > $q->addWhere("finishes_at>= ?", time());
>
> > However, Doctrine doesn't seem to recognise "finishes_at" in the
> > "addWhere" statement. I don't know if this is the expected behavior of
> > Doctrine. If so, how could I write an equivalent query?
>
> Is MySQL your db? I don't believe MySQL supports using column aliases
> in a where clause [1]. Try changing $q->addWhere to $q->addHaving ?
>
> jimmyk
>
> [1] A /|select_expr|/ can be given an alias using |AS /|alias_name|/|.
> The alias is used as the expression's column name and can be used in
> |GROUP BY|, |ORDER BY|, or |HAVING| clauses. <-
> fromhttp://dev.mysql.com/doc/refman/5.0/en/select.html
--
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
