home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / delcust2.cfm < prev    next >
Text File  |  1998-02-04  |  668b  |  29 lines
  1. <HTML>
  2. <HEAD>
  3. <TITLE>ºR░ú╕Ω«╞</TITLE>
  4. </HEAD>
  5. <BODY background="paper12l.jpg">
  6.  
  7. <CFQuery Name="GetCust" datasource="Dynamic Database"> 
  8.     select * from orderproduct where cust_id='#URL.cust_list#'
  9. </CFQuery>
  10.  
  11. <cfif #GetCust.recordcount# greater than 0>
  12.     ºA¡nºR░ú¬║┼U½╚íA┴┘Ñ]ºtªb¡q│µññíC╜╨Ѳ▒N│o¡╙¡q│µºR░ú⌐╬¡╫º∩¡q│µíAªAºR░ú│o¡╙┼U½╚íC
  13. <cfelse>
  14.  
  15.  
  16. <CFQUERY NAME='DelRecord' DATASOURCE="Dynamic Database">
  17.     DELETE FROM customer
  18.     WHERE cust_id = '#URL.cust_list#'
  19. </CFQUERY>
  20.  
  21.  
  22. <cfoutput>
  23.         <H3>ºA⌐╥┐∩╛▄¬║│f¬½╜s╕╣#url.cust_list#ñw╕gºR░úñFíC</H3>
  24. </cfoutput>
  25. </cfif>
  26. <P ALIGN="center"><A HREF="/dynadb/index.htm">ª^¿∞ÑD¡╢</A></P>
  27.  
  28. </BODY>
  29. </HTML>