Python/MySQL Frustration

John Nagle nagle at animats.com
Sun Sep 20 20:16:46 EDT 2009


Dennis Lee Bieber wrote:
> On Sun, 20 Sep 2009 14:25:53 -0400, Victor Subervi
> <victorsubervi at gmail.com> declaimed the following in
> gmane.comp.python.general:
> 
>> Hi;
>> I have the following code:
>>
>>      while i < num:
>>       cat = 'cat' + str(i)
>>       cat = form.getfirst(cat, '')
>>       item = 'item' + str(i)
>>       item = form.getfirst(item, '')
>>       descr = 'descr' + str(i)
>>       descr = form.getfirst(descr, '')
>>       uom = 'uom' + str(i)
>>       uom = form.getfirst(uom, '')
>>       price = 'price' + str(i)
>>       price = form.getfirst(price, '')
>>       sql = 'Category="' + cat + '", Item="' + item + '", Description="' +
>> descr + '", UOM="' + uom + '", Price="' + price + '"'
>>       sql = 'insert into %s values (%s);' % (company, sql)
>>       cursor.execute(sql)
>>       i += 1
> 
> 	Forgive me, but that is a bit of a mess... And from what I can see,
> does not even generate valid insert statements unless MySQL has expanded
> the syntax greatly.

     You're probably throwing an exception at "cursor.execute".  Are you catching
exceptions somewhere else?

     Also, you need to call "commit()" when you're done updating, or, at program
exit, all your changes to the database will be undone, at least if you're using
any of the database engines that do transactions.

					John Nagle



More information about the Python-list mailing list