SQL2005

[Guest]

Hi,

I have developed a .NET application in ASP.NET 2.0.
The website consists of administration module (sort like CMS) where users
can update data and images that I store into an SQL DB.

One of my tables has a Column Type = Image to store the images into my DB
and I would like to have the possibility to update and insert new images into
my DB associated with the text info the user provides.

When updating or inserting new info, I receive the following error :

"Operand type clash: nvarchar is incompatible with image"

Could someone help me with this ?

Thanks,
Bart

 

[Guest]

how are you updating the Image column?
you should pass image data to stored proc( if you are using stored proc) as
image data type only.

av.
http://avnrao.blogspot.com

 

[Cowboy \(Gregory A. Beamer\)]

1. Create a SQL Server stored procedure that accepts the image type.
2. Have the image converted to a byte array
3. Attach this byte array to the image parameter

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***********************************************
Think Outside the Box!
***********************************************