dynamic drop downs

[straffenp]

hey everyone. i'm making a site that uses drop down menus. their content
changes depending on where the user is in the site. i have a table set up in my
database that contains the info that will be in the drop downs. can i query the
datasource and have the records from the table display in my drop down list? i
also have a field in the table with a webpage; can i use that to correspond to
the record displayed? hope this makes sense. i tried it once and got it, but it
only displays one record. thanks to anyone who can help!

[mpwoodward *TMM*]

On 2005-06-20 20:26:03 -0500, "straffenp" <webforumsuser@macromedia.com> said:

> hey everyone. i'm making a site that uses drop down menus. their
> content changes depending on where the user is in the site. i have a
> table set up in my database that contains the info that will be in the
> drop downs. can i query the datasource and have the records from the
> table display in my drop down list? i also have a field in the table
> with a webpage; can i use that to correspond to the record displayed?
> hope this makes sense. i tried it once and got it, but it only displays
> one record. thanks to anyone who can help!

This is all quite possible and very simple. Concerning the drop-down
you can either just loop through the query to create the options, for
example:

<select name="myDynamicSelect">
<cfoutput query="myQuery">
<option value="#id#">#value#</option>
</cfoutput>
</select>

#id# and #value# above would be the names of the database fields you
want to use for these elements.

Or you can use cfselect inside a cfform and use the query attribute:
<cfform name="myForm">
<cfselect name="mySelect" query="myQuery"
value="database_field_with_value"
display="database_field_with_display_content" />
</cfform>

Hope that helps,
Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion