Commit it? Andreas -- Ursprüngl. Mitteil. -- Betreff: [Tutor] Truncating a Table Von: "Leon Keylin" <[EMAIL PROTECTED]> Datum: 11.05.2007 15:39
Why would this not work? import pymssql con = pymssql.connect(host='server name',user='username',password='pwd',database='Database') cur = con.cursor() query="TRUNCATE TABLE Consolidatedmsgs;" cur.execute(query) print "Table Truncated: %d rows deleted" % cur.rowcount ----------- The return I get is that the program runs through but it doesn't actually truncate the table. The user that runs this has all the rights (read, write, truncate, etc...) Any ideas? And yes, I am using a pymssql extension module. _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
