On Sun, Dec 21, 2008 at 01:03:34PM -0800, Sean DiZazzo wrote:
> I found this query that gives me the correct results:
>
> """SELECT files.* FROM files INNER JOIN (SELECT MAX(id) AS id FROM files
> GROUP BY filename) ids ON files.id = ids.id"""
>
> The problem is that i can only run it with the _connection.queryAll()
> function which only returns a list of tuples. I need a SelectResults object
> to work with my Turbogears datagrid widget.
>
> Is there any way to cast the list of tuples to a
> sqlobject.sresults.SelectResult object? Or to run the query so that it
> directly returns a SelectResults object?
I think SQLObject currently cannot do that. Try to build an equivalent
query that SQLBuilder can build.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ p...@phd.pp.ru
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
