472,342 Members | 1,442 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,342 software developers and data experts.

inserted alert

I have been working on a couple of pages that access the same database "A". On one page, the users type in their information and when they submit, it goes into the db "A". The other page is just a page that the staff looks at that displays certain user information in a certain order (data comes from "A"). The staff page refreshes every two minutes automatically or sooner if a staff member presses the refresh button.
A staff member asked me if the staff page can refresh every time a user puts in their information. I'm not sure if I want to change the page, but if I did, how would I go about doing something like that? The user page and staff pages are not really connected to each other. They are both connected to the same db. Should I try to send something from the user page to the staff page that tells it to refresh when submit is press on the user page? Or should I just connect to the db more often and get the records and compare the db recordset with the web page recordset and display if different? Or maybe not compare at all and just refresh the information every minute or something.
Anyone have any ideas?

Aug 29 '07 #1
3 1110
346 Expert 100+
Hmmm... well, with the introduction of AJAX this could be done. You'd have to be intimately familiar with ajax/javascript though.

You could setup a 1 line xml file or text file that simply holds a true/false value, initialized with false. Then, whenever a new submission comes in, you could write true to the file. Now you know that someone has submitted information.

On the page that displays the information from database A to your co-workers, you could have an ajax function check the file for a TRUE value in the background every x seconds (without refreshing the page). If it reads it and the file contains TRUE instead of FALSE you could call a refresh on the page and then set the file back to FALSE, ready for the next submission.

If you want to get even more complicated you could even write an ajax function to redisplay the information on the page even without refreshing.
Aug 29 '07 #2
whoa...ajax is amazing!
I will look into it. Thank you very much!
Aug 29 '07 #3
346 Expert 100+
It certainly is. The best thing to hit the web in about 7 years in my opinion!
Aug 29 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: hshen | last post by:
Hi All, I have encountered a weird behavoir of embedded MySQL. Through a simple program I made (in Delphi 6), I can insert rows to a table...
by: george | last post by:
This is like the bug from hell. It is kind of hard to explain, so please bear with me. Background Info: SQL Server 7.0, on an NT box, Active...
by: serge | last post by:
When i debug a trigger is it possible to add a WATCH on the INSERTED or DELETED? I think not, at least I couldn't figure out a way to do so....
by: baaul | last post by:
I need to INSERT rows from #temp table into #final table with grp_code and bap_id combination. Thanks. Create Table #tmp ( sort_id int...
by: Daz | last post by:
Hi. I would like to know how to obtain a reference to (or at least, element type of) the last node which was inserted into the document. I am...
by: den | last post by:
<input id="txtTop" type="text" onkeyup="fun_control(this)"/> function fun_control(var2) { if ((var2.value== 0) || (var2.value== 1) ||...
by: chirnag | last post by:
I have and audit table to collection changes happening on an entity. This will be taken care by triggers. During a batch test, I found that out of...
by: Kev | last post by:
Hello world, I am trying to capture the latest entry into a text box by the user and then insert it in a separate text box. I must not be searching...
by: JurgenvonOerthel | last post by:
I want to replace one element in a list<stringby a list<stringand I need to obtain an iterator to the first element in the inserted list. In code:...
by: sjdevnull | last post by:
Is there some event I can monitor to tell either if a new li has been created as a child of a certain ul, or to tell if the ul contents have...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.