Re: Retrieving warnings after executing a MySQL INSERT statement

2009-08-03 Thread Peter J. Holzer
On 2009-07-28 09:19:05 -0700, David Goodman wrote: I suggest that you check to see if the string $DBI::errstr is empty rather than just whether the 'do' function executed correctly. It seems that the SQL is correctly submitted from the DBI side but the database server actually produces an

RE: Retrieving warnings after executing a MySQL INSERT statement

2009-08-02 Thread Saccone, Scott
: Tuesday, July 28, 2009 11:19 AM To: dbi-users@perl.org Subject: Re: Retrieving warnings after executing a MySQL INSERT statement Hello Scott: I suggest that you check to see if the string $DBI::errstr is empty rather than just whether the 'do' function executed correctly. It seems that the SQL

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;