Re: [web2py] Re: LEFT JOIN query issues

[Larry G. Wapnitsky]

grrr ...there's always something in a programming language!

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


--

--