> 1) write to an existing xml file?
> * Yes. you use cffile to do this.
> 2) write a new xml file?
> * again, you use CFFILE to do this
> 3) what is the method used assuming the general assortment of data, like
> #tickerdate# #tickernewstext# and #tickerlink#, blah, blah?
> * as I mentioned, you can query your db to retrieve the data in your existing
> DB, and write it out as XML to match your existing doent.
> I am assuming that it actually writes the content, but can it also write
> the necessary tags required by the flash app,
> *tags aside from XML?
> or would you use some sort
> of template that already has those or would you concactenate the tags
> with the data references to produce a string that is then written to an
> xml file?
> * thats the old school way to do it. which is how I did it, (pre MX)
> check out how I did it: this is coming from a single table, but should show
> you one method. again, with CFMX there is cleaner way to do it (although this
> method for me produced a pretty xml doc that looked right, but must have had
> extra charcters in it, as it didn't work)
> <!----- heres the code ---->
> <cfset thisDS = "everb">
> <cfquery datasource="#thisDS#" name="getSeasons">
> Select * FROM seasons order by id DESC
> <cfset thisString = "<?xml version=""1.0""
> <cfloop query="getSeasons">
> <cfset currentSeason = (getSeasons.recordcount+1) - getSeasons.currentrow>
> <cfquery datasource="everb" name="getSeasonPics">
> Select images.image, images.id from images, seasonImage, seasons
> where images.id = seasonimage.imgid AND seasonImage.seasonID = seasons.id
> AND seasons.id = #getSeasons.id# order by images.id ASC
> <cfset thisString = thisString & "<season idName=""#seasonname#""
> <cfloop query="getSeasonPics">
> <cfset thisString = thisString & "<img>#image#</img>">
> <cfset thisString = thisString & "</season>">
> <cfset thisString = thisString & "</seasons><main><nav idName=""everB
> Profile""></nav><nav idName=""Stores""></nav><nav
> <cffile action="write" file="#thepath#\everb.xml" nameconflict="overwrite"
> <!--- end of code ---->
> and here is the xml it made from the db ....
> <?xml version="1.0" encoding="UTF-8"?><everb><seasons><season idName="season5"
> idName="pwned" id="4"><img>IMG_605.jpg</img></season><season idName="season3"
> eason idName="Fresh"
> id="2"><img>ebs01.jpg</img><img>ebt09.jpg</img></season><season idName="You own
> asons><main><nav idName="everB Profile"></nav><nav idName="Stores"></nav><nav
> let me know if that helps. You can defintely do what you are asking, and I'm
> pretty sure I understand.
> you have existing db and cf queries, that you want to use to create an XML doc
> that will be later read by flash. the xml doc created needs to match the format
> exactly to feed the flash movie.
> the above example will show you the old way.
> the new way ....
> well ...
> type xml coldfusion into google, or check out the livedocs example for MX.