home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / upddtl2.cfm < prev    next >
Text File  |  1998-01-22  |  2KB  |  54 lines
  1. <HTML>
  2. <HEAD>
  3. <TITLE>¡╫º∩╕Ω«╞</TITLE>
  4. </HEAD>
  5.  
  6.     <!--------------------------------------------------->
  7.     <!-------   1234567890a    -------------------------->
  8.     <!-------   2222@555555    -------------------------->
  9.     <!--------------------------------------------------->
  10.     <cfset seperator=#find(chr(142), selected_order_id)#>
  11.     <cfset ordered_id=#left(selected_order_id, seperator-1)#>
  12.     <cfset product_id=#right(selected_order_id, len(selected_order_id)-seperator)#>
  13.  
  14.     <CFQUERY NAME="GetRecord" DATASOURCE="Dynamic Database">
  15.         select    detail.order_id, detail.quantity, product.product_name
  16.         from    detail, product
  17.         WHERE    detail.order_id = '#ordered_id#' 
  18.             and detail.prod_id='#product_id#'
  19.             and product.prod_id=detail.prod_id
  20.     </CFQUERY>
  21.  
  22.     <cfoutput query="GetRecord">
  23.         <cfset out_order_id=#order_id#>
  24.         <cfset out_product_name=#product_name#>
  25.         <cfset out_qty=#quantity#>
  26.     </cfoutput>
  27.  
  28. <BODY background="paper12l.jpg">
  29.  
  30.  
  31.  
  32. <CFFORM NAME="UpdateForm" ACTION="upddtl3.cfm">
  33.     <cfoutput>
  34.     ¡q│µ╜s╕╣íG    #out_order_id#<br>
  35.     │f¬½ªW║┘íG    #out_product_name#<br>
  36.     </cfoutput>
  37.     ╝╞╢qíG        <CFINPUT TYPE="text" 
  38.                    NAME="qty" 
  39.                    VALUE=#out_qty#
  40.                    REQUIRED="Yes" 
  41.                    VALIDATE="integer" 
  42.                    MESSAGE="ºA┴┘¿S┐ΘñJ╝╞╢q" 
  43.                    SIZE="10"
  44.                    MAXLENGTH="10">
  45.     <br>
  46.         <INPUT TYPE="Submit" VALUE=" └xªs">
  47.     <cfoutput>
  48.     <input type="hidden" name="upd_order_id" value=#ordered_id#>
  49.     <input type="hidden" name="upd_prod_id" value=#product_id#>
  50.     </cfoutput>
  51. </CFFORM>
  52.     <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  53.     </BODY>
  54.     </HTML>