Philippe Normand - April 19, 2005, 4:15 a.m.
Actually count(), max() and avg() are available. I've not used them for a while, so i don't remember exactly how to use them .. But they're sitting somewhere ;)
anders pearson - Tue 19 Apr 2005 08:22:58
yeah, you can do stuff like Table.select().max("some_column"), but you can't build anything much more complex than that. the specific query that triggered my figuring out how to bypass SQLObject was one like "SELECT n.id,count(k.id) as count FROM ... GROUP BY n.id ORDER BY count DESC LIMIT 5" but it's also come in useful when i wanted to take advantage of some of postgresql's date formatting methods or access a database that uses stored procedures. in general, it just gives me a warm fuzzy feeling to know that as a last resort, i can always drop back to plain old SQL.
SELECT n.id,count(k.id) as count FROM ... GROUP BY n.id ORDER BY count DESC LIMIT 5
with Markdown syntax.
Comments are not displayed until they are approved by a
moderator. Moderators will not approve unless the comment
contributes value to the discussion.