cfselect

[Guest]

I want to add new option where no option available in existing query.
ex. In fruits, I have apple orange mango but so many missing.
I want to add new those are not in query while have some in cfselect prefix.

[CF_output]

you manually add the option...

But then your options will be out of order.

I would suggest updating your database/list/etc

<cfselect name="mySelect">
<option value="Blueberry">Blueberry</option>
<option value="Strawberry">Strawberry</option>
<cfoutput query="myQuery">
<option value="#fruit#">#fruit#</option>
</cfoutput>
</cfselect>

[fober1]

Hi,
You have to combine a edit-field where customers can enter new values, and a list-field with the existing values from the database.
When the page gets submitted, you just query if the submitted value in the edit-field already exists in the db-table and use the PK for that value, or add it to the db-table and find the PK for your new value.

cheers,
fober

===== EXAMPLE =====

<div style="width:200px; padding-right: 20px; border: 1px solid red">
<select id="text_select" size="5"
onchange="document.getElementById('text_edit').value=this[this.selectedIndex].text; this.style.display= 'none'"
style="display:none; z-index:99; position:absolute; width:100%"
>
<option>Apple</option>
<option>Orange</option>
<option>Banana</option>
</select>
<input name="xyz" id="text_edit" type="Text" style="width:100%">
<input type="Button" value="\/"
onclick="document.getElementById('text_select').style.display= 'inline'"
style="position:absolute; float:right;"
>
</div>