|
 |
asp_databases thread: Paragraphs retrieval from Access
Message #1 by "Jophus" <yfridmn@n...> on Thu, 26 Oct 2000 21:03:57 +0100
|
|
Well, I finally have my first ASP/Database site on-line thanks to Wrox
(Beginning ASP 3.0 and Beginning ASP Databases). Everything works fine
except...
The site includes a large amount of client text submissions which are
inserted into Access 20000 memo fields. Most are fairly lengthy and
divided into paragraphs. The problem is that when I retrieve the
information (Response.write objRS("memofield")) the paragraphs' hard
returns disappear and I'm left with one long hard-to-read pargraph.
Can anyone help?
Thanks in advance.
Message #2 by =?iso-8859-1?Q?H=E5kan_Frennesson?= <hakan@c...> on Fri, 27 Oct 2000 14:16:26 +0200
|
|
Hi!
Try this:
strNewLargeText = replace (strLargeText,chr(13),"<br>")
where strLargeText is your memo field
Hope this helps!
Hakan Frennesson
-----Original Message-----
From: Jophus [mailto:yfridmn@n...]
Sent: den 26 oktober 2000 22:04
To: ASP Databases
Subject: [asp_databases] Paragraphs retrieval from Access
Well, I finally have my first ASP/Database site on-line thanks to Wrox
(Beginning ASP 3.0 and Beginning ASP Databases). Everything works fine
except...
The site includes a large amount of client text submissions which are
inserted into Access 20000 memo fields. Most are fairly lengthy and
divided into paragraphs. The problem is that when I retrieve the
information (Response.write objRS("memofield")) the paragraphs' hard
returns disappear and I'm left with one long hard-to-read pargraph.
Can anyone help?
Thanks in advance.
Message #3 by Ludwig Brandon-FBL017C <Brandon.Ludwig@m...> on Fri, 27 Oct 2000 08:13:22 -0400
|
|
Try parsing out the VBCRLF's using a statement like the following:
paragraph = Replace(Replace(Replace(Data, vbLF,"<BR>"), vbCR,"<BR>"), vbCRLF,"<BR>")
Brandon Ludwig
Brandon.Ludwig@M...
-----Original Message-----
From: Jophus [mailto:yfridmn@n...]
Sent: Thursday, October 26, 2000 4:04 PM
To: ASP Databases
Subject: [asp_databases] Paragraphs retrieval from Access
Well, I finally have my first ASP/Database site on-line thanks to Wrox
(Beginning ASP 3.0 and Beginning ASP Databases). Everything works fine
except...
The site includesa large amount of client text submissions which are
inserted into Access 20000 memo fields. Most are fairly lengthy and
divided into paragraphs. The problem is that when I retrieve the
information (Response.write objRS("memofield")) the paragraphs' hard
returns disappear and I'm left with one long hard-to-read pargraph.
Can anyone help?
Thanks in advance.
Message #4 by Kat Howlett <kat.howlett@c...> on Mon, 30 Oct 2000 17:10:33 +1100
|
|
Hi
I have been having the same problem with the removal of hard returns,
except
I am using a text file to store my formatted data. Should this same fix
work
for me too, or do I have to do something else?
Thanks
Kat
-----Original Message-----
From: H=E5kan Frennesson [mailto:hakan@c...]
Sent: Friday, 27 October 2000 10:16 PM
To: ASP Databases
Subject: [asp_databases] RE: Paragraphs retrieval from Access
Hi!
Try this:
strNewLargeText =3D replace (strLargeText,chr(13),"<br>")
where strLargeText is your memo field
Hope this helps!
Hakan Frennesson
-----Original Message-----
From: Jophus [mailto:yfridmn@n...]
Sent: den 26 oktober 2000 22:04
To: ASP Databases
Subject: [asp_databases] Paragraphs retrieval from Access
Well, I finally have my first ASP/Database site on-line thanks to Wrox
(Beginning ASP 3.0 and Beginning ASP Databases). Everything works fine
except...
The site includes a large amount of client text submissions which are
inserted into Access 20000 memo fields. Most are fairly lengthy and
divided into paragraphs. The problem is that when I retrieve the
information (Response.write objRS("memofield")) the paragraphs' hard
returns disappear and I'm left with one long hard-to-read pargraph.
Can anyone help?
Thanks in advance.
|
|
|
View Cart
