My method to create the XML
<cffunction name="queryToXML" access="public" output="no" returntype="xml">
<cfargument name="query" required="true">
<cfset var xmlString = "" />
<cfset var columnName = "" />
<cfsavecontent variable="xmlString">
<query columns="<cfoutput>#ListLen(arguments.query.columnlist)#</cfoutput>"
rows="<cfoutput>#arguments.query.recordCount#</cfoutput>">
<cfoutput query="arguments.query">
<row>
<cfloop list="#arguments.query.columnlist#" index="columnName">
<#lcase(columnName)#>
<cfif IsNumeric(evaluate("arguments.query.#columnName#"))>
#trim(evaluate("arguments.query.#columnName#"))#
<cfelse>
<![CDATA[
#trim(evaluate("arguments.query.#columnName#"))#
]]>
</cfif>
</#lcase(columnName)#>
</cfloop>
</row>
</cfoutput>
</query>
</cfsavecontent>
<cfreturn xmlParse(xmlString) />
</cffunction>
--
To post to this group, send email to [email protected]
For more options and to unsubscribe, visit this group at
http://groups.google.com/group/mach-ii-for-coldfusion?hl=en
SVN: http://svn.mach-ii.com/machii/
Wiki / Documentation / Tickets: http://trac.mach-ii.com/machii/
