?
Solved

Result set doesn't refresh

Posted on 2000-03-23
3
Medium Priority
?
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 60 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month13 days, 2 hours left to enroll

777 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