Skip to main content
Known Participant
September 2, 2008
Question

Output table field values

  • September 2, 2008
  • 1 reply
  • 305 views
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?
    This topic has been closed for replies.

    1 reply

    Inspiring
    September 2, 2008
    columnlist