insert into session sql syntax error

[brian@…]

I was getting error message about incorrect syntax for the "INSERT INTO session" statements.

I changed this

                       c.execute(
                       """INSERT INTO session
                           (sid, authenticated, last_visit)
                       VALUES """,(result[0]['username'].encode('utf-8'), '1', result[0]['last_visit'].strftime('%s')))

to this

                       c.execute( "INSERT INTO session (sid, authenticated, last_visit) VALUES ('%s', %s, %s)" % (result[0]['username'].encode('utf-8'), '1', result[0]['last_visit'].strftime('%s')) )

and it worked.

I don't know the term for these python long quotes, so please retag this ticket appropriately.

Oh it just dawned on me. You can probably keep the params version of the execute(), but you need to mark the parameters in the query with question marks, or $1, $2, or $3, or something. Shrug, i dunno, it's my first day speaking python.

[simona@…]

Try to spam my mail plz.

[Anton Stroganov]

thank you