creating xml from database

Question

I am creating an xml from salesforce database, Everything works fine except when there is a & in the data which is been fetched.

<apex:page contenttype="text/xml" 
> controller="Test2ab" >  <data
> wiki-section="Timeline"> <apex:repeat
> value="{!lsttask}" var="e" > <event
> start="{!e.ActivityDate}" title=
> "{!e.Subject}"> <apex:outputText
> value="{!e.Subject}" /> </event>
> </apex:repeat> </data></apex:page>

and in the controller i am just querying

>  lsttask   =[Select OwnerId,WhoId,Status,Subject,ActivityDate from Task where Status = 'Completed' Order By ActivityDate Desc];

How can i use an escape for the value retrieved from the database
Thanks Prady

James Walford · Accepted Answer · 2011-01-14 09:31:25Z

1

I know very little about APEX/Salesforce but as you're building an XML from strings fetched from the database you probably need to call the replace method of the string:

string.replace("&","&amp;")

http://www.salesforce.com/us/developer/docs/apexcode/salesforce_apex_language_reference.pdf

you might also want top look at replacing < with <, > with >,' with ' and " with "

edited Jan 14, 2011 at 9:31

answered Jan 4, 2011 at 17:52

James Walford

2,9531 gold badge26 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

twamley · Accepted Answer · 2011-10-14 17:25:53Z

0

In your example, this works well:

<apex:outputText value="{!HTMLENCODE(e.Subject)}" escape="false" />

In simpler cases you can also use:

{!HTMLENCODE(e.Subject)}

Here is a summary of HTMLENCODE and other Salesforce functions An example of pairing apex:outputText with HTMLENCODE and escape=false is in the Apex Dev Guide

answered Oct 14, 2011 at 17:25

twamley

8012 gold badges14 silver badges24 bronze badges

Comments

tggagne · Accepted Answer · 2013-03-22 12:37:38Z

0

This might help as well. I realize it's late to the game, but it may help others that visit this topic.

http://it.toolbox.com/blogs/anything-worth-doing/a-better-way-to-generate-xml-on-salesforce-using-visualforce-55433

answered Mar 22, 2013 at 12:37

tggagne

2,8841 gold badge22 silver badges15 bronze badges

Collectives™ on Stack Overflow

creating xml from database

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related