Untitled

Operand type clash: ntext is incompatible with int - classic asp and sql server 2005
sub sp_assUpdate(entryId)
' Create ADO command

Set cmd = Server.CreateObject("ADODB.Command")
With cmd


' Set up DB connection to use, set the type of SQL command
.ActiveConnection = cnn
.CommandType = adCmdStoredProc
.CommandText = "sp_assUpdate" ' Set the name of the Stored Procedure to use

' Add parameter, then pass the value of the variable
.Parameters.Append .CreateParameter("@entryId",adInteger, adParamInput)
.Parameters("@entryId") = entryId
.Parameters.Append .CreateParameter("@title", adVarWChar, adParamInput, 50)
.Parameters("@title") = title
.Parameters.Append .CreateParameter("@smsText", adVarWChar, adParamInput, 150)
.Parameters("@smsText") = smsText
.Parameters.Append .CreateParameter("@shortDes", adVarWChar, adParamInput, 255)
.Parameters("@shortDes") = shortDes
.Parameters.Append .CreateParameter("@video", adVarWChar, adParamInput, 255)
.Parameters("@video") = video
.Parameters.Append .CreateParameter("@date1", adDate, adParamInput)
.Parameters("@date1") = date1
.Parameters.Append .CreateParameter("@date2", adDate, adParamInput)
.Parameters("@date2") = date2
.Parameters.Append .CreateParameter("@files", adVarChar, adParamInput, 4000)
.Parameters("@files") = files
.Parameters.Append .CreateParameter("@fileNames", adVarChar, adParamInput, 4000)
.Parameters("@fileNames") = fileNames
.Parameters.Append .CreateParameter("@links", adVarChar, adParamInput, 4000)
.Parameters("@links") = links
.Parameters.Append .CreateParameter("@linkNames", adVarChar, adParamInput, 4000)
.Parameters("@linkNames") = linkNames
.Parameters.Append .CreateParameter("@assigned", adVarWChar, adParamInput, 4000)
.Parameters("@assigned") = assigned
.Parameters.Append .CreateParameter("@teacherId", adInteger, adParamInput)
.Parameters("@teacherId") = teacherId
.Parameters.Append .CreateParameter("@longDes", adLongVarWChar, adParamInput, len(longDes) + 1)
.Parameters("@longDes") = ""
' Execute
set sp_rs = .Execute
End With

call cleanUp()

end sub

ALTER PROCEDURE [dbo].[sp_assUpdate]

-- Parameters
@entryId int output,
@title varchar(50),
@smsText varchar(150),
@shortDes varchar(255),
@longDes varchar(max),
@date1 datetime,
@date2 datetime,
@files varchar(4000),
@fileNames varchar(4000),
@links varchar(4000),
@linkNames varchar(4000),
@video varchar(300),
@assigned varchar(4000),
@teacherId int output
AS
BEGIN
-- SET NOCOUNT ON

SET NOCOUNT ON;

-- Update Assignments with new values.
UPDATE assignments
SET
title = @title, smsText = @smsText, shortDes = @shortDes, longDes = @longDes, date1 = @date1,
date2 = @date2, files = @files, fileNames = @fileNames, links = @links, linkNames = @linkNames,
video = @video, teacherId = @teacherId
WHERE id = @entryId
END

Microsoft OLE DB Provider for SQL Server error '80040e07'

Operand type clash: ntext is incompatible with int

D:STABLEPROCESS../scripts/sp/assignments.html, line 279

CREATE TABLE [dbo].[assignments](
    [id] [bigint] IDENTITY(1,1) NOT NULL,
    [title] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [smsText] [nvarchar](160) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [shortDes] [nvarchar](300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [longDes] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [dateType] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [date1] [datetime] NULL,
    [date2] [datetime] NULL,
    [date3] [datetime] NULL,
    [files] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [fileNames] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [links] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [linkNames] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [assignmentType] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [teacherId] [bigint] NOT NULL,
    [video] [nvarchar](400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_assignments] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]