Updatinga field with the Image type

[Steven Caliendo]

Hi,

Can someone please tell me how to update a database field with the Image
type ? For example, I have a .gif file on my C:\ drive that I would like to
add to my database. How do I do that ? Insert into Picture Values ( ???? )

Thanks,

Steve

 

[Andy Williams]

the following syntax should work:

INSERT INTO Pictures VALUES ('c:\foo.txt')

-Andy

 

[Steven Caliendo]

Thanks Andy, that works. How do I retieve it ? I tried "select picture
from pictures", but this isn't really a recordset, right ?

Thanks

Steve

 

[Andy Williams]

Boy, do I have mud on my face. I apologize for my clumsy interpretation of
BOL. I apologize for leading you astray, and please disregard my original
post. I was completely wrong.

That said, here's a KB article that might help you out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;255632

I think you'll find that storing images in SQL Server is not always the best
way to go. You'll find many strong opinions either way, here's one:

http://www.aspfaq.com/show.asp?id=2149

-Andy