PDA

Click to See Complete Forum and Search --> : Break Point in ASP and SQL

ffirozan
02-09-2009, 02:39 PM
Hi,

I am inserting a text in database

INSERT INTO tblTemplateEmail (EmailID, EmailBody)
Values( 63,'Dear Manager First Name, Welcome to ICon! I have been contacted')


and when I want to retriev it I use the following line to break lines but it doesn't work!!!

strEmailBody = Replace(rsUser5("EmailTextBody"),vbCrLf,"<br>")


any Suggestion????
downtime
02-09-2009, 06:42 PM
Hi,

I am inserting a text in database
INSERT INTO tblTemplateEmail (EmailID, EmailBody)
Values( 63,'Dear Manager First Name, Welcome to ICon! I have been contacted')

and when I want to retriev it I use the following line to break lines but it doesn't work!!!
strEmailBody = Replace(rsUser5("EmailTextBody"),vbCrLf,"<br>")
any Suggestion????

"EmailTextBody" or "EmailBody"? You reference both in your code example. Also, are you sure your line separater is vbCrLf? Are you using a memo field to collect the value?