Formatting Submitted Text HELP PLEASE URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 
Author Message
 Formatting Submitted Text HELP PLEASE URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I am getting user text  from a form which contains a  textarea control which
is then posted to an ASP page which inserts that text to a SQL server
Database.

When I go to get the data out of the database I loose all the formatting
done in the original textarea.

for example:
This is a formatting test.
   1. test one
   2. test two

This would be retrieved like this:

 This is a formatting test.1. test one2. test two

From a------  Response.Write "<td ><%=RS.Fields('Message').Value%></td>"

How do I retain the original format of the submitted text?

Thanks in Advance!

Chris



Sun, 12 Sep 2004 20:43:54 GMT  
 Formatting Submitted Text HELP PLEASE URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
1) on the form where the text is input
 <textarea name='notes' cols=50 rows=6 wrap='virtual'></textarea>

2) when you put it in the database
recordSet("notes") = Trim(request.form("notes"))

3) When you display it on a web page you need to convert all <CR><LF>
characters to HTML <br> tags for it to display as entered in the
<Textarea>  Use this:

response.write Replace(  recordSet("notes"), VbCrLf, "<br>")

Hope this helps!

On Wed, 27 Mar 2002 07:43:54 -0500, "Christopher J. Calhoun"

Quote:

>I am getting user text  from a form which contains a  textarea control which
>is then posted to an ASP page which inserts that text to a SQL server
>Database.

>When I go to get the data out of the database I loose all the formatting
>done in the original textarea.

>for example:
>This is a formatting test.
>   1. test one
>   2. test two

>This would be retrieved like this:

> This is a formatting test.1. test one2. test two

>From a------  Response.Write "<td ><%=RS.Fields('Message').Value%></td>"

>How do I retain the original format of the submitted text?

>Thanks in Advance!

>Chris



Sun, 19 Sep 2004 02:50:14 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Duplicate Error on insert record

2. help,help,help,help,help,help,help,help,help,help,help,help,help,

3. PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP,

4. DIRE NEED OF HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

5. (urgent - please help) reading and writing in a text file using VB

6. (urgent - please help) reading and writing in a text file using VB

7. URGENT HELP PLEASE PLEASE PLEASE???

8. HELP!!!!!!!!!!!!!!!HELP!!!!!!!!!!!!!!!!!!HELP!!!!!!!!!!!!!!!!!!!!HELP!!!!!!!!!!!!!!!!!!!!

9. Formatting a text box for printing(please help!!!)

10. Please help: Formatting text box

11. to print in Pascal

12. LOOKING FOR DELPHI CODER $$$

 

 
Powered by phpBB® Forum Software