Image Data ?

• shaley1

  Valued Member

  Points: 64

  More actions

  June 5, 2002 at 7:16 am

  #157913

  Hi;

  I was trying to insert and .jpg image into

  and image column. I looked at the WRITETEXT function. I assmue thats what I should use. What I don't see in the BOL is how I can use this function with a file name ie c:\logo.jpg. Anyone know how to do this ?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 5, 2002 at 8:05 am

  #430360

  I'd recommend using ADO and the stream object. Try this thread:

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=1882&FORUM_ID=9&CAT_ID=1&Topic_Title=Retrieveing%20data%20from%20Image%20field%20??&Forum_Title=General

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter