On Sat, Aug 19, 2006 at 10:16:54PM +0200, Arnaud Fontaine wrote:
> list(model.TrackerPackage.select(join=LEFTJOIN(None,model.CustomFlagData)))
> 1/Select : SELECT tracker_package.id, tracker_package.lock_date,
> tracker_package.lock_period, tracker_package.done_by_date,
> tracker_package.info_id, tracker_package.locked_by_id,
> tracker_package.done_by_id, tracker_package.tracker_id FROM
> tracker_package LEFT JOIN custom_flag_data WHERE 1 = 1
>
> It doesn't do a SELECT * at all.
.select() only selects columns for its table; TrackerPackage in this
case.
> It would be great
> if it is possible to have all the informations of the JOIN table.
It wouldn't. Where should SQLObject put this information?
class MyTable(SQLObject):
name = StringCol()
age = IntCol()
I have declared a table with two columns. If I join the table with another
table - where SQLObject should put additional columns? There are no
definitions for them. Even worse - if I join the table with itself (using
Alias) - how do I distinguish columns form one table from the columns from
the same joined table?
When one does .select() on a table SQLObject only fetches columns for
that table.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
