Looping through Query without field names 1

[JohnandSwifty]

Hi,

I would like to configure an export routine that will work regardless of fieldname changes in the DB table etc. So i want to query DB with a SELECT * (because i dont know what the fields are, and i want them all). I then want to loop through and output the resulting query (not using cfdump). I would also like to be able to put the field name at the top of the columns - anyone know how to get the field name?

Thanks

 

[r937]

#queryname.ColumnList# returns a comma-delimited list of the query columns

r937.com | rudy.ca

 

[JohnandSwifty]

Brilliant - thanks!