<cfquery name="getDealers" datasource="#DSN#">
select id, name from dealers
where id = '#form.DealerName#'
order by name
</cfquery>
<cfxml variable="myxml">
<graph caption='Sample Chart' subCaption='(in Percentage %)' yaxisname='# of
Ads' xaxisname='Dealers' numdivlines='3' zeroPlaneColor="333333" zeroPlaneAlpha='40'
numberSuffix='%'>
<cfoutput query="getDealers">
<cfquery name="dealerAdsCount" datasource="#DSN#">
select count(*) as totalAdsCreated from DealerAds where dealer =
'#getDealers.id#'
<cfif IsDefined('form.month1') AND #form.month1# NEQ
"A">
AND created BETWEEN #startdate# AND #enddate#
</cfif>
</cfquery>
<set name='#getDealers.name#'
value='#dealerAdsCount.totalAdsCreated#' />
</cfoutput>
</graph>
</cfxml>
<!--- dump the resulting XML document object --->
<cfdump var="#myxml#">
The above code somehow giving me the following error at the line where I am using
<set name=""......>
An error occured while Parsing an XML document.
Element type "set" must be followed by either attribute specifications, ">" or "/>".
could someone advise what mistake I am doing???
thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182714
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
