Query in symfony not working

Question

I have a query in the model of my table: $q = $this->createQuery('a') ->where('a.img1 = null') ->orderBy('a.created_at DESC') ->limit(4); The thing is that it returns nothing, but in DB there is an entry with no image (img1 field is null). What am I doing wrong? thank you

binarious · Accepted Answer · 2011-09-07 14:39:29Z

1

$q = $this->createQuery('a')
          ->where('a.img1 IS NULL') // It needs to be IS NULL instead of = null
          ->orderBy('a.created_at DESC') 
          ->limit(4);

Don't forget ->execute()!

answered Sep 7, 2011 at 14:39

binarious

4,58828 silver badges35 bronze badges

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

2 Comments

Eva Dias Over a year ago

Thank you so much... it's working fine now! I forget the $q->execute(); on the question but I had it in the code already:)

binarious Over a year ago

Yep, I forget it often, too! :)

Collectives™ on Stack Overflow

Query in symfony not working

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related