Hi all,

I have this pain in the rear issue with cf generated xml.  I have a  
flex app that is sending inputted text to cf, this is then sent to a  
database and then runs a query to generate xml from the data in the  
database.

<cffunction name="updateXMLStream" access="remote">
                
                <cfset var stream = '' >
                <cfset var qTemplate = '' >

                        <cfquery name="qTemplate" 
datasource="#application.dsn#">
                                ... query stuff ...
                        </cfquery>

                        <cfsavecontent variable="stream"><?xml version="1.0"  
encoding="utf-8"?>
                                <documents>
                                        <cfoutput query="qTemplate" 
group="test">
                                                <test name="#qTemplate.test#" >
                                                        <cfoutput>
                                                                <example>
                                                                        
<body_text><![CDATA[#qTemplate.txt_body#]]></body_text>
                                                                </example>
                                                        </cfoutput>
                                                </test>
                                        </cfoutput>
                                </documents>
                        </cfsavecontent>

             <cfif FileExists(ExpandPath('../xml/myXML.xml'))>
                <cffile action="delete" file="#ExpandPath('../xml/ 
myXML.xml')#">
             </cfif>
                        <cffile action="write" 
file="#ExpandPath('../xml/')#myXML.xml"  
output="#stream#">
</cffunction>

This still generates problems with certain characters such as & " '  
and I was wondering if people had any tips or advise on this at all?

Any help would be greatly appreciated,

Simon

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311581
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to