Not what you may be looking for but you might try converting the 
entire cfquery into XML.  I wrote this in CF to convert any query 
into XML.

<cffunction name="query2xml" returntype="string">
  <cfargument name="inq" required="yes"  type="query"/>
  <cfset var exml = ''>
  <cfset rowcount = 0>
  <cfset exml = "<cfquery>">
  <cfset carray = listtoarray(inq.columnlist)>
  <cfloop query="inq">
   <cfset rowcount = rowcount + 1>
    <cfset exml = exml & "<row>">
    <cfloop from="1" to="#arraylen(carray)#" index="i" >
     <cfset v = inq[#carray[i]#][#rowcount#]>
     <cfset exml = exml & "<#carray[i]#>#xmlformat(v)#</#carray[i]#>">
   </cfloop>
   <cfset exml = exml & "</row>">
  </cfloop>
  <cfset exml = exml & "</cfquery>">
  <cfreturn exml>
 </cffunction>






--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/flexcoders/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/flexcoders/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to