> >str(Select((Contact.q.id, Contact.q.firstName, Company.q.companyName), > Contact.q.companyID == Company.q.id)) > File "<stdin>", line 1, in ? > ... > "/usr/lib/python2.4/site-packages/SQLObject-0.8dev_r1706-py2.4.egg/sqlobjec >t/sqlbuilder.py", line 452, in __sqlrepr__ > things.append(self.whereClause) > AttributeError: 'tuple' object has no attribute 'append' > > I was hoping to get > 'SELECT contact.id, contact.first_name, company.company_name FROM company, > contact WHERE ((contact.company_id) = (company.id))' >
Well, after playing with it for a few more mintues, I figured it out: >str(Select([Contact.q.id, Contact.q.firstName, Company.q.companyName], Contact.q.companyID == Company.q.id)) in fact does work. It appears that I needed to use a list [...] as the first arg instead of a tuple (...) So much for duck typing :) But I realize that a tuple is immutable and it appears that SQLBuilder was attemping to use append. --gabe ------------------------------------------------------- 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
