Hi Barry,
Use this:
<cfselect name="statecodeID" size="1" class="input-text">
<cfoutput query="States">
<option value="#statename#">#statename#</option>
</cfoutput>
</cfselect>
Paul.
-----Original Message-----
From: Barry Mcconaghey [mailto:[email protected]]
Sent: Sunday, August 30, 2009 10:34 AM
To: cf-newbie
Subject: CFInsert Form (Success Message)
Hello.
I have a form on my website:
<cfquery name="States" datasource="#request.dsn#" username="#request.un#"
password="#request.pw#">
SELECT statecodeID, statename
FROM states
</cfquery>
<cfselect name="statecodeID" size="1" class="input-text">
<cfoutput query="States">
<option value="#statecodeID#">#statename#</option>
</cfoutput>
</cfselect>
When a user submits this form, a number for the statename is entered into
the database. For example: Florida is 34.
I want to display on my cfform action page the statename not the number from
the form.
The cfform action page now:
<cfoutput>
State - #FORM.statecodeid#
</cfoutput>
Display Message Now:
State - 34
I want it to display:
State - Florida
Thanks,
Barry
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4791
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
