query oracle db with asp or other server-side scripting
Posted on 2010-11-08
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 website is going to load with a text box already containing a value. this text box is called
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.
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!!!