Insert/Update Northwinds photos

• Ian Cockcroft

  Old Hand

  Points: 305

  More actions

  February 26, 2004 at 12:51 am

  #86084

  This is making me crazy.

  How do i insert new image into nothwinds employees table. the photo field???

   

  I use

  INSERT INTO employees (FIRSTNAME, LASTNAME, PHOTO)

  VALUES( 'LOGO1', 'TEST', 'c:\temp\logos\Hazmat.jpg')

   

  It does put something in the field, but when I try view the photo using Crystal Reports 10, it only shows the images that are already in the table.

  I really am going mad. none of the documentation helps.

  Any ides.

  Please

  Thanks

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 26, 2004 at 1:50 am

  #495757

  You cannot do it this way!

  While using ADO and its' Stream Object is probably the most simple method, SQL Server offers WRITETEXT, UPDATETEXT and READTEXT. You may also want to have a look at Textcopy. A small tool that comes along with SQL Server.

  I'm sure I've posted you this link some days ago http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

  

   

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  February 26, 2004 at 1:59 am

  #495761

  this is done from VB

  http://www.winnetmag.com/SQLServer/Article/ArticleID/22973/22973.html

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Ian Cockcroft

  Old Hand

  Points: 305

  More actions

  February 26, 2004 at 2:11 am

  #495765

  Thanks guys, I finally got one of our VB guys to do it with the code provided.

  Thanks again