[Tutor] Searching for email id in MySQL giving wrong results

Python python at venix.com
Mon Jan 23 15:15:57 CET 2006


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.

That is no help in explaining why the SELECT command is failing to
return the expected results.

-- 
Lloyd Kvam
Venix Corp



More information about the Tutor mailing list