������ ���� Matt
Thursday, October 3, 2002, 6:52:36 PM, �� ��� ������:
MW> I'm currently using MySQLdb (latest version) to connect to a local server
MW> and can connect and insert into most of my tables fine.
MW> However, when I run the following code, it tells me there are three warnings
MW> and raises an exception :
MW> moveSQL = "INSERT INTO processed SELECT a.*, %s, %s FROM incoming a WHERE
MW> a.backupID = %s"
MW> movingCursor.execute(moveSQL,(outcomeStatus,punctual,ID))
MW> I then look in the database and the record has been inserted. Trouble is
MW> a)It's raising an exception
MW> b)I can't actually get to these warnings to see what they are.
MW> Doing the same SQL statement from mysql inserts the record fine.
MW> Can someone shed any light on why these warnings may get raised ?
try:
movingCursor.execute(moveSQL,(outcomeStatus,punctual,ID))
except _mysql_exceptions.Warning, info:
print 'Warning!: ' +string.join(info.args))
except:
print 'Error!'
--
� ���������� �����������,
mielofon mailto:[EMAIL PROTECTED]
_______________________________________________
ActivePython mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython
