Hi does anybody know how to populate a list box (named which_fields) with the column names of a table from a query (named database_fields)?
I have tried various things and the best I've done is create a list box with no column names in it using this code:
where am I going wrong???
Thanks in advance for any help
I have tried various things and the best I've done is create a list box with no column names in it using this code:
Code:
<cfFORM name="DateForm" ACTION="Download.cfm" METHOD="post"><div align="center"><BR>
<B>Select recordset type to download:</B><BR>
<select name="which_fields" display= "label" required="yes">
<cfloop list="#database_fields.ColumnList#" index="MyColumnName">
<option value="#MyColumnName#"></option></cfloop> </select>
where am I going wrong???
Thanks in advance for any help