-
How to retrieve an IMAGE from SQL
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!
-
Here's a good article on using image datatypes:
http://www.sqlmag.com/Articles/Index...rticleID=20460
Jeff
-
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?
-
We use ASP mostly, but are migrating to ASP.net. It seems to work best with SQL Server.
Jeff
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|