Hi Paul. I do not want to change my website forms because I have thousands on entries. I want to build a new cfform action page.
Thanks, Barry >Hi Barry, > > >Use this: > ><cfselect name="statecodeID" size="1" class="input-text"> > <cfoutput query="States"> > <option value="#statename#">#statename#</option> > </cfoutput> ></cfselect> > >Paul. > >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:4793 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
