Hello Everybody.

I'm trying to build a form that only has one cfselect or drop-down menu option 
on my website. Right now I have two cfselect but I would like to only display 
the first cfselect (player). The second cfselect (contactID) I would like to 
hide. The player selected in the first cfselect should match the second 
cfselect contactID and go to the action page.

<cfform name="AllPlayers" action="AddPlayers.cfm">

<cfselect name="player" size="1">

<cfoutput query="contacts">
   <option value="#FirstName# #LastName#">#FirstName# #LastName#</option>
</cfoutput>

</cfselect>

<cfselect name="contactid" size="1">

<cfoutput query="contacts">
   <option value="#contactid#">(#contactid#) #FirstName# #LastName#</option>
</cfoutput>

</cfselect>

</cfform>

Action page - addplayers.cfm

<cfinsert datasource="mydatabase"
         tablename="player"
         formfields="contactID, player">

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-talk/message.cfm/messageid:330588
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to