I am trying to create XMl from a cfquery, but I get this error I don't
understand while working with the links. If I use the first few entries(before
the links) I am fine, but when I try to add the links I get this error:
The entity name must immediately follow the '&' in the entity reference.
can somebody please help me figure out what is wrong.
thanks so much
below is the code
<!--- Query the database and get the names in the dailyTips table --->
<cfquery name="qTips" datasource="myDSN">
SELECT *
FROM dailytips
</cfquery>
<!--- Create an XML document object containing the data --->
<cfxml variable="tipOutput">
<getTips>
<cfoutput query="qTips">
<tips>
<topic>#tiptopic#</topic>
<dtip>#dailytip#</dtip>
<tipdate>#tipdate#</tipdate>
<consumer><a href="#consumer_link#">#consumer_text#</a></consumer>
<research><a href="#research_link#">#research_text#</a></research>
</tips>
</cfoutput>
</getTips>
</cfxml>
<!--- dump the resulting XML document object --->
<cfdump var=#tipOutput#>
<!--- Write the XML to a file --->
<cffile action="write" file="/myFolder/myData.xml"
output=#toString(tipOutput)#>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4997
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
