On 17 May 2006 18:41:55 -0700, [EMAIL PROTECTED] wrote: > Hi - I've got SQL that looks like this ... > cursor = > self.MySQLDb_conn.cursor(cursorclass=MySQLdb.cursors.DictCursor) > sqlQuery = "SELECT * FROM T1 WHERE C1 = %s and C2 = %s" > sql = cursor.execute(sqlQuery,(strURLAlias,strSessionID)) > rows = cursor.fetchall() > cursor.close
ITYM cursor.close() > ... i would be interested in seeing what the actual SQL used by the > .execute looks like after the replacements have been done. Is there a > way of doing this ? Taking a quick peek at pysqlite and the API spec, I'd say no, not a standard way. OTOH, eventually, mysqldb has to create that SQL in order to pass it to the database for execution, so it's probably as simple as finding the right place to put a "print" statement and/or to store the finished SQL in the cursor object. HTH, Dan -- Dan Sommers <http://www.tombstonezero.net/dan/> "I wish people would die in alphabetical order." -- My wife, the genealogist -- http://mail.python.org/mailman/listinfo/python-list
