On 9/4/00, James penned:
>This solution is if your option list is static. If you are
>outputting a query as
>your options then you need to provide a query to populate them.
>
><CFQUERY NAME="fooquery" DATASOURCE="foo_dsn">
> Select foo1,foo2 from foo_table
></CFQUERY>
>
><cfform action="select.cfm" method="post">
> <cfselect query="fooquery" value="foo1" name="letter" selected="B">
> <option value="foo1">#foo2#
> </cfselect>
> <input type=submit>
></cfform>
Except you DON'T need the option with cfselect.
<cfform action="select.cfm" method="post">
<cfselect query="fooquery" value="foo1" display="foo2"
name="letter" selected="B">
</cfselect>
<input type=submit>
</cfform>
That would only be for any option you want to show that AREN'T
returned by the query, such as a default or NULL value.
<cfform action="select.cfm" method="post">
<cfselect query="fooquery" value="foo1" display="foo2"
name="letter" selected="B">
<option value="">Select A Value If Applicable
</cfselect>
<input type=submit>
</cfform>
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
