Steven
asked on
query oracle db with asp or other server-side scripting
oracle 10g r2 database
server 2003 r2/iis web server
i have a website that has a few dynamic requirements
this is being used with livelink web forms 9.7.2 however i can generalize the question
a html website comprised mostly of forms (text boxes and drop-downs) will need to have a few html tables hidden/shown based on two oracle db lookups. i was wondering if asp could help me achieve this goal? of course with some javascript to hide/show the tables.
a website is going to load with a text box already containing a value. this text box is called
LL_FormTag_1_2_1
the value in that text box is a unique id which will be used to query a specific row in the LL_PAF_Form table. in the LL_PAF_From table there is a column titled ProjectNumber and this value is what's contained in the LL_FormTag_1_2_1 text box. i need to return results from this row which will help to build the next query.
i need to query how many managers are required to approve an order. the number of managers required exists in the LL_PAF_Form table, column ManagersRequired. this is a number, 1-6. if the value is 4, then 4 html tables will be shown (hence the javascript)
select ManagersRequired from LL_PAF_Form where ProjectNumber = **ValueFromFirstQuery**
from a high level:
- query oracle db
- hide/show html tables based on query results
thanks for the help!!!
server 2003 r2/iis web server
i have a website that has a few dynamic requirements
this is being used with livelink web forms 9.7.2 however i can generalize the question
a html website comprised mostly of forms (text boxes and drop-downs) will need to have a few html tables hidden/shown based on two oracle db lookups. i was wondering if asp could help me achieve this goal? of course with some javascript to hide/show the tables.
a website is going to load with a text box already containing a value. this text box is called
LL_FormTag_1_2_1
the value in that text box is a unique id which will be used to query a specific row in the LL_PAF_Form table. in the LL_PAF_From table there is a column titled ProjectNumber and this value is what's contained in the LL_FormTag_1_2_1 text box. i need to return results from this row which will help to build the next query.
i need to query how many managers are required to approve an order. the number of managers required exists in the LL_PAF_Form table, column ManagersRequired. this is a number, 1-6. if the value is 4, then 4 html tables will be shown (hence the javascript)
select ManagersRequired from LL_PAF_Form where ProjectNumber = **ValueFromFirstQuery**
from a high level:
- query oracle db
- hide/show html tables based on query results
thanks for the help!!!
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Response.write(osRecordset