I have 2 different CF pages (running on CF5) that have 2 queries in them. Yesterday the pages appeared to be work. Today, when I execute the pages, one of the 2 queries successfully updates the row in question, the other query does not. It is as if the query never ran. With debugging turned on, I copy the supposedly executed SQL queries to MS SQL 2000's query analyzer and run them. Both run fine.
It is the same 2 queries that don't run each time. CF does not kick out any error message and CF makes it look like they ran, but a select from the tables (manually) after the fact shows the data has not been updated. Manually running the queries, it works. I experienced other bizarre errors with having to scope some query values as variable.name when looping over query results on other pages. Has anyone had similar strange results on CF5 or others before? I only have a few hours to solve this problem. Ryan ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
