help needed in understanding how isqlplus works [message #151231] |
Tue, 13 December 2005 17:59 |
amankhan
Messages: 69 Registered: December 2005 Location: Texas
|
Member |
|
|
Hi Guys,
I am trying to run a sql script using iSQLPLUS. It hasnt been configured yet on our web server.
I have a HTML form which has parameters to be entered. When the user clicks submit button, the sql script will run which is placed on the server where isqlplus is configured and display the output in HTML page. I am using SET MARKUP HTML ON in my sql script to display the output in a webpage.
My question is, is it the standard functionality of isqlplus to accept the parameters from the HTML form and send it to the sql script query and display the output in HTML page.
For ex:- i have a query like this:
SET MARKUP HTML ON
select * from emp where empno = &empnumber
in HTML form, i will be passing one parameter with this empnumber. my doubt is how will the value be passed to the script when the user enters some value in the parameter form and presses submit button.
help appreciated in giving some idea about how this isqlplus works
Thanks
|
|
|
|