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?
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.
Hope this helps. :D
This thread should be locked. It has now been posted to the ASP forum :)
Thank you kindly gentlemen ;)
Please direct your responses to http://www.sitepointforums.com/showt...threadid=20426