|
 |
access_asp thread: need to add carriage returns to memo field data
Message #1 by "Tom Devins" <tdev01@y...> on Thu, 11 Apr 2002 22:11:37
|
|
Hi,
I have a field in a database where someone can post a simple text resume.
It is stored in a memo field in the database.
When I bring the data out for display on an ASP page I want the data to
reflect the carriage returns similar to PHP nl2br function.
Is there anything simple like this I can do?
Thanks.
Message #2 by "Tom Devins" <tdev01@y...> on Thu, 11 Apr 2002 23:25:02
|
|
Nevermind ... I figured it out.
Message #3 by "Ken Schaefer" <ken@a...> on Fri, 12 Apr 2002 15:36:24 +1000
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tom Devins" <tdev01@y...>
Subject: [access_asp] need to add carriage returns to memo field data
: I have a field in a database where someone can post a simple text resume.
: It is stored in a memo field in the database.
:
: When I bring the data out for display on an ASP page I want the data to
: reflect the carriage returns similar to PHP nl2br function.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Replace(strToOutput, vbCrLf, "<br>" & vbCrLf)
Replaces the vbCrLf (ASCII Chr(13) & Chr(10)) with a HTML <br>, then appends
a vbCrLf into the source of the HTML so that your HTML doesn't all end up on
a single line.
Cheers
Ken
|
|
 |