Another one from me. You guys are so helpful I'll just keep asking.
Alright.. In ASP with an Access database.
I have set up the backend of the website so I can upload images to a database. The actuual image is stored in a folder and the info for it in the database. I use those images to be displayed on different parts of the website. How would I be able to set it up so I could upload the image and it does not have to have the same file name as the old one and it still gets displayed in the same place? Also I would like to be able to delete the old file while uploading the new image.
Thanks

You need to place a dynamic image source...

Create a recordset on the page that will show the table that contains the filename.

Select 'insert image' and instead of browsing for the image you want to click on data sources at the top of the window.

Now, select the field from the recordset that contains the filename for the image to be displayed.

At the bottom of the window you will now see the code for the recordset field in the 'url' box. Add the path to the folder that the uploads are stored in before the code (e.g. /site/uploadedfiles/<%=.......)

and there you have your dynamic image.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Ok that worked if there is only one image in the database. What if there are several. How do I get it to pick the one I want? My DB fields are.. image_id, image_name, image_location.

Hopefully you have a unique index in your table - then you can a single display page & feed it the unique ID as a variable to pick which record to display.

Regards,
Brent

Ok here are the fields image_id, image_name, image_location. The unique key is image_id. The recordset contains all 3. What I ned to know is how to set it up so the image when pulled from the datasource(image_location) is = to a unique key (image_id)

Sorry - you've lost me...

<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Regards,
Brent

I got it! The name is specific to the picture. So what I did was create a filtered recordset. And it all worked!