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.
