I want to be able to pull data from the database and insert it into a drop down
list. I have a list of tests in the database. I am creating an evaluation
form and one of the questions is to select the test you took. I want to be
able to have the query output the results into the pull down list but I have
been unsuccessful at this point.
With this code, I get the results of every test (currently a total of five):
<table border="0" width="500" align="left">
<tr>
<td><cfoutput query="qGetTests">#qGetTests.testName#<br
/></cfoutput></td>
</tr>
</table>
I am trying to put it in a drop down list with minimal success:
<select name="Tests" size="2" multiple="no">
<option value=""><cfoutput query="qGetTests">#qGetTests.testName#<br />
</cfoutput></option>
</select>
Of course, this is only creating one option... not sure how to create multiple
options, one for every record in the database.
Any thoughts?
Thanks,
-Garebear
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2061
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
