|
 |
asp_database_setup thread: how to have line brakes from daterbases
Message #1 by "Michael Griffiths" <mg@g...> on Tue, 6 Feb 2001 11:04:00 -0000
|
|
How to have line brakes from databases
Using access and ultradev.
How can one get the line brakes and line spacing from database to show in
asp pages.
i.e.
********
line1.
line2.
line4(line space above).
*******
at present all extra spaces and line brakes are removed.
i.e.
*******
line1. line2. line4(line space above).
*******
Any advice welcome
yours Michael
Message #2 by Imar Spaanjaars <Imar@S...> on Tue, 06 Feb 2001 12:55:32 +0100
|
|
If the text contains linebreaks, simply replace them with the HTML <BR> tag.
Try this:
sMyText = Replace(sMyText, vbCRLF, "<BR>")
This replaces all normal linebreaks with the <BR> tag.
HtH
Imar
At 11:04 AM 2/6/2001 +0000, you wrote:
>How to have line brakes from databases
>Using access and ultradev.
>How can one get the line brakes and line spacing from database to show in
>asp pages.
>i.e.
>********
>line1.
>line2.
>
>line4(line space above).
>*******
>at present all extra spaces and line brakes are removed.
>i.e.
>*******
>line1. line2. line4(line space above).
>*******
>
>Any advice welcome
>yours Michael
>
>
>
>---
>http://www.asptoday.com - the leading site for timely,
>in-depth information for ASP developers everywhere.
>$subst('Email.Unsub')
Message #3 by "Michael Griffiths" <mg@g...> on Tue, 6 Feb 2001 21:13:01 -0000
|
|
Thanks Imar
<%=Replace((Recordset1.Fields.Item("Notes").Value), vbCRLF, "<BR>")%>
the code works well.
----- Original Message -----
From: "Imar Spaanjaars" <Imar@S...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Tuesday, February 06, 2001 11:55 AM
Subject: [asp_database_setup] Re: how to have line brakes from daterbases
> If the text contains linebreaks, simply replace them with the HTML <BR>
tag.
>
> Try this:
>
> sMyText = Replace(sMyText, vbCRLF, "<BR>")
>
> This replaces all normal linebreaks with the <BR> tag.
>
> HtH
>
> Imar
>
>
>
> At 11:04 AM 2/6/2001 +0000, you wrote:
> >How to have line brakes from databases
> >Using access and ultradev.
> >How can one get the line brakes and line spacing from database to show in
> >asp pages.
> >i.e.
> >********
> >line1.
> >line2.
> >
> >line4(line space above).
> >*******
> >at present all extra spaces and line brakes are removed.
> >i.e.
> >*******
> >line1. line2. line4(line space above).
> >*******
> >
> >Any advice welcome
> >yours Michael
> >
>
|
|
|
View Cart
