We had to do something like
<cfloop query="qryRtn">
<cfset sRtn = sRtn & qryRtn[qryRtn.ColumnList][qryRtn.CurrentRow] />
</cfloop>
For a project we were working on that used FOR XML AUTO
HTH
On 02/06/06, Joe Graves <[EMAIL PROTECTED]> wrote:
> I have been having problems making the code below work. Any sugestions?
>
> <CFQUERY NAME="GetData" DATASOURCE="XYZ" MAXROWS=3>
> SELECT *
> FROM #TableName#
> FOR XML AUTO
> </CFQUERY>
>
> <CFOUTPUT>#GetData#</CFOUTPUT>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2474
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
