This is a peculiar thing that I've seen before on this machine. The update doesn't work always (from mysql, I hope this isn't happening from the perl scripts as well).
mysql> select iHasPhoto,iNumPhotos from tblListing where iListingID = 10014061; +-----------+------------+ | iHasPhoto | iNumPhotos | +-----------+------------+ | 1 | 0 | +-----------+------------+ 1 row in set (0.27 sec) mysql> update tblListing set iNumPhotos = 1 where iListingID = 10014061; Query OK, 0 rows affected (0.01 sec) mysql> select iHasPhoto,iNumPhotos from tblListing where iListingID = 10014061; +-----------+------------+ | iHasPhoto | iNumPhotos | +-----------+------------+ | 1 | 0 | +-----------+------------+ 1 row in set (0.00 sec) mysql> update tblListing set iNumPhotos = 1 where iListingID = 10014061; Query OK, 1 row affected (0.00 sec) mysql> select iHasPhoto,iNumPhotos from tblListing where iListingID = 10014061; +-----------+------------+ | iHasPhoto | iNumPhotos | +-----------+------------+ | 1 | 1 | +-----------+------------+ 1 row in set (0.14 sec) The system: 4.2-20010320-STABLE FreeBSD The mysql version: 3.23.35 using myIsam tables The table in question (don't mind the lack of indices, this is the test DB): mysql> describe tblListing; +-------------------+--------------+------+-----+------------+---------- ------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+------------+---------- ------+ | iListingID | int(11) | | PRI | NULL | auto_increment | | szPassword | varchar(20) | | | | | | szOwnerName | varchar(50) | | | | | | szPhone1 | varchar(20) | | | | | | szPhone2 | varchar(20) | | | | | | szEmailAddress | varchar(90) | | | | | | szAddress | varchar(100) | | | | | | szAptNumber | varchar(10) | | | | | | szCity | varchar(50) | | | | | | szStateCode | char(2) | | | | | | szPostalCode | varchar(15) | | | | | | iPropTypeCode | tinyint(4) | | | 0 | | | iSqFootage | int(11) | | | 0 | | | iNumFloors | tinyint(4) | | | 0 | | | iNumBedrooms | tinyint(4) | | | 0 | | | fNumBathrooms | float(10,2) | | | 0.00 | | | szLotSize | varchar(10) | | | | | | iGarageSize | tinyint(4) | | | 0 | | | bDescription | blob | | | | | | iAskingPrice | int(11) | | | 0 | | | iFlexTypeCode | tinyint(4) | | | 0 | | | iLoanTypeCode | tinyint(4) | | | 0 | | | iHasPhoto | tinyint(4) | | | 0 | | | dPosted | date | | | 0000-00-00 | | | iActive | tinyint(4) | | | 0 | | | szTransactionCode | varchar(10) | | | | | | szRebillCode | varchar(10) | | | | | | iHits | int(11) | | | 0 | | | iNumPhotos | tinyint(4) | | | 0 | | | szVirtualTour | varchar(255) | YES | | NULL | | | iShowEmail | tinyint(1) | | | 1 | | | dDeleted | date | | | 0000-00-00 | | | szCounty | varchar(50) | | | | | | dEndRun | date | YES | | NULL | | | iAccountNum | int(11) | YES | | NULL | | | szURL | char(3) | YES | | NULL | | +-------------------+--------------+------+-----+------------+---------- ------+ 36 rows in set (0.00 sec) --------------------------------------------------------------------- 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
