Stupid Question.... What ORM are you using? On Tue, Sep 29, 2009 at 1:17 PM, Gareth McCumskey <[email protected]>wrote:
> You do realise of course that writing your own SQL instead of using your > ORM's criteria objects essentially destroys any benefit you get from the > ORM? > > What might be more useful is to see your criteria definitions. > > On Tue, Sep 29, 2009 at 8:43 AM, Dijil <[email protected]> wrote: > >> >> Is there any way in which the below query can be modified so that I >> can get all the results for the cases in which the taggable_id is null >> and to group the results by taggable_id where there is taggable_id? >> >> select business.ID,business.NAME,business.CATCH_LINE,business.ADDRE >> SS_ID,sf_tagging.TAGGABLE_ID from business join member on >> business.MEMBER_ID=member.ID left join sf_tagging on >> (business.ID=sf_tagging.TAGGABLE_ID and >> sf_tagging.TAGGABLE_MODEL='Business') left join sf_tag on >> (sf_tagging.TAG_ID=sf_tag.ID) where (business.NAME LIKE '%testing%' or >> sf_tag.TRIPLE_KEY= 'testing') and member.STATUS='active' and >> business.STATUS= 'active' group by sf_tagging.TAGGABLE_ID >> >> Thx in advance >> >> Dijil >> >> > > > -- > Gareth McCumskey > http://garethmccumskey.blogspot.com > twitter: @garethmcc > > > > > -- As programmers create bigger & better idiot proof programs, so the universe creates bigger & better idiots! I am on web: http://www.alecslupu.ro/ I am on twitter: http://twitter.com/alecslupu I am on linkedIn: http://www.linkedin.com/in/alecslupu Tel: (+4)0748.543.798 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
