|
 |
asp_databases thread: Formatting text from SQL to an HTML table.
Message #1 by charles.nadeau@d... on Wed, 5 Jul 2000 23:12:39 -0400
|
|
Hi,
I stored in a SQL Server 6.5SP2 table the body of e-mail messages taken
from
Outlook and text entered by users through a form.
When I display this information in a table on a web page (using ASP +
HTML),
all the carriage return/line feed are stripped and the text look like a
very
long line of text that doesn't wrap-up elegantly (also all the blank
line
inserted to separate the paragraph do not show up). Is there a way to
force
the HTML table to take into account the carriage return/line feed
information already present in the fields in the database?
Thanks for your help!
Charles
> =AB If we could travel in time, then history would become an
> experimental science.=BB, Carl Sagan
>
> Charles-E. Nadeau Ph.D. charlesnadeau@h...
> World Information Network (WIN)
> Charles.NADEAU@d...
> Regional System Manager
> http://intranet.lbp/tools-outils/
> Asia pacific
> Consulate general of Canada Phones:
> 13th Floor Tower 1 MITNET: 343-3481
> Exchange Square MITNET Fax: 343-3441
> 8 Connaught Place Office: +xxx xxxx-xxxx
> Hong Kong Fax: +852
> 2847-7441
>
>
Message #2 by Tomm Matthis <matthis@b...> on Thu, 06 Jul 2000 09:36:15 -0400
|
|
Do a replace on the string (that is replacing the CRFL with the html <BR> tag).
Then response.write it.
Tomm
charles.nadeau@d... wrote:
>
> Hi,
>
> I stored in a SQL Server 6.5SP2 table the body of e-mail messages taken from
> Outlook and text entered by users through a form.
> When I display this information in a table on a web page (using ASP + HTML),
> all the carriage return/line feed are stripped and the text look like a very
> long line of text that doesn't wrap-up elegantly (also all the blank line
> inserted to separate the paragraph do not show up). Is there a way to force
> the HTML table to take into account the carriage return/line feed
> information already present in the fields in the database?
>
> Thanks for your help!
>
Message #3 by charles.nadeau@d... on Thu, 6 Jul 2000 23:43:21 -0400
|
|
Tomm,
I tried it and it works. Thanks!
Charles
> =AB If we could travel in time, then history would become an
> experimental science.=BB, Carl Sagan
>
> Charles-E. Nadeau Ph.D.
> World Information Network (WIN)
> Regional System Manager
> Asia pacific
> Consulate general of Canada Phones:
> 13th Floor Tower 1 MITNET: 343-3481
> Exchange Square MITNET Fax: 343-3441
> 8 Connaught Place Office: +852
> 2847-7481
> Hong Kong Fax: +852
> 2847-7441
>
-----Original Message-----
From: Tomm Matthis
Sent: 6 juillet, 2000 21:36
To: ASP Databases
Subject: [asp_databases] Re: Formatting text from SQL to an HTML table.
Do a replace on the string (that is replacing the CRFL with the html
<BR>
tag).
Then response.write it.
Tomm
charles nadeau wrote:
>
> Hi,
>
> I stored in a SQL Server 6.5SP2 table the body of e-mail messages
taken
from
> Outlook and text entered by users through a form.
> When I display this information in a table on a web page (using ASP +
HTML),
> all the carriage return/line feed are stripped and the text look like
a
very
> long line of text that doesn't wrap-up elegantly (also all the blank
line
> inserted to separate the paragraph do not show up). Is there a way to
force
> the HTML table to take into account the carriage return/line feed
> information already present in the fields in the database?
>
> Thanks for your help!
>
Message #4 by Santosh Singh <singh_santosh_care@y...> on Thu, 6 Jul 2000 21:17:32 -0700 (PDT)
|
|
Hi,
All you need to do is simply insert <br> at all the
appropriate positions in your text probably word count
would help you more to automatically insert <br> after
a certain word count. Then display the entire string
using Response.Write
Best of luck
------Sunny
--- charles.nadeau wrote:
> Hi,
>
> I stored in a SQL Server 6.5SP2 table the body of
> e-mail messages taken from
> Outlook and text entered by users through a form.
> When I display this information in a table on a web
> page (using ASP + HTML),
> all the carriage return/line feed are stripped and
> the text look like a very
> long line of text that doesn't wrap-up elegantly
> (also all the blank line
> inserted to separate the paragraph do not show up).
> Is there a way to force
> the HTML table to take into account the carriage
> return/line feed
> information already present in the fields in the
> database?
>
> Thanks for your help!
>
> Charles
>
|
|
|
View Cart
