On Mon, 2006-01-23 at 19:46 +0000, Alan Gauld wrote: > >> >> wrong_string = '''SELECT s FROM t WHERE id=%s''' , (email_id) > >> > > >> The OP must replace the comma with a % character for the string > >> substitution to take place. > > > > The wrong_string line was lifted from the following code in the OP. > > > > entry = db.cursor() > > entry.execute("""SELECT * FROM contact WHERE email_id = %s""", > > (s_email,)) > > > > Ah I see. Yes that's a different proposition entirely! > I really should read the whole thread before jumping in... :-( > > Alan G. >
Well I created the trap by not pasting in the execute call and posting what was on its face an invalid piece of Python coding. -- Lloyd Kvam Venix Corp _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor