Solved

Result set doesn't refresh

Posted on 2000-03-23
3
203 Views
Last Modified: 2013-12-24
My application does some simple queries (cfupdates, cfinserts), but sometimes the results displayed don't accurately reflect the contents of the database.  My browser is set to reload the page on every visit and the database does have the correct data in it during these queries.  Does CF cache resultsets or use cached pages even though disabled in the browser (IE)?  Any other ideas?  Please help.  Thanks.
0
Comment
Question by:peteodonnell
  • 2
3 Comments
 
LVL 6

Expert Comment

by:acampoma
ID: 2654352
I had the same problem. and I found this solution on a site called www.cfnewbie.com
let me know if it works!!
Alex


Insert these line at the top of your templates.
<meta http-equiv="pragma" content="nocache">
<meta http-equiv="expires" content="1 January 1900 00:00:00 PST">

I actually put them in my application.cfm
0
 
LVL 2

Author Comment

by:peteodonnell
ID: 2655205
The problem was actually that a query was being executed in the application.cfm and later javascript was attempting to load multiple frames also executing queries.  
Somehow I think CF was caching old resultsets because of this.  
This leads me to another question.  Is the application.cfm prepended to all templates loaded?  Do you know of any good documentation on the application.cfm and how it is actually processed?
0
 
LVL 6

Accepted Solution

by:
acampoma earned 20 total points
ID: 2655427
The application.cfm is prepended to all cold fusion templates in any subfolder.
if you have an application.cfm in your main directory, all templates will use this application.cfm unless there is another application.cfm in a subdirectory. Any templates in that subdirectory or lower will use the second application.cfm file.
I have found some documentation on the topic in mastering cold fusion 4.
But mainly I just usee the application.cfm for for global variables such as database name, background, etc.
hope this helps
Alex
 
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question