php - Symfony Doctrine QueryBuilder -


I try to change this query to Query Builder:

  SELECT * Include invitation from landingpage_sign` as landingpages_content.id as CID LandingPage_ct_centent_id = content.Id is where the content. Enabled = 1and landingpage_site Landing page_id =? ORDER BY LandingPage_sign.order`  

This is my QueryBuilder code:

  $ queryBuilder - & gt; Select ('*, Landing Page _ content as CID') - & gt; ('LandingPage_saint', 'LandingPage_saint') - & gt; Bayangon ('LandingPage_site content_id', 'content .id', tap) - & gt; Where ('content.enabled = 1') - & gt; And ('Landingpages_content.landingpage_id =: id') - & gt; Setpalmator ('id', $ id) - & gt; Orderbank ('landingpage_sign'. Command '', 'asc');  

this return

invalidErmentation exception: query builder can not be included.

you are wrong leftJoin the method is wrong in this way Do something:

  $ querybuilder - & gt; ('LandingPage_content .ID CID as', '') - ('LandingPage_saint', 'LandingPage_saint') - & gt; Left Zones ('(' Content.enabled = 1 ') - & gt; and where (' landingpages_content.landingpage_id =: id '' landingpage_oint content '', 'content', 'on', 'landing page_oint content_id = content.) - & gt; ; Setpamator ('id', $ id) - & gt; orderbase ('landingpage_sign.order', 'asc');  

Comments

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

eclipse plugin - Run java code error: Workspace is closed -

c - Error on building source code in VC 6 -