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