Oleg Broytmann wrote:
On Fri, Aug 03, 2007 at 10:55:06AM -0500, Jim Steil wrote:Thanks for the response. I do understand all of that, but in the doc (http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins), it gives the following example:MyTable.select( join=LEFTJOINOn(None, Table1, MyTable.q.name == Table1.q.value)) will return the following sql statement SELECT * FROM my_table LEFT JOIN table2 ON my_table.name = table1.value; I assumed the * was meant as all columns.No, it only means "all columns from MyTable". This has to be mentioned in the docs. The only way in SQLObject to select columns from multiple tables is sqlbuilder.Select(). Oleg.
I've tried that in the past, but I seem to recall that it doesn't return the same type of object as a regular .select(), and that is what is needed for the PaginateDataGrid in TG. Someone, please correct me if I'm wrong, I don't claim absolute knowledge of the tools.
-Jim
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
