Updatinga field with the Image type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven Caliendo - 22 Dec 2003 19:22 GMT

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

Reply to this Message

Andy Williams - 22 Dec 2003 20:06 GMT

the following syntax should work:

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

-Andy

> Hi,
>
[quoted text clipped - 5 lines]
>
> Steve

Reply to this Message

Steven Caliendo - 23 Dec 2003 15:32 GMT

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

> the following syntax should work:
>
[quoted text clipped - 13 lines]
> >
> > Steve

Reply to this Message

Andy Williams - 23 Dec 2003 16:45 GMT

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

> Thanks Andy, that works. How do I retieve it ? I tried "select picture
> from pictures", but this isn't really a recordset, right ?
[quoted text clipped - 21 lines]
> > >
> > > Steve

Reply to this Message