RE: Retrieving warnings after executing a MySQL INSERT statement

2009-08-02 Thread Saccone, Scott
the SQL is correctly submitted from the DBI side but the database server actually produces an error message. So this is a server side error message rather than a client side error message. regards, David --- On Tue, 7/28/09, Saccone, Scott wrote: > From: Saccone, Scott > Subject: Retriev

Retrieving warnings after executing a MySQL INSERT statement

2009-07-28 Thread Saccone, Scott
Hello, I was wondering if the DBI can determine if there are warnings after an INSERT statement. For example, here's some MySQL code: mysql> INSERT INTO test(id,name,age) VALUES ("1","Bob","abc"); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> show warnings; +-+--+--