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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Error On while executing to insert image on...

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

Rate Topic

Display Mode

Topic Options

Author

Message

raghuldrag

Posted Monday, January 28, 2013 3:50 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 3:53 AM
Points: 94, Visits: 235

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???

Post #1412307

Gazareth

Posted Monday, January 28, 2013 5:25 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 1:53 AM
Points: 1,474, Visits: 2,342

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

Post #1412362

« Prev Topic | Next Topic »

Permissions