Constructing Email message
This is a discussion on Constructing Email message within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, I am constructing a Message (Body) for sending our Emails. It is around 3000 characters long. But for ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:24 AM
| ||||
| ||||
 Constructing Email message Hi, 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. Regards, Karthick      |
|
02-29-2008, 07:24 AM
| |||
| |||
| Re: Constructing Email message 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. Simon |
|
02-29-2008, 07:24 AM
| |||
| |||
| Re: Constructing Email message 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 = '<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">' 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: Ticket</title>' 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 of. Please help. Thanks. Karthick |
|
02-29-2008, 07:24 AM
| ||||
| ||||
| Re: Constructing Email message 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. http://www.aspfaq.com/etiquette.asp?id=5006 Simon |
Linear Mode
