Try this: ><select name="Tests" size="2" multiple="no"> ><cfoutput query="qGetTests"> ><option value="">#qGetTests.testName#<br /></option> ></cfoutput> ></select>
[email protected] on Wednesday, September 20, 2006 at 8:19 AM -0800 wrote: >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:2062 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
