Output table values

[cleanair4me]

I would like to know if there is something where I can automatically output all fields from one table so I dont have to manually put in each field name:

<cfquery name = "myQuery" datasource = "mydsn">
select * from tableOne
</cfquery>

<cfoutput query="myQuery">
#city#<br>
#state#<br>
#county#<br>
#country#<br>
#continent#<br>
</cfoutput>

Is there a dynamic array or ColdFusion method that can automatically output all the values from one table?

 

[DigitalRedneck]

Try this:

<cfquery name = "myQuery" datasource = "mydsn">
select * from tableOne
</cfquery>
<cfoutput>
	<cfset variables.rowCount = 0>
	<cfloop query="myQuery">
		<cfset variables.rowCount = variables.rowCount + 1>
		<cfloop list="#myQuery.columnList#" index="variables.columnName">
			<cfset variables.temp = myQuery[variables.columnName][variables.rowCount]>
			#variables.columnName# = #variables.temp#<br />
		</cfloop>
		<hr>
	</cfloop>
</cfoutput>