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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-04-21 : 10:48:40
|
| I queue up plain text email using a stored procedure. The line separator I use is CHAR(10).For reasons I can't explain, occasionally a line separator appears as a space in the email body. Most of the time it works fine. This hurts the readability of the email.This may be an ASP / SMTP issue than SQL, I can see the linefeed in the Email queue.Has anyone else observed this and is there a fix or better solution?Sam |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-04-21 : 11:59:46
|
| CHAR(10) is a line feed. CHAR(13) is a carriage return.You may want to try CHAR(10) + CHAR(13).Jay White{0} |
 |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2003-04-21 : 12:18:24
|
by exampledeclare @msgstr varchar(800)declare @CRLF char(2)SET @CRLF = char(13) + char(10) SET @msgstr = @sono+' '+LTRIM(RTRIM(@company))+' '+LTRIM(RTRIM(@ordername))+' '+@CRLF+' '+@distno+'.'+@CRLF+@CRLF+'Purchasing Group '+@groupc+' Net change '+CAST(@netchg as varchar(24))+' '+@CRLF+@CRLF+' QUOTE ACTUAL VARIANCE'+@CRLF+'OLD '+CAST(@old_quogrouptot as varchar(24))+' '+CAST(@old_actgrouptot as varchar(24))+' '+CAST(@old_variance as varchar(24))+' '+@CRLF+'NEW '+CAST(@new_quogrouptot as varchar(24))+' '+CAST(@new_actgrouptot as varchar(24))+' '+CAST(@new_variance as varchar(24))+' ' Voted best SQL forum nickname...."Tutorial-D" |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-04-21 : 14:22:20
|
| Thank you Jay and Sitka ,I think I tried this months ago, but I don't recall why I faded back to linefeed. I'll give it a try again.Sam |
|
|
|
|
|
|
Email and linefeeds