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
