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.
--
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.
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
