Re: [symfony-users] Help with doctrine SQL

2010-05-24 Thread Philipp Mohrenweiser
Not a collection ? so you should probably use a limit 1 statement ... but if you want to get back multiple entrys the collection should be the right thing !? 2010/5/24 Simone Fumagalli : > Hello. I'm trying to write this SQL statement in DQL ! > > The SQL looks like : > > SELECT SUM(col1), SUM(

[symfony-users] Help with doctrine SQL

2010-05-24 Thread Simone Fumagalli
Hello. I'm trying to write this SQL statement in DQL ! The SQL looks like : SELECT SUM(col1), SUM(col2), SUM(col3) FROM slave_table WHERE master_id = ? AND ( (year = ? and month < ? and priority = ?) OR (year = ? and month > ? and priority = ?) ) I also would to get back a SlaveTable object and