home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Cool Page Magazine 16
/
CoolPage_16.iso
/
dynadb
/
codes
/
updated.cfm
< prev
next >
Wrap
Text File
|
1997-09-15
|
1KB
|
57 lines
<HTML>
<HEAD>
<TITLE>Example Insert</TITLE>
</HEAD>
<BODY>
<!---
<FORM ACTION="updated.cfm" METHOD="Post">
<CFQuery Name="GetRecord" datasource="Dynamic database">
select * from product
</CFQuery>
╜╨┐∩╛▄¡n¡╫º∩¬║│f½~╜s╕╣<br>
<PRE>
│f¬½╜s╕╣: <SELECT NAME="Prod_id">
<cfoutput query="GetRecord">
<option>#prod_id#
</cfoutput>
</select>
<br><INPUT TYPE="Submit" VALUE="╜T⌐w">
</PRE>
</FORM>
</BODY>
</HTML>
--->
<!-- This is input form. -->
<!--- Query to select record --->
<CFQUERY NAME="GetRecord" DATASOURCE="Dynamic Database">
SELECT * FROM product
WHERE prod_id = #URL.prodid#
</CFQUERY>
<HTML>
<HEAD><TITLE>Example Update</TITLE></HEAD>
<BODY>
<CFOUTPUT QUERY="GetRecord">
<FORM ACTION="updated.cfm" METHOD="post">
<!--- Primary Key value indicating record to update --->
<INPUT TYPE="Hidden" NAME="prod_ID" VALUE="#prod_ID#">
<PRE>
│f½~ªW║┘: <INPUT TYPE="Text" NAME="Product_name" VALUE='#product_name#'>
│f½~║╪├■: <INPUT TYPE="Text" NAME="type" VALUE='#type#'>
╗∙┐·: <INPUT TYPE="Text" NAME="cost" VALUE="#cost#">
<INPUT TYPE="Submit" VALUE="╜T⌐w">
</PRE>
</FORM>
</CFOUTPUT>
</BODY>
</HTML>