Doesn't help me because I am not using a query as my option list is not in the
database.
At 09:18 PM 9/2/00 -0400, Bud wrote:
>On 9/2/00, Peter Theobald penned:
>>[cfform action="#CGI.SCRIPT_NAME#" method="post">
>> [cfselect name="letter" selected="B">
>> [option value="A">Apple
>> [option value="B">Bear
>> [option value="C">Car
>> [/cfselect>
>> [input type=submit>
>>[/cfform>
>
>The options you put in there will not be selected. They will only be
>in addition to the options output by the query, which is noticeably
>absent from your cfselect tag.
>
>So, you run a query to get all the states "GetStates" that returns an
>ID for the state and the state's name. Then you run a query on a user
>"GetUser" to get his state ID on an update page.
>
>cfselect
>name="state_id"
>query="GetStates"
>selected="#GetUser.state_id#"
>value="state_id"
>display="state"
>
>If the users state if Florida and the state ID is FL, this will
>return all the states, with the users looking like:
>
>[select name="state_id">
>[option value="FL" selected>Florida
>
>You would want to add an option manually maybe on the signup page
>where you could put:
>
>[option value="">Select A State
>
>
>
>--
>
>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.
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
------------------------------------------------------------------------------
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.
