What does your code look like? You could potentially try returning the @@ROWCOUNT (if sql server) and use this as a success flag
HTH -----Original Message----- From: bajaria aslam [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 17:28 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481
