MySQLdb select

John Fabiani jfabiani at yolo.com
Sat Jul 31 18:33:09 CEST 2004


thanks that worked but I don't understand why.
cursor.execute("SELECT * FROM mytest where address = %s",string1)
above works but  - following your suggestion:
cursor.execute("SELECT * FROM mytest where address = %s" % string1)
above does not work.  So why did 
 cursor.execute("SELECT * FROM mytest where clientID = %d" % numb)
work???????????????
john
F. GEIGER wrote:

> 
> "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 member")
>> 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