RE: [CFTALKTor] converting a table of CSV values into something Flash can read?

[Nolan J. Dubeau]

You could have CF generate the XML structure by looping over a query or List, instead of serializing and de-serializing using WDDX.      i.e.     <cfquery name =”foo” datasource=”foo”>             Select field_ID, field1, field2             FROM table             Order by ID </cfquery>       <?xml version="1.0" encoding="UTF-8" ?> <items> <cfloop query=”foo”>             <myitem ID=”#field_id#>#field1#, #field2#</myitem> </cfloop> </items>   You would have strip the whitespace out in Flash, but I’ve used this method before.   It’s a bit of a workaround, but it does work. There are different ways of structuring the output but it is handy to user node attributes (such as ID field) within individual nodes. It is easier to reference the data this way.  Use LoadVariables in Flash to access the CFM page that has the XML output.   You could also try loading the info in using URL encoding.  See http://www.flashcfm.com   Hope this helps,   Nolan   Nolan J. Dubeau Senior Developer, (*Maracca) Application Design & Technology ------------------------------------------------ p. 416.532.8852 e. [EMAIL PROTECTED]     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jeremy Oudit Sent: Monday, April 08, 2002 2:56 PM To: [EMAIL PROTECTED] Subject: [CFTALKTor] converting a table of CSV values into something Flash can read?   I'm trying to read a table of comma separated values using cold fusion so that I can pump them out using XML or something else that Flash can read. Anyone done this or know how this can be done. Or is this something I'm going to have to wait for the new cold fusion to do?   thanks Jeremy