On Mon, 2006-01-23 at 18:17 +0000, Alan Gauld wrote: > > 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. -- Lloyd Kvam Venix Corp
_______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor