HAHAHAHAHAHAHA!!!
I remember doing this one time!
----- Original Message -----
From: Joe Rinehart
To: CF-Talk
Sent: Monday, August 02, 2004 12:08 PM
Subject: Re: CFFile Question
Donna,
I'd reverse the order of your two queries. You're deleting the
records, then trying to select them ;)
-joe
----- Original Message -----
From: Donna French <[EMAIL PROTECTED]>
Date: Mon, 2 Aug 2004 11:56:10 -0500
Subject: CFFile Question
To: CF-Talk <[EMAIL PROTECTED]>
Trying to go back and update my web app to close the door behind some
things. Trying to delete images from the server when someone deletes
an item from the database.
(I'm using CF 5 & SQL DB)
Here's some code:.
<cfquery name="deleteProduct">
DELETE FROM products
WHERE productid = #URL.productid#
</cfquery>
<cfquery name="deleteImage">
SELECT *
FROM products
WHERE productid = #URL.productid#
</cfquery>
<!--- Delete Images --->
<cfoutput query="deleteImage">
<cffile action=""> file="c:\inetpub\lanescollectibles\images\400\#lanesid#.jpg">
<cffile action=""> file="c:\inetpub\lanescollectibles\images\200\#lanesid#.jpg">
<cffile action=""> file="c:\inetpub\lanescollectibles\images\85\#lanesid#.jpg">
</cfoutput>
Any help greatly appreciated!
TIA,
Donna________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]