home *** CD-ROM | disk | FTP | other *** search
/ Cool Page Magazine 16 / CoolPage_16.iso / dynadb / codes / deltype2.cfm < prev    next >
Text File  |  1998-02-04  |  662b  |  29 lines
  1. <HTML>
  2. <HEAD>
  3. <TITLE>ºR░ú╕Ω«╞</TITLE>
  4. </HEAD>
  5. <BODY background="paper12l.jpg">
  6.  
  7. <CFQuery Name="Gettype" datasource="Dynamic Database"> 
  8.     select * from product where type='#URL.type_list#'
  9. </CFQuery>
  10.  
  11. <cfif #Gettype.recordcount# greater than 0>
  12.     ºA¡nºR░ú¬║║╪├■íA┴┘Ñ]ºtªb│f¬½ññíC╜╨Ѳ▒N│o¡╙│f¬½ºR░ú⌐╬¡╫º∩│f¬½íAªAºR░ú│o¡╙║╪├■íC
  13. <cfelse>
  14.  
  15.  
  16. <CFQUERY NAME='DelRecord' DATASOURCE="Dynamic Database">
  17.     DELETE FROM prodtype
  18.     WHERE type_code = '#URL.type_list#'
  19. </CFQUERY>
  20.  
  21.  
  22. <cfoutput>
  23.         <H3>ºA⌐╥┐∩╛▄¬║│f¬½╜s╕╣#url.type_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>