home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / deldtl2.cfm < prev    next >
Text File  |  1998-01-22  |  654b  |  25 lines
  1. <HTML>
  2. <HEAD>
  3. <TITLE>ºR░ú╕Ω«╞</TITLE>
  4. </HEAD>
  5. <BODY background="paper12l.jpg">
  6.  
  7.  
  8.     <cfset seperator=#find(chr(142), selected_order_id)#>
  9.     <cfset ordered_id=#left(selected_order_id, seperator-1)#>
  10.     <cfset product_id=#right(selected_order_id, len(selected_order_id)-seperator)#>
  11.  
  12.     <CFQUERY NAME='DelRecord' DATASOURCE="Dynamic Database">
  13.         DELETE FROM detail
  14.         where     order_id='#ordered_id#' and
  15.             prod_id='#product_id#'
  16.     </CFQUERY>
  17.  
  18.  
  19.     <cfoutput>
  20.     <H3>ºA⌐╥┐∩╛▄¬║¡q│µ▓╙╕`íA¡q│µ╜s╕╣¼░ #ordered_id# íA│f¬½╜s╕╣¼░ #product_id# ñw╕gºR░úñFíC</H3>
  21.     </cfoutput>
  22. <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  23.  
  24. </BODY>
  25. </HTML>