retrieving formatted messages from an ACCESS memo field.

[Hugh Welford]

Hi ... My application saves variable length user-generated messages in an
ACCESS memo field. ASP writes these messages correctly retaining CR LF to
generate new paragraphs. (have checked this in the actual data base).

However , when I retrieve a message into another web page, the CR LF
characters are lost, and the message displays as one long sequence of
unformatted text. Anyone any idea how I can overcome this?

Using WIN XP/FP2000/IIS and the following code:-

<%
set objconn = server.createobject ("ADODB.connection")
set objrec = server.createobject ("ADODB.recordset")
objconn.open "DSN=daters"
strsql = "SELECT messages.text FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,adcmdtext
%>

<%=objrec("text")%>

Thanks in advance Hugh

[Aaron Bertrand - MVP]

http://www.aspfaq.com/2188

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Hugh Welford" <hu**********@btinternet.com> wrote in message
news:#Y**************@TK2MSFTNGP10.phx.gbl...

Hi ... My application saves variable length user-generated messages in an
ACCESS memo field. ASP writes these messages correctly retaining CR LF to
generate new paragraphs. (have checked this in the actual data base).

However , when I retrieve a message into another web page, the CR LF
characters are lost, and the message displays as one long sequence of
unformatted text. Anyone any idea how I can overcome this?

Using WIN XP/FP2000/IIS and the following code:-

<%
set objconn = server.createobject ("ADODB.connection")
set objrec = server.createobject ("ADODB.recordset")
objconn.open "DSN=daters"
strsql = "SELECT messages.text FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,adcmdtext
%>

<%=objrec("text")%>

Thanks in advance Hugh

[Steven Burn]

I just use something along the lines of;

Replace(rst("TheText"), vbCrlf, "<br>")

Which suffices......

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
"Hugh Welford" <hu**********@btinternet.com> wrote in message
news:#Y**************@TK2MSFTNGP10.phx.gbl...

Hi ... My application saves variable length user-generated messages in an
ACCESS memo field. ASP writes these messages correctly retaining CR LF to
generate new paragraphs. (have checked this in the actual data base).

However , when I retrieve a message into another web page, the CR LF
characters are lost, and the message displays as one long sequence of
unformatted text. Anyone any idea how I can overcome this?

Using WIN XP/FP2000/IIS and the following code:-

<%
set objconn = server.createobject ("ADODB.connection")
set objrec = server.createobject ("ADODB.recordset")
objconn.open "DSN=daters"
strsql = "SELECT messages.text FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,adcmdtext
%>

<%=objrec("text")%>

Thanks in advance Hugh

[Hugh Welford]

Thanks very much guys

Hugh
"Hugh Welford" <hu**********@btinternet.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi ... My application saves variable length user-generated messages in an
ACCESS memo field. ASP writes these messages correctly retaining CR LF to
generate new paragraphs. (have checked this in the actual data base).

However , when I retrieve a message into another web page, the CR LF
characters are lost, and the message displays as one long sequence of
unformatted text. Anyone any idea how I can overcome this?

Using WIN XP/FP2000/IIS and the following code:-

<%
set objconn = server.createobject ("ADODB.connection")
set objrec = server.createobject ("ADODB.recordset")
objconn.open "DSN=daters"
strsql = "SELECT messages.text FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,adcmdtext
%>

<%=objrec("text")%>

Thanks in advance Hugh