Error On while executing to insert image on it???

• raghuldrag

  Hall of Fame

  Points: 3160

  More actions

  January 28, 2013 at 3:50 am

  #394036

  create table Wishing

  (

  ID int identity,

  ImageName varchar(500),

  ImagePath varbinary(2000)

  )

  insert into Wishing(Imagename,imagepath)

  values('sunrising','images/sun.jpeg')

  while i am inserting image to to table showing error on use convert and run ur query???

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  January 28, 2013 at 5:25 am

  #1581561

  The ImagePath column is Varbinary data type, and you're trying to insert the value 'images/sun.jpeg', which is not Varbinary type.

  Do you want to insert the actual image or just it's path? The column name & value would indicate the path, the data type the image.

  Thanks

  Gaz