Need some help with ColdFusion and Access

1

I am making an online store using Coldfusion MX and Access. I have a data base created in Access. What I want to do is have a small image appear when the database is opened on my web site. For example…I have field names in my database of Product Name, Size and Price. What I want is when that info is displayed, I want a small image of the product to appear as well.

Anybody have any idea how to do that?

Thanks

2

i’m guessing the same way you would with the information. If you can retrieve the information out of the database then put the URL to the image in the database as well and have that associated with the information and just print it with the infomraitno… i guess…

I don’t use coldfusion or access…

3

Jubba’s solution of saving the image name as a value in the database is one solution I’ve used, another is to simply name the images based on a unique value for that item that is already saved in the database. An auto-number index ID if you’re using one, or perhaps the inventory number of the item, as long as it’s unique to that item. Just save the images in a designated folder with the associated image name. To insert the image into the dynamic page just insert the dymanic part of the file name for that item into the IMG tag.

Toby