The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I'm using ASP with a access database in my site. Users can send articles by filling a form, and then i can check wich ones will go to the page. But when i get the text from the database, it comes whitout paragraphs, linebrakes etc. Here's my questions:
1- What are the advantages and disadvantages of storing articles in a database
2- Is there a way to mantain formatation of the text?
thanks!
The site is: www.digitalrice.com/netway

This thread belongs in the ASP, JSP, Perl forums - so don't be suprised if it gets moved...

Anyway, you can ensure that the formating characters are placed in the string when you are capturing the info from your html form. I presume that's what you are talking about.

<textarea name="foo" wrap="hard">

the wrap="hard" will ensure that the formating characters are placed in the string when the form is posted.

Putting the string into the database, you will also need to escape the escape character in '\n' and '\r'. I'm sure there are some regular expression functions in VBScript that are used. But I don't know VBScript or ASP so I'll shut up now.

For your own good, I suggest posting in the Server-Side Languages --> ASP forum.

Also, talk to big_al, one of our resident ASP Gurus. He recently completed a project (I think) which stored the entire Gutenburg bible in a database. He could clear up any things I misunderstood and coudl give you some more information.