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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Suggest Alternate

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-18 : 09:01:42
Ruchika writes "Sir,
I have read your article about not to store images in SQL server.I would like to know then what is the way to relate images with their data in SQL so that everything can be displayed in the browser in a concised way.

Thanking you.
With regards,
Ruchika"

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-18 : 09:23:19
Store the images locally in the hard disk.
Store the path of the image in Database-table.

When retrieve, get the path from Database-table.
Use code to get the image & display
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-18 : 09:28:09
many such questions here, Save the images in a folder and the image path relative to your server root in the table.

If you are using asp, do a response.write(<%=recordset%>)
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-18 : 10:36:10
Refer this also
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -