Thanks Chad! It worked.
Question...how do I add more input fields. I would like to add this to my final code: <input type="text" size="40" name="carpool_location" /> Final code that works: <cfselect name="player" size="1"> <cfoutput query="contacts"> <option value="#contacts.contactID#">#contacts.FirstName# #contacts.LastName#</option> </cfoutput> </cfselect> Action page: <cfquery datasource="mydb" name="getFirstAndLast"> SELECT FirstName, LastName FROM contacts WHERE contactid = #FORM.player# </cfquery> <cfquery datasource="mydb" name="insertPlayer"> INSERT player (contactID, player) VALUES (#FORM.player#,'#getFirstAndLast.FirstName# #getFirstAndLast.LastName#') </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:330611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
