Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    15

    Unanswered: ASP Output not structured right

    Hi, I'm trying to get my text output thats in an access db to display properly. What I want is to preserve all the carraige returns, sentence structure. The database perserves it properly it's only when I write it out does it get squashed together.

    Ex:
    What DB shows:
    5 Pieces of equipment:
    (5)Micron Clientpro
    25468750001,
    32173220001,
    25468730001,
    25468370001,
    25467790001,

    What ASP produces:
    5 Pieces of equipment5)Micron Clientpro 25468750001, 32173220001, 25468730001,25468370001,25467790001,

    I use <%=strComments%> to display the output. I retrieve the data earlier in the code and assign it to a variable for later use. Any help would be appreciated, thanks.

    Rob

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Here's something you can do first that should help:

    ' Convert all vbCrLf to <br>.
    ' (This is the same as converting Chr(13) & Chr(10) to <br>.)
    strComments = Replace(strComments, vbCrLf, "<br>")
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Sep 2004
    Posts
    15
    Cool thanks that worked.

    Rob

  4. #4
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Rob,

    Glad to hear it and you're welcome!
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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