How to add dynamic pulldown to this code ?

Hi Olivia,

I'm not quite sure if you're only refreshing the drop down as the page refreshes, or dynamically (i.e. many times without the page refreshing).  If it is the former, the code below should work fine.  If you need it truly dynamically, I'd bind the code through a function/cfc that will populate the select.

<!--- Select the data from the db for the select box --->

<cfquery name="getSelectOptions" DATASOURCE="#DSN#" >
        SELECT blah...blah...select options
        FROM blah...blah...table
</cfquery>

   <!--- On recordcount, use the number coming back in the query, +4 for A,F,H,U, +1 for whatever you want to "name" this.

          if you have 6 + 4 + 1, ultimately totalrows = 11)  so this could be (getSelectOptions.recordcount+5)--->
   <CFSET totalRows = (getSelectOptions.recordcount+1)>

     <!--- Here, replace "Category" with whatever your "SELECT" field was.  Could be "OPTION".--->
   <CFSET getCategory = QueryNew("Category", "VarChar")>
   <CFSET newRow = QueryAddRow(getCategory, totalRows)>

     <!--- Here, replace the getCategory with whatever you want to call this query.  Roll this throughout the code.  Replace "Category" with what

       you used above ... "OPTION". --->
   <CFSET temp = QuerySetCell(getCategory, "Category", "", 1)>

     <!--- Now you can insert your A & F, like this--->

     <cfset temp = QuerySetCell(getCategory, "Category", A, 2)>

     <cfset temp = QuerySetCell(getCategory, "Category", F, 3)>

     <!--- Now run through your query options--->
   <CFSET counter = 4>
   <CFLOOP QUERY="getSelectOptions">
      <CFSET temp = QuerySetCell(getCategory, "Category", Category, counter)>
      <CFSET counter = counter+1>
   </CFLOOP>

<!--- You can add in your other options H, U--->

Your new query is getCategory, and/or whatever you call it.

To make this bindable, wrap it in a function, declare a var, use cfreturn to return getCategory.

good luck!

cfwild

How did you try to add dynamic content?

How did that break your code?  Error messages? What?

Create db table with options values: A,F,H,U.

Create a query that gets all the option values.

Output db table by created query:

<select name="conditionCode_#x#">

<cfloop query="optionvalues">

<option value="#option#">#option#</option>

</cfloop>

</select>