I get Element RCP_ID is undefined in FORM when I run the code below: If possible, Id like to continue to work with the ColdFusion.navigate function.
RCPMngmnt.cfm excerpt: <cfform name="faddRCP" size="400" id="faddRCP"> <cfgrid name="AddRCP" title="Add New RCP" selectmode="edit" insert="yes" insertButton="Click on this Button to Insert a new RCP" format="html" width="900" colHeaderBold="yes"> <cfgridcolumn name="RCP_ID" header="RCP ID" width="80"> <cfgridcolumn name="RCP_Number" header="RCP Number" width="80"> <cfgridcolumn name="Amount_of_RCP" header="Amount of RCP" width="80"> <cfgridcolumn name="Cost_Code" header="Cost Code" width="80"> <cfgridcolumn name="Mod_Number" header="If this is an amendment, please fill in the last 2 digits" width="80"> <cfgridcolumn name="Funding_Year" header="Fiscal Year" width="80"> <cfgridcolumn name="fk_ProgID" header="Program" width="80"> <cfgridcolumn name="fk_ParentMTF" header="Parent MTF" width="80"> <cfgridcolumn name="fk_ChildMTF" header="Child MTF (if applicable)" width="80"> <cfgridcolumn name="Date_Recived" header="Date Received" width="80"> </cfgrid> <cfinput type="button" name="gridInsert" id="gridInsert" value="Submit New RCP" onclick="javascript:ColdFusion.navigate('RCPMngmnt_Insert.cfm','InsertResults','','','Get','faddRCP')" /> </cfform> <cfdiv id = "InsertResults" bind="url:blank.cfm"></cfdiv> RCPMngmnt_Insert.cfm: <cfajaximport tags="cfdiv,cfgrid"> <cfoutput> <cfquery name="qAddRCP" datasource="#request.ATCdsn#"> Insert into RCP_table (RCP_ID, RCP_Number, Date_Recived, Amount_of_RCP, cost_code, modification_number, modification_amount, fk_ProgID, fk_ParentMTF, fk_ChildMTF, entry_date, entered_by, funding_year) VALUES(#form.RCP_ID#,'#form.RCP_Number#','#form.Date_Recived#','#form.Amount_of_RCP#',#form.cost_code#, #form.modification_number#, '#form.modification_amount#', #form.fk_ProgID#, '#form.fk_ParentMTF#', '#form.fk_ChildMTF#', '#form.entry_date#', '#form.entered_by#', #form.funding_year#) Select RCP_Number = @@Identity </cfquery> <cfquery name="qAddedRCP" datasource="#request.ATCdsn#"> SELECT * from RCP_table WHERE RCP_Number = '#form.RCP_Number#' </cfquery> </cfoutput> <cfoutput> <cfform name="AddedRCP"> <cfgrid name="AddedRCP" title="Added RCP" striperows="yes" query="qAddedRCP" preservePageOnSort="true" format="html" pagesize="30" width="900"> <cfgridcolumn name="RCP_Number" header="RCP Number" width="88"> <cfgridcolumn name="Amount_of_RCP" header="Amount of RCP" width="88"> <cfgridcolumn name="Cost_Code" header="Cost Code" width="88"> <cfgridcolumn name="Funding_Year" header="Fiscal Year" width="88"> <cfgridcolumn name="fk_ProgID" header="Program" width="88"> <cfgridcolumn name="fk_ParentMTF" header="Parent MTF" width="88"> <cfgridcolumn name="fk_ChildMTF" header="Child MTF" width="88"> <cfgridcolumn name="Entry_date" header="Last Changed On" width="88"> <cfgridcolumn name="Entered_by" header="Last Changed By" width="88"> </cfgrid> </cfform> </cfoutput> Thanks in advance for any assistance you can provide. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm