automatically refreshing value from mssql

[superjett]

As a disclaimer, I have no Java experience, just digging around this morning looking for a direction to a solution hopefully.

I currently have a .php that I use to pull info out of a single row in a mssql db that is updated with info from a production process. I have that entire page set to refresh every 5 seconds to show current data.

That works fine, but I'd like to take it to the next level by adding a graphic showing the system and locate the numbers where they should be instead of just in a table.

I found one example showing a clock that updates (kinda like on nist.gov) and that's essentially what I'm needing, but to pull out of the mmssql db.

Can anyone point me in the direction I need? Just the automatically updating field so I can see if it's way over my head (probably is right now), may stick with the .php page if it is.

Thanks.

 

[carpeliam]

You &lt;i>might&lt;/i> be able to do that with a Servlet in the back-end and an applet in the front-end. Took me a second to think of it But you're right, you can't do that with PHP, or anything else that works on a request/response system. I'm not sure if the effort required to do something like this would be worth the return, if you have no prior Java experience- you'll probably want to investigate the matter further before deciding whether it's worth it. <p>Liam Morley<br><A HREF="mailto:"></A><br>&quot;light the deep, and bring silence to the world.<br>light the world, and bring depth to the silence.&quot;

 

[superjett]

That's the kind of response I was hoping to get, thanks very much.

We're currently using in-house programmed MS Foxpro applications that show realtime data, but Foxpro is so outdated and requires client installed files that don't always work, we're done with it.

Thanks again.

 

[obadare]

try using java.util.Timer and TimerTask packages:

Timer timer=new Timer();

TimerTask tt=new TimerTask(){
public void run(){
the code that queries the database
}

timer.schedule(tt,0,interval for queries);