Symfony2 and Doctrine: createQuery error

Question

I am trying to run this query:

$query =  $this->getEntityManager()
    ->createQuery(
            'SELECT MDPIBackendBundle:Articles   
            FROM MDPIBackendBundle:Articles art
            LEFT JOIN MDPIBackendBundle:ScopusFTPUploads uploaded_art WITH art.id = uploaded_art.article_id
            WHERE uploaded_art.article_id IS NULL AND art.pubdate_published >= "'.$startDate.'" AND art.pubdate_published < "'.$endDate.'"'
    );

And I am geting this error:

[Syntax Error] line 0, col 272: Error: Expected Literal, got '"'

Do you know where is the problem? Thank you.

Tomasz Madeyski · Accepted Answer · 2014-10-20 07:31:45Z

1

It seems like a typo, you cant use " in sql/dql. Try:

$query =  $this->getEntityManager()
    ->createQuery(
            "SELECT MDPIBackendBundle:Articles   
            FROM MDPIBackendBundle:Articles art
            LEFT JOIN MDPIBackendBundle:ScopusFTPUploads uploaded_art WITH art.id = uploaded_art.article_id
            WHERE uploaded_art.article_id IS NULL AND art.pubdate_published >= '".$startDate."' AND art.pubdate_published < '".$endDate."');

answered Oct 20, 2014 at 7:31

Tomasz Madeyski

10.9k3 gold badges54 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

Symfony2 and Doctrine: createQuery error

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