Solved

Result set doesn't refresh

Posted on 2000-03-23
3
217 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 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

730 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