>The displayed value in the select isn't passed back to the form, so >just before you insert the new record you will need to query the >database for the name using the id passed through in the form, such >as... > ><cfquery name="getProject"> >SELECT project_name FROM tableName WHERE project_id = <cfqueryparam >cfsqltype="cf_sql_integer" value="#val(form.project_id)#" /> ></cfquery> ><cfquery name="insert"> >INSERT INTO otherTable (project_id, project_name) VALUES ( > #val(form.project_id)#, > '#getProject.project_name#' >) >-- Use cfqueryparam on those values as well ></cfquery> > > >-Justin > > > >>
I see ..i'll give a try Thanks justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5582 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
