The code looks fine to me, have you check the data that comes back. You may
want to do a cfdump on query and look at the data. If there are characters
that XML needs escaped or put into CDATA sections.
> I keep getting this error. It's trang because I had it work a few
> days ago.
>
> Any ideas? Thanks. -D
>
> Error Occurred While Processing Request
> Illegal character or entity reference syntax.
> Illegal character or entity reference syntax.
>
> The error occurred in D:\Inetpub\wwwroot\SfConsumersdb\cds2.cfm: line
> 81
>
> 79 : </termValue>
> 80 : </subscriber>
> 81 : </remoteOrder></CFLOOP>
> 82 : <transactionCount></transactionCount>
> 83 : </transactions></CFXML>
>
>
>
>
>
> CODE
> <CFQUERY name="promomag" datasource="con_relations_magxml">
> SELECT *
> FROM tblPromotionParticipants
> </CFQUERY>
>
> <CFOUTPUT>
> <CFXML variable="gallery"><?xml version="1.0"?>
> <transactions>
> <vendor>
> <vendorId>736</vendorId>
> <vendorPassword>WBC8YjML</vendorPassword>
> </vendor><CFloop query="promomag">
> <remoteOrder>
> <magazineCode>OGD</magazineCode>
> <orderType>ORDER</orderType>
> <paymentType>7</paymentType>
> <pageId>39801</pageId>
> <responseKey></responseKey>
> <creditCard>
> <cardNumber></cardNumber>
> <expireMonth></expireMonth>
> <expireYear></expireYear>
> </creditCard>
> <subscriber>
> <address>
> <name>#trim(FirstName)# #trim(MidInit)# #trim(LastName)#</name>
> <address1>#trim(Address1)#</address1>
> <CFIF Address2 IS
""><ad> dress2></address2><cfelse><address2>#trim(Address2)#</address2></CFIF>
>
> <city>#trim(City)#</city>
> <state>#trim(StateOrProvince)#</state>
> <country>United States</country>
> <postalCode>#trim(PostalCode)#</postalCode>
> </address>
> <email>
> <emailAddress>#trim(EmailAddress)#</emailAddress>
> <emailAuthorization></emailAuthorization>
> </email>
> <termValue>
> <term>6</term>
> <value>$0.01</value>
> </termValue>
> </subscriber>
> </remoteOrder></CFLOOP>
> <transactionCount></transactionCount>
> </transactions></CFXML>
</CFOUTPUT>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294711
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
