home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / modify2.cfm < prev    next >
Text File  |  1998-01-22  |  2KB  |  71 lines
  1. <!----------------------------------------------------------------------------------------->
  2. <!---                └╔ªWíGModify2.cfm                     --->
  3. <!---            │o¡╙└╔«╫╖|«┌╛┌Ñ╤ modify1.cfm ⌐╥ѵ¿╙¬║ prod_idíA            --->
  4. <!---            ╖j»┴╝╞╛┌«wíAºΣÑX░O┐²íA╡M½ß┼²Ñ╬ñß¡╫º∩                --->
  5. <!---            ╡M½ßªAѵ╡╣ modify3.cfm │B▓z                    --->
  6. <!----------------------------------------------------------------------------------------->
  7.  
  8. <FORM ACTION="modify3.cfm" method="post">
  9. <HTML>
  10. <BODY background="paper12l.jpg">
  11.  
  12.     <CFQuery Name="GetRecord" datasource="Dynamic Database">
  13.     <!--- url.id_list ¼OÑ╤ URL ╢╟¿╙¬║╝╞¡╚ --->
  14.         select * from product where prod_id='#url.id_list#'
  15.     </CFQuery>
  16.     <CFQuery Name="GetType" datasource="Dynamic Database">
  17.         select * from prodtype
  18.     </CFQuery>
  19.  
  20. <FORM>    
  21. <PRE>
  22.     <cfoutput query="GetRecord">
  23.         <input type="hidden" name="product_id" value="#prod_id#">
  24.         │f¬½╜s╕╣íG     #prod_id#
  25.         │f¬½ªW║┘íG     <INPUT TYPE="text" NAME="product_name" 
  26.                     value="#product_name#" size = 50>
  27.     </cfoutput>
  28.     <!--- Ñ╗¿╙ cfoutput ÑiÑHñúÑ▓ªb│o╕╠░▒ñεíAª²¼OѪ╡▓º⌠¬║│íñ└⌐╡ª∙ª▄▒╡╡█ñU¿╙¬║  --->
  29.     <!--- select ╗yÑy╖φññíA⌐╥ÑH▒NѪñ└ª¿¿Γ│íñ└íAÑiÑHÑO╡{ªí¬║╡▓║cº≤º╣╛π     --->
  30.         │f¬½║╪├■íG    <SELECT NAME="Type">
  31.                 <cfloop query="GetRecord">
  32.                     <cfquery name="GetTypeName" 
  33.                                 datasource="dynamic database">
  34.                         select * from prodtype where type_code='#type#'
  35.                     </cfquery>
  36.                     <cfoutput query="GetTypeName">
  37.                     <option selected>#type_name#<br>
  38.                     <cfset orig_select = "#type_name#">
  39.                     </cfoutput>
  40.                 </cfloop>    
  41.                 <cfoutput query="GetType">
  42.                     <cfif #type_name# is not orig_select>
  43.                         <option>#type_name#<br>
  44.                     </cfif>
  45.                 </cfoutput>                
  46.                 </SELECT>
  47.     
  48.     <cfoutput query="GetRecord">
  49.         ╝╞╢q:         <INPUT TYPE="text" NAME="quantity" value=#quantity#>
  50.         ╗∙┐·:         <input type="text" name="cost" value=#cost#>
  51.     </cfoutput>
  52.     <INPUT TYPE="Submit" VALUE="╜T⌐w">
  53.     </PRE>
  54.  
  55.     <INPUT type="hidden" NAME="product_name_required" VALUE="ºA┴┘¿S┐ΘñJ│f¬½ªW║┘">
  56.  
  57.     <INPUT type="hidden" NAME="quantity_required" VALUE="ºA┴┘¿S┐ΘñJ│f¬½╝╞╢q">
  58.     <INPUT type="hidden" NAME="quantity_integer" VALUE="ºA⌐╥┐ΘñJ¬║│f¬½╝╞╢qñú¼O╛π╝╞">
  59.     <INPUT type="hidden" NAME="quantity_range" VALUE ="MIN=0 MAX=9999">
  60.  
  61.     <INPUT type="hidden" NAME="cost_required" VALUE="ºA┴┘¿S┐ΘñJ│f¬½╗∙┐·">
  62.     <INPUT type="hidden" NAME="cost_float" VALUE="ºA⌐╥┐ΘñJ¬║│f¬½╗∙┐·ñú¼O╝╞¡╚">
  63.     <INPUT type="hidden" NAME="cost_range" VALUE ="MIN=0 MAX=9999.99">
  64.  
  65.     
  66.  
  67. </FORM>
  68. </BODY>
  69. </HTML>
  70.  
  71.