I'm getting an error message. I added this inside my CFFORM
<input type="text" size="40" name="carpool_location" /> 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, carpool_location) VALUES (#FORM.player#,'#getFirstAndLast.FirstName# #getFirstAndLast.LastName#', #FORM.carpool_location#) </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:330614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
