Folks - I have a marketing database where each item in it

has a unique ID number, and each item also has a thumbnail

and fullsize image associated with it.



What I need - is some code ideas on how to delete the two

image files when I delete the unique record from the database

(Access - although I doubt if that makes any difference)..



Ideas? (And direct email besides to the digest would be a great

help..)



Thanks!



====================================

    Don Eilenberger VP-IS

          Bid-Service

      225 Willowbrook Rd

      Freehold, NJ 07728

           xxx-xxx-xxxx

    don_e@b...

====================================

You could have an ASP into which you pass the ID through the 

querystring. 



This ASP then looks up the image file names in the database, uses the

filesystem object to delete the images, then deletes the record from 

the

database



-----Original Message-----

From: Don Eilenberger [mailto:done@b...]

Sent: 21 June 2001 14:50

To: ASP Web HowTo

Subject: [asp_web_howto] Using ASP/VB to delete files?





Folks - I have a marketing database where each item in it

has a unique ID number, and each item also has a thumbnail

and fullsize image associated with it.



What I need - is some code ideas on how to delete the two

image files when I delete the unique record from the database

(Access - although I doubt if that makes any difference)..



Ideas? (And direct email besides to the digest would be a great

help..)



Thanks!

Don,

   I have two recommendations for you. First, take a look at Persits

Software's "AspJpeg" component. You can create the thumbnail images

dynamically. I used it for the 40Plus Photo Gallery's site

(http://www.40plus.com) which made maintenance much simpler.

   Second, consider using the FileSystemObject (FSO) to delete files. All

you have to do is create an instance of the FSO object, set up your path and

file name, and then execute a DELETE on the file (provided the appropriate

permissions are set for the file/folder). I can email you a code example of

this if you like, or you can go to Microsoft's developers site and peruse

the VBScript documentation (also available for download).



----------------------------------------

Gardiner B. Jones, MCSE+I/MCT

Web Wyze Associates

http://24.18.242.122

gardjones@h...

----------------------------------------

What boots up must come down...



----- Original Message -----

From: "Alex Shiell, ITS, EC, SE" <alex.shiell@s...>

To: "ASP Web HowTo" <asp_web_howto@p...>

Cc: <done@b...>

Sent: Thursday, June 21, 2001 10:06 AM

Subject: [asp_web_howto] RE: Using ASP/VB to delete files?





You could have an ASP into which you pass the ID through the querystring.



This ASP then looks up the image file names in the database, uses the

filesystem object to delete the images, then deletes the record from the

database



-----Original Message-----

From: Don Eilenberger [mailto:done@b...]

Sent: 21 June 2001 14:50

To: ASP Web HowTo

Subject: [asp_web_howto] Using ASP/VB to delete files?





Folks - I have a marketing database where each item in it

has a unique ID number, and each item also has a thumbnail

and fullsize image associated with it.



What I need - is some code ideas on how to delete the two

image files when I delete the unique record from the database

(Access - although I doubt if that makes any difference)..



Ideas? (And direct email besides to the digest would be a great

help..)



Thanks!