I am getting this error when I try to update my database:

 

The data types text and nvarchar are incompatible in the equal to operator.

 

The SQL datatype is 'text'

Here is my SQL statement:

Here is my SQL statement:

UpdateCommand="UPDATE [cbc_pages] SET [docID] = @docID, [leftColumn] = @leftColumn, [rightColumn] = @rightColumn, [links] = @links WHERE [id] = @original_id AND [docID] = @original_docID AND [leftColumn] = @original_leftColumn AND [rightColumn] = @original_rightColumn AND [links] = @original_links">

 

 

As you see the field is a String: <asp:Parameter Name="original_docID" Type="String" />

asp:Parameter Name="original_docID" Type="String" />

You can't use data type TEXT (or NTEXT) in the WHERE clause.  Try casting it as a different datatype (field1 being your TEXT data and field2 being your NVARCHAR data):

.....where cast(field1 as nvarchar(4000)) = field2

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com

Thanks,

 

You would think the IDE would hook me up as I used the IDE to build the statement. But I guess thats the downside of developing with the IDE. I usually code by hand but cutting development time I am trying to rely on the IDE while I learn .NET

Depending on how you used the IDE to build it, the IDE may not know what your SQL data type is.  It assumes you know!  Go figure.  :-)

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com