Dump a table

[mmorgensen]

How would I go about dumping a table w/o knowing the fields?

I have a settings table that new fields are added on a regular basis to interact with our application. I would like to create a form that would dump all the settings table, display the results, then allow me to update them.

ideas? I know how to do this statically, but I do not want to change the cfm file every time a new field is added. I do not care about a description, I only need the values.

thanks!

mm

 

[r937]

this is one of the few times you can use "select star" on purpose and benefit from it

presumably you would not put something like this into production, because the output is so ugly

[tt]<CFQUERY NAME=&quot;foo&quot; DATASOURCE=&quot;bar&quot;>
select *
from unfamiliartable
</CFQUERY>

<CFDUMP var=&quot;#foo#&quot;>[/tt]


rudy