need help in this select drop down box

Report · Jan 29, 2010

Hi i had a drop down box written with select and i had many options , when user selects the option it will insert this to database and when user goes to the edit form the preselected value has to be populate automatically in dropdown , but the last option is populating everytime when uses edit form.

below is the code:

insert page:

<select name="council" id="council" name="Please select Council from dropdown box">
                <option value="Division">Division</option>
                <option value="Facility">Facility</option>
                <option value="District D">District D </option>
                <option value="District E">District E </option>
                <option value="District J">District J </option>
                <option value="District K">District K </option>
                <option value="District L">District L </option>
                <option value="District M">District M </option>
                <option value="District N">District N </option>
                <option value="District O">District O </option>
                <option value="District Q">District Q </option>
                <option value="District S">District S </option>
                <option value="District T">District T </option>
                
                <option value="D 506">D 506</option>
                <option value="D 524">D 524</option>
                <option value="D 525">D 525</option>
                <option value="D 530">D 530</option>
                <option value="D 531">D 531</option>
                <option value="D 536">D 536</option>
                <option value="D 549">D 549</option>
                <option value="D 558">D 558</option>
                <option value="D 562">D 562</option>
                <option value="D 581">D 581</option>
                <option value="D 583">D 583</option>
                <option value="D 597">D 597</option>
                <option value="D 598">D 598</option>
                <option value="D 599">D 599</option>
                <option value="D 628">D 628</option>
                <option value="D 686">D 686</option>
                <option value="D 698">D 698</option>
                <option value="D 848">D 848</option>
                <option value="D 862">D 862</option>
                <option value="D 870">D 870</option></select>

this is edit page code:

                   <select name="council" id="council">
               <cfoutput query="getdata">
                <option value="Division" <cfif council IS "#getdata.council#"> selected</cfif>>Division</option>
                <option value="Facility" <cfif council IS "#getdata.council#"> selected</cfif>>Facility</option>
                <option value="District D" <cfif council IS "#getdata.council#"> selected</cfif>>District D </option>
                <option value="District E" <cfif council IS "#getdata.council#"> selected</cfif>>District E </option>
                <option value="District J" <cfif council IS "#getdata.council#"> selected</cfif>>District J </option>
                <option value="District K" <cfif council IS "#getdata.council#"> selected</cfif>>District K </option>
                <option value="District L" <cfif council IS "#getdata.council#"> selected</cfif>>District L </option>
                <option value="District M" <cfif council IS "#getdata.council#"> selected</cfif>>District M </option>
                <option value="District N" <cfif council IS "#getdata.council#"> selected</cfif>>District N </option>
                <option value="District O" <cfif council IS "#getdata.council#"> selected</cfif>>District O </option>
                <option value="District Q" <cfif council IS "#getdata.council#"> selected</cfif>>District Q </option>
                <option value="District S" <cfif council IS "#getdata.council#"> selected</cfif>>District S </option>
                <option value="District T" <cfif council IS "#getdata.council#"> selected</cfif>>District T </option>
                <option value="D 506" <cfif council IS "#getdata.council#"> selected</cfif>>D 506</option>
                <option value="D 524" <cfif council IS "#getdata.council#"> selected</cfif>>D 524</option>
                <option value="D 525" <cfif council IS "#getdata.council#"> selected</cfif>>D 525</option>
                <option value="D 530" <cfif council IS "#getdata.council#"> selected</cfif>>D 530</option>
                <option value="D 531" <cfif council IS "#getdata.council#"> selected</cfif>>D 531</option>
                <option value="D 536" <cfif council IS "#getdata.council#"> selected</cfif>>D 536</option>
                <option value="D 549" <cfif council IS "#getdata.council#"> selected</cfif>>D 549</option>
                <option value="D 558" <cfif council IS "#getdata.council#"> selected</cfif>>D 558</option>
                <option value="D 562" <cfif council IS "#getdata.council#"> selected</cfif>>D 562</option>
                <option value="D 581" <cfif council IS "#getdata.council#"> selected</cfif>>D 581</option>
                <option value="D 583" <cfif council IS "#getdata.council#"> selected</cfif>>D 583</option>
                <option value="D 597" <cfif council IS "#getdata.council#"> selected</cfif>>D 597</option>
                <option value="D 598" <cfif council IS "#getdata.council#"> selected</cfif>>D 598</option>
                <option value="D 599" <cfif council IS "#getdata.council#"> selected</cfif>>D 599</option>
                <option value="D 628" <cfif council IS "#getdata.council#"> selected</cfif>>D 628</option>
                <option value="D 686" <cfif council IS "#getdata.council#"> selected</cfif>>D 686</option>
                <option value="D 698" <cfif council IS "#getdata.council#"> selected</cfif>>D 698</option>
                <option value="D 848" <cfif council IS "#getdata.council#"> selected</cfif>>D 848</option>
                <option value="D 862" <cfif council IS "#getdata.council#"> selected</cfif>>D 862</option>
                <option value="D 870" <cfif council IS "#getdata.council#"> selected</cfif>>D 870</option>

</cfoutput>
</select>

i dont know where i am making mistake and i observered one behavoir that if i have less options it is working but not with many why like that , please help me in this

Thanks

Report · Jan 29, 2010

the selected attribute of cfselect would be useful.

Report · Feb 02, 2010

Seems to me your conditionals should look something like this:

<option value="Division"<cfif getData.council is "Division"> selected="selected"</cfif>>Division</option>

<option value="Facility"<cfif getData.council is "Facility"> selected="selected"</cfif>>Facility</option>

Your condition is the same for every option, and would likely never evaluate to true:

<cfif council IS "#getdata.council#"> selected</cfif>

getData.council will be "Division" or "Facility" or "District D" or ...

... but it would never be "council".

HTH.

Charlie