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)
 Inserting images as a SQL parameter value.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-19 : 08:39:11
Mike writes "I have a basic table id, date, document

I would like to insert a picture or document etc... into the document field by way of a stored procedure parameter.

The document field is an image data type."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-19 : 08:52:13
It is easy to deal with documents if you store only the physical path than document itself
Read this fully
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

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-19 : 09:04:31
You dont, keep your images in a folder, and the path in the tables, then use a dynamic value to insert into your webpage or vb app.

Many such examples in this forum

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45564
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37980
http://www.sqlteam.com/item.asp?ItemID=986
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-01-20 : 03:51:07
Hi Mike, Welcome to SQL Server

Some ideas here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Images+and+SQL+Server

Kristen
Go to Top of Page
   

- Advertisement -