MySQLdb select

John Fabiani jfabiani at
Sat Jul 31 10:23:45 CEST 2004

 I'm a newbie and I'm attempting to learn howto create a select statement.
When I use 
>>> string1='18 Tadlock Place'
>>> cursor.execute("SELECT * FROM mytest where address = %s",string1)
All works as expected.  But
>>> numb=10
>>> cursor.execute("SELECT * FROM mytest where clientID = %d",numb)
Traceback (innermost last):
  File "<stdin>", line 1, in ?
  File "/usr/lib64/python2.3/site-packages/MySQLdb/", line 95, in
    return self._execute(query, args)
  File "/usr/lib64/python2.3/site-packages/MySQLdb/", line 110, in
    self.errorhandler(self, TypeError, m)
  File "/usr/lib64/python2.3/site-packages/MySQLdb/", line 33,
in defaulterrorhandler
    raise errorclass, errorvalue
TypeError: int argument required

ClientID was created using "clientID int not null auto_increment primary

What is the correct way passing the numb var to the string?
Thanks John

More information about the Python-list mailing list