Try this:
<!--- Request Impact Area List --->
<select name="impact_area">
<cfoutput query="getImpactAreas">
<option value="#key_code#" <cfif
trim(lcase(getImpactAreas.key_code)) EQ
trim(lcase(getchangerequests.impactarea))>selected</cfif>>#key_desc#</op
tion>
</cfoutput>
</select>
-----Original Message-----
From: Kevin Roche [mailto:[EMAIL PROTECTED]
Sent: Monday, December 11, 2006 11:01 AM
To: CF-Talk
Subject: RE: Whats wrong with this bit of code?
perhaps there are spaces in one or other of the fields?
-----Original Message-----
From: Peter Tanswell [mailto:[EMAIL PROTECTED]
Sent: 11 December 2006 02:49
To: CF-Talk
Subject: Whats wrong with this bit of code?
I have been trying to figure out why the value that is in both tables is
not
being shown as the one that is being initally displayed.
The select box is still working but there is current;y no value
displayed as
the selected value.
Any ideas on this one.
Thanks in advance
<!--- Request Impact Area List --->
<select name="impact_area">
<cfoutput query="getImpactAreas">
<option value="#key_code#" <cfif getImpactAreas.key_code IS
getchangerequests.impactarea>selected</cfif>>#key_desc#</option>
</cfoutput>
</select>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263533
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
