Solved

Can I open a persistent conection using cfhttp?

Posted on 2009-04-14
3
249 Views
Last Modified: 2013-12-24
If I use cfhttp tag in coldfusion to output data from an oracle database, can I maintain a persistent connection so that when the database values change in oracle, the page is updated without refreshing the page?

If not, is there another tag that will do this?
0
Comment
Question by:steveweems
3 Comments
 
LVL 19

Expert Comment

by:Jones911
Comment Utility
No you will have to poll.
0
 

Author Comment

by:steveweems
Comment Utility
Can you explain polling?  Is there a coldfusion tag for that?
0
 
LVL 36

Accepted Solution

by:
SidFishes earned 125 total points
Comment Utility
just to elaborate... an http call can never be "persistent" by designs its a get and forget method. A call to a server happens once, and then server knows nothing about later calls (session variables were invented for this reason..to maintain state)

cfhttp is doing exactly what a browser would do so therefore, it can only do what a browser can do (and less in fact as it doesn't handle javasacript or other things like flash well)

You could use cfschedule to do a cfhttp call every x minutesand but you'd still have to handle screen updates but this probably won;t do what you want

You can "simulate" a persistent connection by doing an ajax call using a JS timer and updating behind the scenes but these are distinct calls to the server/db. This is the way most screen updates are handled in the web 2.0 world but they only look like they're not hitting the server/db... they actually do.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

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…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now