http://www.digitalbase.eu/blog A blog about webdesign, PHP, development and IT Mon, 10 May 2010 16:16:55 +0000 http://backend.userland.com/rss092 en Earlier this week, I talked about our custom datagrid for Propel and how it was being rewritten to interact with our CriteriaBuilder (read more). Well, I'll give you another glance into our coding efforts. Goal We wanted to make an object, which would manipulate the data being shown in our grid_propel. For normal people, this means: to ... http://www.digitalbase.eu/blog/xajax-driven-criteriabuilder-for-propel-php/ Simplifying Queries: Using sum, count, etc in Propel $c->addSelectColumn('sum('.dbTimeBlockPeer::TOTAL.') as total'); $rs = dbTimeBlockPeer::doSelectRS($c); while ($rs->next()) { $total = $rs->getInt(1); } So, simply use addSelectColumn. You have to work with the ResultSet offcourse, since you won't be able to populateObjects. In this case you can simply use '1' in getInt(column index), since we're sure only ... http://www.digitalbase.eu/blog/simplifying-queries-using-sum-count-etc-in-propel/