home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / modify3.cfm < prev    next >
Text File  |  1998-01-22  |  2KB  |  79 lines
  1. <!-----------------------------└╔ªWíGModify3.cfm----------------------------------->
  2. <!--- ªb┤·╕╒¡n¡╫º∩¬║╕Ω«╞ª│¿Sª│┐∙╗~¬║«╔¡╘íA⌐╥Ñ╬¬║╡{ªí╜X⌐Míu╖s╝Wív¬║│íñ└½▄├■ªⁿíC    --->
  3. <!--- ñú╣Lªb┤·╕╒╜s╕╣¼Oº_¡½┬╨«╔íA┤Nª│┬Iñúñ@╝╦íC                    --->
  4. <!--- ½e│íñ└¼░┤·╕╒⌐╥┐ΘñJ¬║╕Ω«╞¼Oº_Ñ┐╜TíAªb│╠½ßñ~«e│\╕Ω«╞º≤╖s            --->
  5. <!--------------------------------------------------------------------------------->
  6.  
  7. <HTML>
  8. <HEAD><TITLE>º≤╖s╕Ω«╞</TITLE></HEAD>
  9. <BODY background="paper12l.jpg">
  10.  
  11.     <!--- ▒N┼▄╝╞▒╥⌐lñ╞  --->
  12.  
  13.     <cfset iserror=false>        <!--- ¿M⌐wª│¿Sª│┐∙╗~╡oÑ═¬║┼▄╝╞        --->
  14.     <cfset dupidx=false>        <!--- ¿M⌐w│f¬½╜s╕╣ª│¿Sª│¡½┬╨¬║┼▄╝╞    --->
  15.     <cfset id_long=false>        <!--- ¿M⌐w│f¬½╜s╕╣ª│¿Sª│╣L¬°¬║┼▄╝╞    --->
  16.     <cfset name_long=false>        <!--- ¿M⌐w│f¬½ªW║┘ª│¿Sª│╣L¬°¬║┼▄╝╞    --->
  17.     <cfset out_type=''>
  18.  
  19.     <cfif len(#product_name#) greater than 50>
  20.         <cfset iserror=true>
  21.         <cfset name_long=true>
  22.     <cfelse>
  23.         <cfset name_long=false>
  24.     </cfif>
  25.  
  26.     <cfif iserror>
  27.         ┐ΘñJñúÑ┐╜TíCºAÑ╟ñFÑHñU┐∙╗~íG<br>
  28.         <cfif id_long>
  29.             │f¬½╜s╕╣ñ╙¬°íC<br>
  30.         </cfif>
  31.  
  32.         <cfif name_long>
  33.             │f¬½ªW║┘ñ╙¬°<br>
  34.         </cfif>                    
  35.  
  36.         <cfif dupidx>
  37.             │f¬½╜s╕╣¡½╜╞<br>
  38.         </cfif>
  39.  
  40.     <cfelse>
  41.         <!---    ªp¬G│q╣LñF⌐╥ª│¬║┤·╕╒íA┤N╖|¿╙¿∞│oñ@│íñ└    --->
  42.         
  43.         <!------------------------------------------------------------------------->
  44.         <!---    ÑHñU│oñ@¼q¼O╝╨╖╟¬║ SQL Ñy¬kíAÑ╬ÑHº≤╖sñ@¡╙░O┐²íC            --->
  45.         <!---    Ñy¬k¼░                                 --->
  46.         <!---        update     [table name]                    --->
  47.         <!---        set     [field1]=[value1],                --->
  48.         <!---            [field2]=[value2],                --->
  49.         <!---                :                    --->
  50.         <!---                :                    --->
  51.         <!---        where [fieldx]=[condition]                --->
  52.         <!------------------------------------------------------------------------->
  53.     
  54.             
  55.         <cfquery name="GetType" datasource="dynamic database">
  56.             select * from prodtype
  57.                 where type_name='#type#'
  58.         </cfquery>
  59.     
  60.         <cfoutput query="GetType">
  61.             <cfset out_type='#type_code#'>
  62.         </cfoutput>
  63.  
  64.         <CFQUERY NAME="UpdateProduct" DATASOURCE="Dynamic Database">
  65.             UPDATE Product 
  66.             SET     prod_id='#product_id#',
  67.                 product_name='#product_name#',
  68.                 type='#out_type#',
  69.                 quantity=#quantity#,
  70.                 cost=#cost#
  71.             where prod_id='#product_id#'
  72.         </CFQUERY>
  73.  
  74.         <CENTER><H2>ºA¡Φñ~⌐╥┐ΘñJ¬║╕Ω«╞ñwº≤╖sª▄╝╞╛┌«wññ</H2></CENTER>
  75.         <HR>
  76.         <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  77.         </BODY>
  78.         </HTML>    
  79.     </cfif>