auto display DB fields

[ryanbrand]

Hi,
Is there any way that I can have coldfusion automatically display all the fields that I select?
Example:
select * from mytable

Then have it display all the fields from mytable (in html table format) without having to name them all.

Please let me know.
Ryan

 

[ddfff]

For Sql you could try:

<cfquery datasource=#DataBaseName# name="fields">
sp_columns #Trim(tablename)#
</cfquery>

 

[webmigit]

Assuming Mytable is the name of your query...

<TABLE>
  <TR>
    <cfloop list="#mytable.columnlist#" index="i">
      <TD>#i#</TD>
    </cfloop>
  </TR>
  <cfoutput query="myqueryname">
    <TR>
      <cfloop list="#mytable.columnlist#" index="i">
        <TD>#evaluate("mytable." & i)#</TD>
      </cfloop>
    </TR>
  </cfoutput>
</TABLE>

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[ryanbrand]

Thanks a lot. Your loops worked great for me. I had to substitute the query name for the places you had the table name. I also added cfoutput tags around #i# for the column names.

Thank you!
Ryan

 

[webmigit]

I've been having issues remembering cfoutput lately in a few answers..

lol...

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.