XML from Query

[Superflu]

I have a CFC webservice that return a query to my Flex application. I want it to return an XML built from that query. Anyone did this before or can give me a hand in this?

Thanks.

[Dan_Bracuk]

I did it with the cfxml tag once.

[SteveBryant]

Another thing to remember is that you can have ColdFusion output XML in the exact same way that you have it output HTML. No difference to the ColdFusion engine.

[Guest]

Not sure but how about something like this...

<cfoutput>
<cfset qry = QueryNew("col_a,col_b") />
<cfset QueryAddRow(qry, 2) />

<cfset QuerySetCell(qry, "col_a", "column 1 : row 1", 1) />
<cfset QuerySetCell(qry, "col_b", "column 2 : row 1", 1) />

<cfset QuerySetCell(qry, "col_a", "column 1 : row 2", 2) />
<cfset QuerySetCell(qry, "col_b", "column 2 : row 2", 2) />

<cfwddx action="CFML2WDDX" input="#qry#" output="myWddx" />

<form>
<textarea cols="100" rows="20">#myWddx#</textarea>
</form>
</cfoutput>

[Wilgeno_wnt]

This code works for us. The reason the code is on one line is the requirement for there to be no blank lines in XML.