MySQLdb select

F. GEIGER f.geiger at vol.at
Sat Jul 31 15:08:12 CEST 2004


"John Fabiani" <jfabiani at yolo.com> schrieb im Newsbeitrag
news:lGIOc.4961$AY5.4762 at newssvr21.news.prodigy.com...
> Hi,
>  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)

I'm used to do that this way:

cursor.execute("SELECT * FROM mytest where clientID = %d" % numb)

HTH
Franz GEIGER

> Traceback (innermost last):
>   File "<stdin>", line 1, in ?
>   File "/usr/lib64/python2.3/site-packages/MySQLdb/cursors.py", line 95,
in
> execute
>     return self._execute(query, args)
>   File "/usr/lib64/python2.3/site-packages/MySQLdb/cursors.py", line 110,
in
> _execute
>     self.errorhandler(self, TypeError, m)
>   File "/usr/lib64/python2.3/site-packages/MySQLdb/connections.py", line
33,
> in defaulterrorhandler
>     raise errorclass, errorvalue
> TypeError: int argument required
>
> ClientID was created using "clientID int not null auto_increment primary
> key"
>
>
> What is the correct way passing the numb var to the string?
> Thanks John





More information about the Python-list mailing list