I'm having some trouble with this issue...I'm using perl DBI and mysql for a customer addressbook. I know MySQL won't needlessly update a row if nothing's changed, but since I'm using $rc = $sth->rows; as an indicator of success, customers will get stuck if they decide they don't want to change anything and they click "update" (shopper can't move forward until some success indicator is sent) . MySQL sends back "0" for rows affected.
I could fake it for UPDATE queries and return successful even though no rows were matched, but then what if there really was a problem? The address wouldn't be updated, but the customer would think it was. I know I can send back rows matched by setting the CLIENT_FOUND_ROWS flag, but then does that mean $sth->rows will return rows matched instead of rows affected for every query in my script (i have several different actions in my script whose success is keyed off of $sth->rows.) I can't find much information on how to set CLIENT_FOUND_ROWS and how to set the flag and use the info. Any help is appreciated! (paul d - BTW, I LOVE "MySQL and Perl for the Web", it's my bible. thanks for writing such a great book) Thanks, Rory On Thu, 2002-03-14 at 09:51, Paul DuBois wrote: > At 10:41 +0100 3/14/02, Rune Steinseth wrote: > >Hi all, > >I have changed database for my Java app to MySQL. The > >app was developed with SQL Server. Some of the logic > >is dependent on getting the no. of rows updated > >returned after an UPDATE query. MySQL does only > >return the rows that are really updated, not the rows > >matched of an UPDATE. This causes problems. > >Is there an easy way to get MySQL always return the > >number of rows matched in an UPDATE? > > There's a flag you can set to control this when connecting to the > MySQL server, if you're using the C API or the Perl DBI API. I > don't think there's an option for this in Java, at least if you're > using the MM.MySQL driver. It seems to set the CLIENT_FOUND_ROWS > flag unconditionally. I guess you could change the source and > recompile. > > >Regards, > >Rune Steinseth > > > >______________________________________________________ > >Sjekk snørapporter... > >fra 500 ski-destinasjoner i Europa > >på http://no.snow.yahoo.com/ > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
