0 Replies Latest reply on Jun 11, 2010 6:19 AM by Blue-Cloud

    CF9: How  pass cfgrid values to a cfm page?

    Blue-Cloud

      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.

       

      Blue-Cloud