Ah. Not broke, but poorly-tuned. Thanks Paul, and Philip for all your help.
--Jon ----- Original Message ----- From: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]> To: <dbi-users@perl.org> Sent: Tuesday, April 04, 2006 4:31 PM Subject: RE: Not exactly a dbi question > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 04, 2006 4:20 PM > To: Jonathan Mangin; Garrett, Philip (MAN-Corporate); dbi-users@perl.org > Subject: Re: Not exactly a dbi question > > On 4/4/06 15:06, "Jonathan Mangin" <[EMAIL PROTECTED]> wrote: > > > Autocommit is on. Perhaps you're misunderstanding. An update is not > > supposed to happen if the column to be updated is equal to the data > > being stuffed into it. I want $row to reflect that but $row is > > always 1 even when an update did not happen. Is it broke? > > > > --Jon > > No, the default changed: > > 2003-06-22 Rudy Lippan <[EMAIL PROTECTED]> (2.9002) > * moved pod into mysql.pm from mysql.pod > * Changed the default behaviour of mysql_found_rows, so now > 'UPDATE table set field=?' will return the number of rows matched > and not the number of rows physically changed. You can get the old > behaviour back by adding "mysql_found_rows=0" to the dsn passed > to connect. Sorry, I've been answering your question while assuming the mysql driver conformed to the documented DBI interface. Perhaps this is a mysql thing, not a DBD::mysql thing? Oh well. Philip