home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / addnew.cfm < prev    next >
Text File  |  1997-12-03  |  2KB  |  45 lines
  1. <HTML>
  2. <HEAD>
  3. <TITLE>Example Insert</TITLE>
  4. </HEAD>
  5. <BODY background="paper12l.jpg">
  6.  
  7.     <FORM ACTION="addnew2.cfm" METHOD="Post">
  8.  
  9.     <CFQuery Name="GetType" datasource="Dynamic database"> 
  10.         select * from prodtype
  11.     </CFQuery>
  12.  
  13.     <cfif #GetType.recordcount# is 0>
  14.         ┴┘¿Sª│║╪├■░O┐²íA╜╨Ѳ╖s╝W║╪├■░O┐²íC
  15.     <cfelse>
  16.  
  17.     <form>
  18.     <PRE>
  19.            │f¬½╜s╕╣:     <INPUT TYPE="text" NAME="prod_id">
  20.            │f¬½ªW║┘:     <INPUT TYPE="text" NAME="product_name"> 
  21.            │f¬½║╪├■:     <SELECT NAME="Type">
  22.                 <cfoutput query="GetType">
  23.                     <option>#type_name#
  24.                 </cfoutput>
  25.                  </SELECT> 
  26.            ╝╞╢q:        <INPUT TYPE="text" NAME="quantity">
  27.            ╗∙┐·:        <input type="text" name="cost"><br>
  28.         <INPUT TYPE="Submit" VALUE="└xªs">    <INPUT Type="reset" Value="▓M░ú─µª∞">
  29.     </PRE>
  30.  
  31.     <INPUT type="hidden" NAME="prod_id_required" VALUE="ºA┴┘¿S┐ΘñJ│f¬½╜s╕╣">
  32.     <INPUT type="hidden" NAME="product_name_required" VALUE="ºA┴┘¿S┐ΘñJ│f¬½ªW║┘">
  33.     <INPUT type="hidden" NAME="quantity_required" VALUE="ºA┴┘¿S┐ΘñJ│f¬½╝╞╢q">
  34.     <INPUT type="hidden" NAME="quantity_integer" VALUE="ºA⌐╥┐ΘñJ¬║│f¬½╝╞╢qñú¼O╛π╝╞">
  35.     <INPUT type="hidden" NAME="quantity_range" VALUE ="MIN=0 MAX=9999">
  36.     <INPUT type="hidden" NAME="cost_required" VALUE="ºA┴┘¿S┐ΘñJ│f¬½╗∙┐·">
  37.     <INPUT type="hidden" NAME="cost_float" VALUE="ºA⌐╥┐ΘñJ¬║│f¬½╗∙┐·ñú¼O╝╞¡╚">
  38.     <INPUT type="hidden" NAME="cost_range" VALUE ="MIN=0 MAX=9999.99">
  39.  
  40.     </FORM>    
  41.     </cfif>
  42.     <hr>
  43.     <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  44. </BODY>
  45. </HTML>