Could it be a query caching problem? Sounds like those queries shouldn't be cached, but try turning it all off and see if it works.
Also, try moving to a different server to test, if that's fairly easy to do. -glenn > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of [EMAIL PROTECTED] > Sent: Friday, February 27, 2004 2:12 PM > To: [EMAIL PROTECTED] > Subject: [KCFusion] Strange query results in CF5 > > > > 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. > ====================================================== > ========================================================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. =====================================================
