Oleg Broytmann wrote:
On Mon, Jan 23, 2006 at 05:03:37PM -0800, Don Smith wrote:
I've searched the docs and the list for an example using Group By.
Select mycolumn, count(*) from mytable Group By mycolumn
SQLOBject's objects are instances of "table" clasess:
class MyTable(SQLObject):
...
In your case it is impossible to return instances of MyTable. because of
this SQLObjects do not support GROUP BY. Only sqlobject.sqlbuilder.Select()
supports GROUP BY...
Something about this needs to go in the FAQ, since Don's question is the
second on the matter in one day I think. I'm not sure what particular
use case to address in the FAQ, though.
--
Ian Bicking / [EMAIL PROTECTED] / http://blog.ianbicking.org
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss