home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / adddetl.cfm < prev    next >
Text File  |  1998-01-22  |  1KB  |  59 lines
  1. <!---------------------------└╔ªWíGAdddetl.cfm--------------------->
  2. <!--            │o¡╙╡{ªí¼Oªb│B▓zíu╖s╝W¡q│µív¬║¿╞⌐y    --->
  3. <!----------------------------------------------------------------->
  4.  
  5.  
  6. <HTML>
  7. <HEAD>
  8. <TITLE>┐ΘñJ¡q│µ▓╙╕`</TITLE>
  9. </HEAD>
  10. <BODY background="paper12l.jpg">
  11.  
  12.  
  13.     <CFQuery Name="GetOrder" datasource="Dynamic database"> 
  14.         select * from orderproduct
  15.     </CFQuery>
  16.  
  17.     <CFQuery Name="GetProduct" datasource="Dynamic database">
  18.         select * from product
  19.     </cfquery>
  20.  
  21. <CFFORM NAME="UpdateForm" ACTION="adddetl2.cfm">
  22.       
  23.  
  24.     ¡q│µ╜s╕╣íG    <CFSELECT NAME="order_id"
  25.                     REQUIRED="Yes"
  26.                     SIZE="1"
  27.                     MULTIPLE="no"
  28.                     QUERY="GetOrder"
  29.                     SELECTED="1"
  30.                     VALUE="order_id"
  31.                     DISPLAY="order_id">      
  32.             </CFSELECT>
  33. <br>
  34.     │f¬½╜s╕╣íG    <CFSELECT NAME="prod_id"
  35.                     REQUIRED="Yes"
  36.                     SIZE="1"
  37.                     MULTIPLE="no"
  38.                     QUERY="GetProduct"
  39.                     SELECTED="1"
  40.                     VALUE="prod_id"
  41.                     DISPLAY="product_name">      
  42.             </CFSELECT>
  43. <br>
  44.     ╝╞╢qíG        <CFINPUT TYPE="text" 
  45.                 NAME="quantity" 
  46.                 REQUIRED="Yes" 
  47.                 VALIDATE="integer" 
  48.                 MESSAGE="┐ΘñJ¬║╝╞╢qª│╗~íA╜╨┐ΘñJÑ┐╛π╝╞" 
  49.                 SIZE="10"
  50.                 MAXLENGTH="10">
  51. <br>
  52. <INPUT TYPE="Submit" VALUE="└xªs">
  53. <INPUT type="hidden" NAME="quantity_required" VALUE="ºA┴┘¿S┐ΘñJ╝╞╢q">
  54.       
  55. </CFFORM>
  56. <hr>
  57. <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  58. </BODY>
  59. </HTML>