[Last Call] Learn how to a build a cloud-first strategyRegister Now


Issue with "&" in data field defined as XHTML Text Formatting in cfreport

Posted on 2011-10-20
Medium Priority
Last Modified: 2012-06-27
I have a cfreport that is working perfectly *except* in a data field defined as XHTML Text Formatting = True, if there is an "&" in the data anywhere it will not format as XHTML it will print out as if it was text, I'm getting around that by doing a replace of all "&" with "", however that is only a short term solution so e.g.  "Spreck & Associates" in the field would cause the field to print out as if it where text showing all the <> tags, not with the correct XHTML formatting
Question by:Javier_Arroyo
  • 2
LVL 84

Accepted Solution

Dave Baldwin earned 2000 total points
ID: 37003708
I think you're supposed to use entities in XML like '&amp;' for a simple '&'.  http://stackoverflow.com/questions/1091945/where-can-i-get-a-list-of-the-xml-document-escape-characters

Author Comment

ID: 37003736
Jeezez ...that was simple ...thanks for teh answer, not sure why I didn't try that to begin with!!

LVL 84

Expert Comment

by:Dave Baldwin
ID: 37003746
You're welcome, you apparently just didn't think of it this time.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The technique is by far very Simple! How we can export the ColdFusion query results to DOC file?  Well before writing this I researched a lot in Internet but did not found a good Answer anyways!  So i thought now i should share my small snippet w…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month17 days, 17 hours left to enroll

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question