Good afternoon, I am trying to do a conditional query with Doctrine as follow, just with a simple select case. $q = Doctrine_Query::create() ->select('a.uid,am.uid,(CASE WHEN a.auctionTypeModel=2 THEN a.buyNowValue WHEN (MAX(ab.value) > 0) THEN MAX(ab.value) ELSE a.startvalue END) as price') ....
If I run this query manually this works, but when trying to run it through doctrine, I have got this nasty error message: "Doctrine: Unknown aggregate alias: CASE" like doctrine try to convert my case statement into table names. Has someone already experienced that and if so, how did this person get around this issue. Thank you very much. -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en To unsubscribe from this group, send email to symfony-users+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.