delete record and attach files

[discusmania]

dear guys....

e.g i have records in my oracle db. for each record there is an attach file. what i want is when the prog. delete the record in the database, the attach file will also be deleted. the fields in my db is action and attach. the attach field store the path to the attach file which is stored somewhere else in the same server.

Please help....
Regards,
Nor

 

[iqof188]

You can delete files on your server with the FileSystemObject. Since you have the path stored in your DB, it's quite easy :

<%
dim fso
set fso=CreateObject(&quot;Scripting.FileSystemObject&quot
MyPath=rs(&quot;attach&quot
fso.DeleteFile(MyPath)
set fso=nothing
%>

Of course I assume you already have a recordset (rs) with the path in it. Hope this helps, good luck man!





<webguru>iqof188</webguru>