Solved

Page refresh when new record is inserted into the database

Posted on 2013-05-28
7
597 Views
Last Modified: 2013-05-28
My classic ASP page displays the records from a SQL Server database table. I wonder if it's possible for the page to auto-refresh every time when users insert a new record.
Thank you for your help
0
Comment
Question by:romsom
  • 3
  • 2
  • 2
7 Comments
 
LVL 33

Accepted Solution

by:
paulmacd earned 500 total points
ID: 39202622
How would the page know a new record was inserted?

You could have the page auto-refresh...
     <meta http-equiv="refresh" content="30">
...where "content" is the time in seconds to refresh the page.
0
 

Author Comment

by:romsom
ID: 39202653
So I guess auto-refresh is the only solution, whether a record is inserted or not...
There's no way for the page to know if a new record was submitted?
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 39202665
No, the page in your browser is static HTML once you get it.  Unless you add javascript / AJAX that checks with the server or use the meta refresh, nothing will change on the screen.
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 33

Expert Comment

by:paulmacd
ID: 39202669
No, because the client (browser) is disconnected from the (web) server.
0
 

Author Closing Comment

by:romsom
ID: 39202699
Thank you very much.
0
 

Author Comment

by:romsom
ID: 39202784
I'm sorry DaveBaldwin; I noticed your comment only after I awarded all the points
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 39202849
No problem.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

705 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

13 Experts available now in Live!

Get 1:1 Help Now