I have the following bit in a stored proc:

SELECT   @requestDate = requestDate
	,@requestor = requestor
	,@requestorEmail = requestorEmail
	,@dueDate = dueDate
	,@partDesc = partDesc
..

Problem is, the last field ("partDesc") is a text type, and whenever I try
to save the stored proc, it errors out and says that the assignment operator
cannot take a text data type as an argument.

Any ideas here? Thanks.

Wells Oliver
Web Application Programmer
Leviton Voice & Data
xxx-xxx-xxxx
http://www.levitonvoicedata.com

How about CASTing, ...

SELECT @strDescr = CAST(Descr AS VARCHAR(8000))

HTH.

Harish.

-----Original Message-----
From: Oliver, Wells [mailto:WOliver@l...]
Sent: Thursday, August 15, 2002 3:58 PM
To: ASP+
Subject: [aspx] Problems with TEXT data types in SQL Server stored
procs.


I have the following bit in a stored proc:

SELECT   @requestDate = requestDate
	,@requestor = requestor
	,@requestorEmail = requestorEmail
	,@dueDate = dueDate
	,@partDesc = partDesc
..

Problem is, the last field ("partDesc") is a text type, and whenever I try
to save the stored proc, it errors out and says that the assignment operator
cannot take a text data type as an argument.

Any ideas here? Thanks.

Wells Oliver
Web Application Programmer
Leviton Voice & Data
xxx-xxx-xxxx
http://www.levitonvoicedata.com


---

ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442

ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450

These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.

---