I am developing an ASP application with a SQL2000 database.  Users enter 

data on a form and a stored procedure executes on submit to update the 

users record.  The sotred procedure uses parameters to supply the values 

for the text boxes on the form.  One field has a varchar data type and I 

receive the following error message: 'Application uses a value of the 

wrong type for the current operation'.  The parameter in the stored 

procedure is defined a varchar and the data type is varchar for this field 

in the table as well.  If I change the data type to 'text' in both the 

table and the stored procedure, the update query executes with no errors.  

I don't want to use a text data type for this field.  Why do I get this 

error?

Can you please provide some code?



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: From: "Bruce Haan" <bpa.haan@s...>

: Subject: [asp_databases] Application uses a value of the

: wrong type for the current operation

:



: I am developing an ASP application with a SQL2000 database.

: Users enter data on a form and a stored procedure executes on

: submit to update the users record.  The sotred procedure uses

: parameters to supply the values for the text boxes on the form.

: One field has a varchar data type and I receive the following

: error message: 'Application uses a value of the

: wrong type for the current operation'.  The parameter in the stored

: procedure is defined a varchar and the data type is varchar for this field

: in the table as well.  If I change the data type to 'text' in both the

: table and the stored procedure, the update query executes with no errors.

: I don't want to use a text data type for this field.  Why do I get this

: error?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~