I've been banging my head trying to solve an update or insert problem. Most of you out there would have probably encountered it.
I was relying on MySQL returning the number of rows when doing update. I was getting only 0E0 for a successful update. After going through Pau DuBois book on MySQL I realized that MySQL returns row count for successful update only if there has been any change in the columns. According to the book, CLIENT_ROW_COUNT (dont remember the name well) option needs to be exercised at connection time so it can return a count even if all the columns were same. I wonder if this is so with other databases or something unique to MySQL. _______________________________________________ Boston-pm mailing list [EMAIL PROTECTED] http://mail.pm.org/mailman/listinfo/boston-pm
