home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Cool Page Magazine 16
/
CoolPage_16.iso
/
dynadb
/
codes
/
clasupdt.cfm
< prev
next >
Wrap
Text File
|
1997-09-09
|
754b
|
23 lines
<!-- This is input form. -->
<!--- Query to select record --->
<CFQUERY NAME="product_list" DATASOURCE="dynamic database">
SELECT * FROM product
where prod_id=#url.productid#
</CFQUERY>
<HTML>
<HEAD><TITLE>Example Update</TITLE></HEAD>
<BODY>
<CFOUTPUT QUERY="product_list">
<FORM ACTION="backupda.cfm" METHOD="post">
<!--- Primary Key value indicating record to update --->
<INPUT TYPE="Hidden" NAME="prod_id" VALUE="#prod_ID#">
<PRE>
Product name: <INPUT TYPE="Text" NAME="" VALUE='#Product_Name#'>
Type: <INPUT TYPE="Text" NAME="type" VALUE='#type#'>
<INPUT TYPE="Submit" VALUE="Update Information">
</PRE>
</FORM>
</CFOUTPUT>
</BODY>
</HTML>