Re: except KeyError: print(this was not a key error?)
On Oct 11, 7:48 am, Michel Alexandre Salim michael.silva...@gmail.com wrote: On Oct 10, 7:59 pm, gert gert.cuyk...@gmail.com wrote: http://code.google.com/p/appwsgi/source/browse/appwsgi/wsgi/order.wsgi I screwed up some sql statement INSERT INTO orders (pid,uid,bid,time) VALUES (?,?,2,DATETIME('NOW')), (v['pid']),s.UID) bid does not exist anymore, but why does the KeyError exception occur when only my sql statement is wrong ? Sure it's not from this line? def stats2(db,v,s): db.execute(SELECT * FROM orders WHERE bid=? AND uid=?,(v['bid'],s.UID)) It references v['bid'] Hmm that is also a key error :) -- http://mail.python.org/mailman/listinfo/python-list
except KeyError: print(this was not a key error?)
http://code.google.com/p/appwsgi/source/browse/appwsgi/wsgi/order.wsgi I screwed up some sql statement INSERT INTO orders (pid,uid,bid,time) VALUES (?,?,2,DATETIME('NOW')), (v['pid']),s.UID) bid does not exist anymore, but why does the KeyError exception occur when only my sql statement is wrong ? -- http://mail.python.org/mailman/listinfo/python-list
Re: except KeyError: print(this was not a key error?)
On Oct 10, 7:59 pm, gert gert.cuyk...@gmail.com wrote: http://code.google.com/p/appwsgi/source/browse/appwsgi/wsgi/order.wsgi I screwed up some sql statement INSERT INTO orders (pid,uid,bid,time) VALUES (?,?,2,DATETIME('NOW')), (v['pid']),s.UID) bid does not exist anymore, but why does the KeyError exception occur when only my sql statement is wrong ? Sure it's not from this line? def stats2(db,v,s): db.execute(SELECT * FROM orders WHERE bid=? AND uid=?,(v['bid'],s.UID)) It references v['bid'] -- http://mail.python.org/mailman/listinfo/python-list