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.createob ject ("ADODB.connect ion")
set objrec = server.createob ject ("ADODB.records et")
objconn.open "DSN=daters "
strsql = "SELECT messages.text FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardon ly, adlockoptimisti c,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**********@b tinternet.com> wrote in message
news:#Y******** ******@TK2MSFTN GP10.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.createob ject ("ADODB.connect ion")
set objrec = server.createob ject ("ADODB.records et")
objconn.open "DSN=daters "
strsql = "SELECT messages.text FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardon ly, adlockoptimisti c,adcmdtext
%>

<%=objrec("text ")%>

Thanks in advance Hugh

[Steven Burn]

I just use something along the lines of;

Replace(rst("Th eText"), vbCrlf, "<br>")

Which suffices......

--

Regards

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

Keeping it FREE!
"Hugh Welford" <hu**********@b tinternet.com> wrote in message
news:#Y******** ******@TK2MSFTN GP10.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.createob ject ("ADODB.connect ion")
set objrec = server.createob ject ("ADODB.records et")
objconn.open "DSN=daters "
strsql = "SELECT messages.text FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardon ly, adlockoptimisti c,adcmdtext
%>

<%=objrec("text ")%>

Thanks in advance Hugh

[Hugh Welford]

Thanks very much guys

Hugh
"Hugh Welford" <hu**********@b tinternet.com> wrote in message
news:%2******** ********@TK2MSF TNGP10.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.createob ject ("ADODB.connect ion")
set objrec = server.createob ject ("ADODB.records et")
objconn.open "DSN=daters "
strsql = "SELECT messages.text FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardon ly, adlockoptimisti c,adcmdtext
%>

<%=objrec("text ")%>

Thanks in advance Hugh