Thanks alot. I actually spent the evening writing a xml to actionscript and actionscript to xml converters. I am using mysql with jdbc and I dont think there is any such capability with these tools. The interesting thing is reading such xml is built into XMLDecode, which is an undocumented api for parsing XML into actionscript. But its unclear what rules it uses to determine how to convert such things as dates. In any case it didnt work right because there was no way I could find to indicate that even though it saw a number that I really wanted that number to be treated as a string.
Regards, Hank On 11/25/06, Flexy <[EMAIL PROTECTED]> wrote:
Hello Hank, Some DB's can return result sets in XML all by themselves. IIRC SQLServer can do this. So middle tier is no longer an issue either.. Hope this helps, Flexy. ------------------------------ *From:* [email protected] [mailto:[EMAIL PROTECTED] *On Behalf Of *hank williams *Sent:* Sunday, November 26, 2006 12:57 AM *To:* [email protected] *Subject:* [flexcoders] best way to do database to Java to XML to flex I have been using remoting to get data out of my database and into flex. The nice thing about this is it handles all the data conversion issues etc. But now, I have a need to be able to communicate certain data in XML format. I would imagine that there must be a clean process/format for communicating between server and client in XML such that the datatypes and reserved characters such as ",',>,<,& are handled. what is the easiest way of doing this? Is there some XML database communications standard which flex can read? Do people just roll their own (ugh?). There must be a clean easy way to do this. Hank
