On Tue, Jan 24, 2006 at 10:46:50AM -0600, Ian Bicking wrote: > 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.
I added a section to the FAQ: http://svn.colorstudy.com/SQLObject/docs/FAQ.txt explaining that not every query can be represented in terms of SQLObject's classes. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------- 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
