Thanks Ian.
I'm getting satisfactory results now by using:
<cfprocessingdirective suppressWhiteSpace = "Yes">
<cfsetting enablecfoutputonly="yes">
combined with the checked box in the CF Admin and
<cfcontent type="text/xml" reset="yes"
before my output.
Thanks all.
On 24 Mar 2009, at 18:38, Ian Skinner wrote:
>
> Here is one way I have dealt with this issue.
>
> <cfsilent>
> <cfquery name="markers" datasource="sor">
> SELECT
> l.id,
> l.name AS location,
> l.lead,
> l.longitude,
> l.latitude,
> a.name AS activity,
> j.ranking,
> r.stars,
> r.rank,
> a.icon
>
> FROM
> locations l INNER JOIN
> location_activity_join j ON l.id = j.locationID INNER
> JOIN
> activities a ON j.activityID = a.id INNER JOIN
> location_activity_ranks r ON j.ranking = r.id
>
> WHERE
> published = 1
>
> ORDER BY
> l.name
> </cfquery>
> </cfsilent><cfcontent type="text/xml" reset="yes"><?xml version="1.0"
> encoding="iso-8859-1"?>
> <markers><cfoutput query="markers" group="location"><cfset
> cat=''><marker lng="#val(longitude)#" lat="#val(latitude)#" id="#id#"
> name="#xmlFormat(trim(location))#" category="<cfoutput><cfset cat =
> #listAppend
> (cat
> ,xmlFormat(rereplace(trim(activity),'[^[:alnum:]]','','ALL')))#></
> cfoutput>#cat#"
> activities="<cfoutput>#xmlFormat(trim(activity))#
> #repeatString('*',val(stars))#<br/></cfoutput>" />
> </cfoutput>
> </markers>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive: http://www.houseoffusion.com/groups/flex/message.cfm/messageid:5839
Subscription: http://www.houseoffusion.com/groups/flex/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.37
