SitePoint Sponsor

User Tag List

Results 1 to 6 of 6

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2001
    Location
    Belo Horizonte, Brasil
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    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

  2. #2
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  3. #3
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  4. #4
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This thread should be locked. It has now been posted to the ASP forum

  5. #5
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry, sid.
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  6. #6
    Irritability Defined
    Join Date
    Jul 2000
    Location
    80,000 feet below the surface
    Posts
    1,442
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you kindly gentlemen

    Please direct your responses to http://www.sitepointforums.com/showt...threadid=20426
    My 2 Cents (or is that 2.2 Cents including GST?)


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •