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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
