Apache – httpservice result format

apache-flex

I use flex and php to retrieve information from my sql database. What i have been doing is formatting the result from the database query into xml and then putting the result into an arraycollection. It all works fine except one of my database fields contains a lot of text that website users enter and as xml doesn't like tags like <> so I leave it un formatted but I would like to format it. Would I be better using flashvars or text than xml? Or is there another way?

Best Answer

You should have your database code that produces the XML escape special XML characters (e.g. <, > and &) with the standard entities (<, > and &) and stick with XML.

Related Solutions

Populate ArrayCollection with HTTPService

If you can use an XMLListCollection in place of an ArrayCollection the process of converting the result object is more straightforward. Here is a good tutorial explaining how to go about this.

EDIT:

The key things to get from this tutorial are this:

you need to set the result format of the service to e4x.

you need to cast the result object as XML object, extract the repeating nodes as an XMLList, and construct an XMLListCollection from the list like so:

private function httpService_result(evt:ResultEvent):void 
{
     var xmlList:XMLList = XML(evt.result).path.to.repeating.element;
     xmlListColl = new XMLListCollection(xmlList);
}

Best Answer

Related Solutions

Populate ArrayCollection with HTTPService

Related Topic