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. ===