How to retrieve an IMAGE from SQL

[pitskin]

I am trying to create a simple website(ASP) where a list of music titles is available from a SQL Server DataBase.
So far I have it working with Artist Name, Release & Cost. However I wish to add a picture of the artist.
My problem is how to retrieve the pictures from the SQL Server DB?
Do I have to load pictures into Database?
Do I need extra software/tools to do this?
So far I have created a new column in my table called picture and set as type image
e.g. alter table music
add picture (image) null
If I store the pictures in a folder,I presume the path to the image can be stored in the DB.
e.g. Table Music
Artist Name Release Cost Picture
Madonna Say a Prayer 10 Euro ..\images\madonna.jpeg

Is this the way? I have a little experience using ASP + SQL at college level.
Help would be appeciated, or directions to a relevant tutorial!
Thanks
I also plan to have small music downloads available for each release, if any one can point me to helpful sites etc. Thanks!

[JBane]

Here's a good article on using image datatypes:

http://www.sqlmag.com/Articles/Index...rticleID=20460

Jeff

[pitskin]

Cheers I'll study the article and see what figure out, haven't been at this site before, looks like there is alot of info here.

Are you using ASP + SQL much or are you migrating away from this language, preferring to use PHP(Linux) or ASP.NET,JSP or some other language entirly?

[JBane]

We use ASP mostly, but are migrating to ASP.net. It seems to work best with SQL Server.

Jeff