> On Sun, 2006-01-22 at 21:23 +0300, ZIYAD A. M. AL-BATLY wrote: >> wrong_string = '''SELECT s FROM t WHERE id=%s''' , (email_id) > > The string is being used in a call to cursor.execute. The email_id is a > second parameter getting passed to execute. That is the *correct* > approach to use.
Nope, sorry. This sends the string SELECT ..... id=%s [EMAIL PROTECTED] ie the %s is kept in the string, not what is wanted. The OP must replace the comma with a % character for the string substitution to take place. > That is no help in explaining why the SELECT command is failing to > return the expected results. The rogue %s in the select string will mess things up. Alan G. _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
