Printing database fields

[Dinghus]

Okay, stuck with CF4.5. No biggy. I just want to pull data from a db and make
an xml file out of it. BUT I want it to be generic and fast. to code.

I know by the time I get an answer I could have it coded the long way so this
is for future reference.

What I want to do is run my query then do something like this:
<MYXML>
<cfoutput query="myQuery">
<OUTPUT #fieldname#="#db data#">
</cfoutput>

So how do I get the field name from the query or can I? Pretty sure I've seen
it done before.

[The ScareCrow]

query_name.columnList will give you a list of the column names

So, of the top of my head

<MYXML>
<cfloop from="1" to="#myQuery.RecordCount#" index="idx">
<cfloop index="listElement" list="#myQuery.columnList">
<OUTPUT #listElement#="#myQuery[listElement]#">
</cfloop>

Ken

[Dinghus]

strange happenings.

I had to make a few small changes to get it to work:

<MYXML>
<cfloop from="1" to="#myQuery.RecordCount#" index="idx">
<cfloop index="listElement" list="#myQuery.columnList">
<cfoutput>
<cfset outVar=#myQuery[#listElement#]#>
<OUTPUT #listElement#=>#outvar#</OUTPUT>
</cfoutput>
</cfloop>
</cfloop>

not sure why it needs to have the extra step in there but it works which will
save time and code. :)