Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-08 : 09:53:00
|
| Fayaz Khaki writes "I'm createing a db that compares prices of retail books.What I'm stuck on in SQL is being able to link a item row to a picture. For example if I one of my customers were to select "Book A" he/she would be able to see a picture of the front cover.I'm new to SQL programming, but I know that with other MS Office programs if I were to type "mailto:xyz@email.com" MS Office automatically generates a link for this. I'm looking for somthing similar for my database.NB: My database (SQL Server 2000) is the backend for a web application (designed using UltraDev).RegardsFayaz" |
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2002-03-08 : 10:09:17
|
if it is a web application what is wrong with using <img src=""> and then in the db you can just store the file name. search around at http://www.sqlteam.com/forums/search.asp to find a solution on how to store images in a database. You will find it is better to store the image name instead of the actual image in the db. |
 |
|
|
|
|
|
Linking to a Photo