This gets me every now and then... In python it should be "==" rather than "="
left=db.mr_link.on(db.mr_link.recipID==db.recipient.id)) On Friday, August 3, 2012 8:08:38 AM UTC+12, Larry Wapnitsky wrote: > > I'm trying to take the following MySQL query > > SELECT recipient.emailAddress > FROM recipient > LEFT JOIN mr_link ON recipient.id = mr_link.recipID > > > > and turn it into a DAL query, but I keep running into 'keyword' issues > > My code is as such: > > rows = db().select(db.recipient.emailAddress, db.mr_link.ALL, left=db. > mr_link.on(db.mr_link.recipID=db.recipient.id)) > > but I keep receiving > > <type 'exceptions.SyntaxError'> keyword can't be an expression > (default.py, line 25) > > Assistance in solving this would be very helpful > > Thanks > > > --
