Jeff, you still haven't confirmed your use of two of the diagnostics I proposed: what does the debugging output say for the CFQUERY? And more important, to rule out all this debate about caching in CFML or the database, what does the SQL Profiler tell you? You can watch live while the queries come into SQL Server based on the CF page being hit. If it really does a query, then you know that it "really is querying the database". If it were to leverage a cached result "in the database", it would tell you it's doing that as well. This really is your best tool.
If it's that you're not familiar with it and are reluctant to explore this page, do just say so. I'm sure many can point out excellent resources to get you started. You could have your answer--and much more compelling diagnostics rather than all this guessing--in minutes. /charlie http://www.carehart.org/blog/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: Tuesday, October 03, 2006 1:58 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Issue with return from cfquery <snip> This "test app" all of a sudden started functioning properly as well when I hit refresh on the browser after lunch. So my issue now is, what are possible causes of this behavior? ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
