469,643 Members | 1,514 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

Constructing Email message


I am constructing a Message (Body) for sending our Emails. It is around
3000 characters long. But for whatever reason, the last line seems to
be broken with a "!" exclamatory mark in it, which results in
displaying the constructed image path as a broken one.

How to resolve this ?. Thanks.


Jul 23 '05 #1
3 1425
No idea - what version of SQL Server, how are you building the message
body, which data type are you using for the message body, how are you
going to send the mail, what does "image path" refer to, can you post a
simplified SQL script to show the problem etc.

As a complete guess, you've declared the message body as varchar but
the path has Unicode characters in it, so you need to use nvarchar. But
without more information, that's probably wrong.


Jul 23 '05 #2
Simon, thanks for your reply.

I am using SQL Server 2000. The Message body is NTEXT datatype in the
database. And I am constructing the message body like the following:

SELECT @MessageBody = @MessageBody + '<html><head><meta
http-equiv="Content-Type" '
SELECT @MessageBody = @MessageBody + 'content="text/html;charset=' +
@CharSet + '">'
SELECT @MessageBody = @MessageBody + '<title>Title goes here:
SELECT @MessageBody = @MessageBody + '<link rel="stylesheet"
type="text/css" '

-- I have 67 lines of the @MessageBody construction and at the end of
the stored procedure I am doing a EXEC to insert this @MessageBody onto
another table and our third party vendor picks up the Emails from the
table and send them out. So I don't send out the emails manually, all I
do is insert the email contents onto a table and the rest is taken care

Please help. Thanks.


Jul 23 '05 #3
It's still a little unclear (at least to me) - @MessageBody can't be
ntext, because you can't declare an ntext variable. And you don't say
where the invalid data appears - if you SELECT @MessageBody before
INSERTing it, is the data correct? Or is it only wrong after INSERTing?
And what does "doing an EXEC" mean? Are you using dynamic SQL, or a
stored procedure to do the INSERT?

Rather than describing your problem, I suggest that you try to produce
a (simplified) script to illustrate your problem - code is always
clearer than a description, and if other people can quickly copy and
paste into Query Analyzer, you're more likely to get a useful answer.



Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Benjamin Scott | last post: by
reply views Thread by Krasimir_Slaveykov | last post: by
5 posts views Thread by grocery_stocker | last post: by
4 posts views Thread by Valerie Hough | last post: by
10 posts views Thread by Matthew | last post: by
4 posts views Thread by Narendra | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.