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

Posted on 2011-10-20
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
    LVL 82

    Accepted Solution

    I think you're supposed to use entities in XML like '&amp;' for a simple '&'.

    Author Comment

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

    LVL 82

    Expert Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
    CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
    This video discusses moving either the default database or any database to a new volume.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now