MySqlDb any way to see the query string

2010-07-10 Thread News123
Hi, I'm using MYSQLdb and have following code db = MySQLdb.connect(**cfg) c = db.cursor() qrystr = "insert mytable set id = %s , other_field = %s" c.execute(qrystr, (id_val,other_field_val) ) What I wondered is whether there is any way to print the 'filled in' query string for debuggin. Th

Re: MySqlDb any way to see the query string

2010-07-10 Thread MRAB
Dennis Lee Bieber wrote: On Sat, 10 Jul 2010 20:22:21 +0200, News123 declaimed the following in gmane.comp.python.general: Hi, I'm using MYSQLdb What I wondered is whether there is any way to print the 'filled in' query string for debuggin. Just edit the MySQLdb cursors m

Re: MySqlDb any way to see the query string

2010-07-10 Thread Tim Roberts
News123 wrote: > >I'm using MYSQLdb > >and have following code > >db = MySQLdb.connect(**cfg) >c = db.cursor() >qrystr = "insert mytable set id = %s , other_field = %s" >c.execute(qrystr, (id_val,other_field_val) ) > >What I wondered is whether there is any way to print the 'filled in' >query str

Re: MySqlDb any way to see the query string

2010-07-10 Thread News123
Hi everybody, im Roberts wrote: > News123 wrote: >> I'm using MYSQLdb >> >> and have following code >> >> db = MySQLdb.connect(**cfg) >> c = db.cursor() >> qrystr = "insert mytable set id = %s , other_field = %s" >> c.execute(qrystr, (id_val,other_field_val) ) >> >> What I wondered is whether t