On 3 Aug 2012, at 5:08 AM, "Larry G. Wapnitsky" <la...@kvetsch.com> wrote: > grrr ...there's always something in a programming language!
I blame SQL... > > Thanks, Limedrop > > On 8/2/2012 5:43 PM, Limedrop wrote: >> 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 >> >> --