Re: webdb & fom fields
Date: Fri, 17 Mar 2000 00:18:14 GMT
Message-ID: <aReA4.6904$Nn6.220721_at_newsread2.prod.itd.earthlink.net>
How about using the HTP package? Not documented for WebDB I know. Check out technet.oracle.com for docs on Oracle Application Server. They have a couple of pdf files that explain the HTP and HTP packages. Not all of the OAS features are found in webdb.
<ORACLE>
DECLARE
CURSOR cur IS SELECT xyz FROM mytable ... etc. etc.;
some_value mytable.xyz%TYPE;
BEGIN
OPEN cur;
FETCH cur INTO some_value;
CLOSE cur;
htp.print('<input type = "text" name= "abc" value=' || some_value || '>')
</ORACLE>
Have fun!
-John
John C. Hopkins
Gainesville, FL
"Frank" <fc_at_gte.net> wrote in message
news:3idz4.473$kd7.152754_at_dfiatx1-snr1.gtei.net...
> Using webdb, dynamic page, assume the following:
>
> <oracle>select xyz from mytable</oracle>
> <input type = "text" name= "abc" value=?????>
>
> how can i make the form value (abc) refer to the column value xyz in the
sql
> statement?
>
> how can you do the opposite ? refer to the form field in a sql statement?
>
> thx's
> Frank
>
>
>
Received on Fri Mar 17 2000 - 01:18:14 CET