From raw sql query to symfony 2 sql query

Question

I have this sql query:

SELECT * from gift WHERE NOW() >= `validbegin` AND NOW() <= `validend` ORDER BY `points`n ASC

I need to transform it to a Symfony 2 query to fetch the data to an object call Gift. So far I have this:

    $query = $giftRepository->createQueryBuilder('p')
        ->where('NOW() >= validbegin AND NOW() <= p.validend')
        ->orderBy('p.points', 'ASC')
        ->getQuery();
    $gifts = $query->getResult();

But that gave me:

[Syntax Error] line 0, col 53: Error: Expected known function, got 'NOW'

Any idea?

ps. Also tried p.NOW()

what kind of field it is , datetime ?

mpm
– mpm

2013-01-24 20:48:15 +00:00
Commented Jan 24, 2013 at 20:48 — mpm
– mpm, Commented Jan 24, 2013 at 20:48

Hugo Dozois · Accepted Answer · 2013-01-24 21:43:15Z

1

Try this :

$query = $giftRepository->createQueryBuilder('p')
    ->where(':now >= validbegin AND :now <= p.validend')
    ->setParameter('now', new \DateTime())
    ->orderBy('p.points', 'ASC')
    ->getQuery();
$gifts = $query->getResult();

You generate the field from php, then doctrine will automatically convert it to a mysql timestamp

answered Jan 24, 2013 at 21:43

Hugo Dozois

8,49812 gold badges56 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

From raw sql query to symfony 2 sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related