Hello, According to the sqlobject documentation, when i do a *JOIN*, it should do a SELECT *, however i haven't the same behavior there:
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 1/QueryR : 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. Any idea about that? It would be great if it is possible to have all the informations of the JOIN table. Regards, Arnaud Fontaine ------------------------------------------------------------------------- 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
