Skip to main content
Participant
November 29, 2006
Question

Lost white spaces when querying Access Database

  • November 29, 2006
  • 1 reply
  • 275 views
Hi all, bit of a problem here. I've got a series of blogs that I need to display using the cfoutput tag. Each blog is saved in a field in an Access database. When I use cfoutput all the paragraph formatting is lost and it is just displayed as one paragraph. Eg:

"this is a paragraph.

This is also a paragraph"

..is displayed like this:

"this is a paragraph. This is also a paragraph"

Can anyone tell me what I'm doing wrong?

Thanks
Andy
    This topic has been closed for replies.

    1 reply

    Inspiring
    November 29, 2006
    you can either use the paragraphformat function or change all your chr(10)'s to <br />s
    November 29, 2006
    Or just wrap the entries in <pre> tags.

    Like:

    <cfoutput><pre>#BlogEntryString#</pre></cfoutput>

    All three approaches are appropriate depending on the situation.