Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

Best way for a browser to periodically check for changes in a database table?

I have a website where job details are entered into a database. A program from a backend server grabs these details and tries to price it... when this is done it changes the status field of the job to 'priced'. This may take 30sec so the browser needs to continuously check the database for a 'priced' value.

At the moment we have a javascript function that re-loads the page every 2 seconds, which causes the page to check the status of the field every time. If the status field becomes 'priced' within 30sec then it'll continue. Otherwise it'll say job cannot be priced.

Does anyone know a more effective way of doing this with AJAX for example... or at least point me in the right direction.

Thanks.



0
robaherne
Asked:
robaherne
  • 2
2 Solutions
 
crazymanCommented:
Use an ajax update panel and reload it every x seconds.

http://encosia.com/2007/07/25/display-data-updates-in-real-time-with-ajax/
0
 
crazymanCommented:
0
 
robaherneAuthor Commented:
Great stuff! Thanks a lot!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now