Sorry, this is probably very simple but I can't figure it out. I have a
pre-selected value on my select box but it won't display. It should
pre-select Maryland but it goes to the first option, Alaska. If I hard-code
"MD" into the 'SELECTED' parameter of the CFSELECT tag, the right option is
selected but if it is drawn from the query, it is wrong. Can anyone tell me
why?
The URL is:
http://206.239.48.11/test.cfm
The code is:
<CFQUERY name="query_state" datasource="closingquotesdev">
SELECT state_des, state_abbrev
FROM states
ORDER BY state_abbrev
</CFQUERY>
<CFQUERY NAME="GetCompanyAddress" datasource="closingquotesdev">
SELECT state
FROM dbo.comp_address
WHERE comp_address.company_address_id = 299
</CFQUERY>
<CFOUTPUT>GetCompanyAddress.state:
#GetCompanyAddress.state#</CFOUTPUT><BR><BR>
<CFFORM ACTION="" METHOD="POST">
<FONT face="MS SANS SERIF, HELVETICA" size="-1">State: <FONT
COLOR="Red">*</FONT><BR>
<CFSELECT NAME="state" MESSAGE="Please select your state."
QUERY="query_state" VALUE="state_abbrev" DISPLAY="state_des"
SELECTED="#GetCompanyAddress.state#"></CFSELECT></FONT>
</CFFORM>
Thanks.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Simon Park Computer Systems Management, Inc.
[EMAIL PROTECTED] 205 South Whiting Street
Ph: 703-823-4300 Suite 201
fax: 703-823-4301 Alexandria, VA 22304
http://www.csmi.com
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
