yup Assuming your not getting an error there are one of 2 reasons why this is happening.
1. No rows are being updated - which means none are found in your where clause. As Alex says output the string (or at least the variable used in the where clause to determine the record(s)) and then change to a select statement with same where clause and run in query analyser to see if any records are returned. If none are returned then your where clause is not doing what you expect. 2. If records are returned then if you are using transactions at all (either in SQL or using CFTransaction) make sure that they are being commited -----Original Message----- From: Alex Ninan [mailto:[EMAIL PROTECTED] Sent: 19 June 2003 17:36 To: SQL Subject: RE: Help! Comment the query in a cfquery block. Then output the query as a string and check for syntax and also by running the sql in the DB. Then fix and reapply. Just an idea... -----Original Message----- From: bajaria aslam [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:28 AM To: SQL Subject: Help! Hi All, This was kind of urgent and critical. So, if you all can help me, i will appreciate it. The issue is that there is a query in CF that is supposed to update a column in the database. The logic in CF seems to be good. It has all the checks to see if everything needed is there to update the column in the database. But, for some reason, sometimes, the column for a particular record does not get updated. If I try to duplicate the issue with exactly the same information, i am not able to. The query is executed whenever i try. The query not updating is happening very randomly. Can you all advise me on how i should proceed to check this? (remember, i am unable to duplicate the issue). Do you know what could be the reason for this to happen? Thanks All AB __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
