I have a flash form that was working a while ago, but I have recently
reinstalled coldfusion, as well as my web server.
The form displays correctly, but one field, a dropdown selection list,
will not work. I am using a query to fill the list.
The query:
<cfquery name="HOAs"
datasource="#Request.MainDSN#">
SELECT *
FROM HOAs
ORDER BY NAME
</cfquery>
The code:
<cfselect name="property" required="yes" label="Property" width="150">
<cfoutput query="HOAs">
<option value="#HOAs.hoaID#">#HOAs.hoaID# - #HOAs.name#</option>
</cfoutput>
</cfselect>
Any help will be appreciated.