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 |
|
iminore
Posting Yak Master
141 Posts |
 Posted - 2005-07-08 : 06:27:11
|
| I've been here before, but never found an answer.How can I pass a text variable to a procedure?exec SP @var = @var1 + @var2 is not allowed.I want to generate emails with more than 8000 characters. I've searched, prodded, probed but still no way. I'm using CDO via SP_OA extended SPs but the problem is generic - how to pass text. |
|
|
Stellarion
Starting Member
5 Posts |
Posted - 2005-07-08 : 08:10:15
|
Have you tried passing them over as two seperate variables and concatenating them within the procedure?quote:
Originally posted by iminore
I've been here before, but never found an answer.How can I pass a text variable to a procedure?exec SP @var = @var1 + @var2 is not allowed.I want to generate emails with more than 8000 characters. I've searched, prodded, probed but still no way. I'm using CDO via SP_OA extended SPs but the problem is generic - how to pass text.
The Future is fixed...The Past always changing. |
 |
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2005-07-08 : 08:21:21
|
| so how would you concatenate two varchar(8000) variables? |
|
|
|
Stellarion
Starting Member
5 Posts |
Posted - 2005-07-08 : 08:58:11
|
Try this article:[url]http://www.sqlteam.com/item.asp?ItemID=5908[/url]quote:
Originally posted by iminore
so how would you concatenate two varchar(8000) variables?
The Future is fixed...The Past always changing. |
|
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2005-07-08 : 09:00:29
|
| read it - it uses a body of varchar(6000) |
|
|
|
Stellarion
Starting Member
5 Posts |
Posted - 2005-07-08 : 09:08:40
|
How long is the actual information you want to use for the body? And have you thought of sending most of that as an attachment.It does appear that the extended SP has a limit of 8000quote:
Originally posted by iminore
read it - it uses a body of varchar(6000)
The Future is fixed...The Past always changing. |
|
|
|
iminore
Posting Yak Master
141 Posts |
Posted - 2005-07-08 : 09:29:52
|
| I don't think there's a limit in the extended SP. If I could pass my proc a text value it would work - I've tried it in QA. |
|
|
|
|
|
|
text parameters