Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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




  Return to Index