Retrieving Images from database

[jigga]

I am using Cold Fusion to link an Access database to my web page. I have put images in the database but i have put them in with a text data type. How can i retrieve them in cold fusion. Should i change the data type in access?

Please Help

Jigga

[sugarkane]

I'm afraid I know very little about Cold Fusion, but I'm not sure whether this can be done or not. You may be able to do something like <img src="show_image.cfm"> where show_image.cfm is an external file that uses the CFCONTENT command to generate an image, but I honestly don't know.

It may be easier to only put the filename of the image into the database, and then insert the retrieved filename into an <img> tag?

Any CF experts out there who can give a better answer?

[Air]

I don't know from a CF point of view either, but the recommendation I have always seen is what Sugarkane describes, use the image file name in the DB but never include the actual binary of the image in the DB. It contravenes DB form from the purists point of view. Not much help I know....