|
 |
asp_databases thread: Data Format
Message #1 by "Mark Irvine" <markpirvine@b...> on Wed, 29 Aug 2001 15:47:11 +0100
|
|
Hi,
I have encountered a small problem when reading data back from a database.
When several paragraphs of text have been entered into a memo field and read
back they are displayed as one paragraph, e.g.
Paragraph One.
Paragraph Two.
would be read back as
Paragraph One. Paragraph Two.
I have checked the data in the database and it is properly formatted. Has
anyone else encountered this before?
Mark
Message #2 by "Craig Flannigan" <ckf@k...> on Wed, 29 Aug 2001 15:53:16 +0100
|
|
Yes.
Easy to solve too.
Just use a replace command, searching for VBCRLF (Line Returns) and replace
it with "<br>"
So you'd use.....
strMemoText = Replace(objRST("memofieldname),vbcrlf,"<br>")
strMemoText then contains your formatted text with line breaks as normal.
Substitue the "<br>" for "<p>" if you want paragraph breaks.
Hope this helps,
Craig.
-----Original Message-----
From: Mark Irvine [mailto:markpirvine@b...]
Sent: Wednesday 29 August 2001 15:47
To: ASP Databases
Subject: [asp_databases] Data Format
Hi,
I have encountered a small problem when reading data back from a database.
When several paragraphs of text have been entered into a memo field and read
back they are displayed as one paragraph, e.g.
Paragraph One.
Paragraph Two.
would be read back as
Paragraph One. Paragraph Two.
I have checked the data in the database and it is properly formatted. Has
anyone else encountered this before?
Mark
Message #3 by "Tomm Matthis" <matthis@b...> on Wed, 29 Aug 2001 11:02:59 -0400
|
|
You need to replace the CRLF's and/or LF's with the html <BR> tag.
-- Tomm
> -----Original Message-----
> From: Mark Irvine [mailto:markpirvine@b...]
> Sent: Wednesday, August 29, 2001 10:47 AM
> To: ASP Databases
> Subject: [asp_databases] Data Format
>
> Hi,
>
> I have encountered a small problem when reading data back from a database.
> When several paragraphs of text have been entered into a memo field and read
> back they are displayed as one paragraph, e.g.
>
> Paragraph One.
>
> Paragraph Two.
>
> would be read back as
>
> Paragraph One. Paragraph Two.
>
> I have checked the data in the database and it is properly formatted. Has
> anyone else encountered this before?
>
> Mark
>
Message #4 by "Mark Irvine" <markpirvine@b...> on Wed, 29 Aug 2001 16:15:55 +0100
|
|
Hi,
Many thanks for everyone's help.
Mark
Mark Irvine <markpirvine@b...> wrote in message
news:97705@a..._databases...
>
> Hi,
>
> I have encountered a small problem when reading data back from a database.
> When several paragraphs of text have been entered into a memo field and
read
> back they are displayed as one paragraph, e.g.
>
> Paragraph One.
>
> Paragraph Two.
>
> would be read back as
>
> Paragraph One. Paragraph Two.
>
> I have checked the data in the database and it is properly formatted. Has
> anyone else encountered this before?
>
> Mark
>
>
>
>
|
|
|
View Cart
