Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wafi
Starting Member
12 Posts |
 Posted - 2004-03-18 : 10:35:02
|
| Hi all iam trying to but a varchar variable into a TEXT var but i get this error "The assignment operator operation cannot take a text data type as an argument"anybody know what shall i dobest regardsWafi Mohtaseb |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-18 : 10:49:10
|
| Text isn't a valid data type for variables. You cannot do this. Are you trying to write the varchar variable to a text column?Raymond |
 |
|
|
wafi
Starting Member
12 Posts |
Posted - 2004-03-18 : 10:55:34
|
| Iam trying to send an email from a stored procedure using CDO.NEWMail "its an com object"so if i bass the message body as varchar it the com object will send only 4000 chars to macke it send alll the message i must bass it as text , the message template is stored in a table as varchar that's my problem do you know how to solve it???best regardsWafi Mohtaseb |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-18 : 20:45:11
|
| Varchar can store 8,000 characters, nvarchar can only store 4,000.You should search SQL Team for "email" and read the articles you find, some of them have alternate methods for sending large message bodies. |
|
|
|
wafi
Starting Member
12 Posts |
Posted - 2004-03-29 : 03:06:04
|
| I know that, but when using CDO.NewMail Object from a stored procedure there is some restrictions , if you want to Send a Msg body that is larger than 4000 chars you must pass it as TEXT var not as VARCHAR so the problem is how to retrieve a TEXT column and but it into a TEXT var Best RegardsWafi Mohtaseb |
|
|
|
|
|
|
How to Convert VARCHAR to TEXT