cfselect bound to query w/o initial value?

[sockerdad]

Here's the code:

<cfinvoke component="Functions"

method="GetAllStewards"

returnVariable="AllStewards"

</cfinvoke>

<cfselect Name="NewSteward"

query="AllStewards"

display="FullName"

value="MemberID"

required="No"   

selected=" "

</cfselect>

Here's the problem:  The cfselect always "contains" the MemberID value for the first steward in the list.

Here's what I want:  If the values in the cfselect are not clicked, I want the value in NewSteward to be blank.  How do I do this?

[BKBK · Accepted solution]

Introduce a blank option, then use the attribute queryPosition to position the items from the query relative to the blank option

<cfselect  Name="NewSteward"

query="AllStewards"

display="FullName"

value="MemberID"

required="No"

queryPosition="below">

<option value="your_default_value"></option>

</cfselect>