p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

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

> 


  Return to Index