run sql from javascript?

[Tracey]

Hi

I develop and maintain isapi/cgi applications written in Delphi. Within this program, SQL's run on an Interbase Database to present the user with the required data.

I have come to a point where it is necessary for me to display a $rate for a machine dependant on the selection of either a machine (from a select) or a date (just entry or selected from a javascript date-picker). The entry page in question has 10 entry lines, each containing data for different dates and often different machines. These rates are held in a seperate table and change monthly and machine/machine.

This rate is required to be displayed without refreshing the page. Is it possible to pull records from an Interbase database within Javascript? Or perhaps call an action within the existing program which would do this?

 

[gerrygerry]

I dont think you can do this with client-side javascript... sorry! -gerrygerry
Go To

http://quickfreewebsite.com!

 

[joeg99]

the only solution i can think of is to create a iframe with its visibility set to hidden, then place the functions to update the html of the main page in the iframe and update this.

 

[gerrygerry]

Maybe you confused java and javascript - they're totally unrelated. Pardon me if you feel patronized, but it is always necessary to establish this definition before we get started on anything!

Using a java applet, you can maintain a constant refresh of sql results. I have only experimented using java to query MySQL, but I'm sure I could point you the right direction. -gerrygerry
Go To

http://quickfreewebsite.com!

 

[Tracey]

gerry..

patronised.. briefly. but as a relative newbie im kinda used to it
I havent used any java as yet, but maybe i should?

what would be involved? would it be easy to integrate into my app? could it run on Apache is another thing.....



joeg99.. iframe? are we talking "frames"?(excuse my ignorance)

cheers All

 

[joeg99]

a iframe is a 'inline frame' which means it can be placed anywhere in a page and and have its own position and size etc, a bit like a div but its source is a seperate file from the rest of the window.
its visibility can be set to hidden so this can be used to update the contents of the main page without the main page having to be refreshed