mysql_warnings_dbi

This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.



Subject: how to get mysql "warnings" from DBI
From: Dave Dyer <ddyer@bigfoot.com>
Date: Sun, 17 Sep 2000 22:21:38 -0700

When I issue an UPDATE request for an EMUM type field, using an
invalid enum value (ie; not one of the approved list); MYSQL uses
NULL values instead, and returns a "warning" about the bad update.

Is there any way these warnings can be checked for and retrieved
using DBI?  One of the main attractions of using ENUM types was to
prevent Typos from becoming garbage in the database.  This is somewhat
ineffective if the usual database update procedure doesn't detect the
problem.

===

Subject: Re: how to get mysql "warnings" from DBI
From: "Thomas A. Lowery" <stlowery@yahoo.com>
Date: Mon, 18 Sep 2000 01:35:56 -0400

Have your reviewed the return value from the update, also $sth->rows, and
$sth->err?  I'm wondering if any of these reflect the warning message.

===

Subject: Re: how to get mysql "warnings" from DBI
From: Dave Dyer <ddyer@bigfoot.com>
Date: Sun, 17 Sep 2000 23:50:44 -0700

At 10:35 PM 9/17/00, Thomas A. Lowery wrote:
>Have your reviewed the return value from the update, also $sth->rows, and
>$sth->err?  I'm wondering if any of these reflect the warning message.

Nice idea, but no dice.

===



the rest of The Pile (a partial mailing list archive)

doom@kzsu.stanford.edu