1 Reply Latest reply on Dec 13, 2010 5:37 PM by Dan Bracuk

    Passing multiple values to another page

    brian_williamson Level 1

      I am somewhat new to Coldfusion 9 in a IIS platform through Dreamweaver CS4 and could use some direction.  I am working on a form where someone has submited a request for approval.  The user has requested a bulk approval button for all users that fall under certain filter conditions to do a mass approve ( setting the value to 1).  I have not been able to either pass the values to the current approval method or approve them on the existing page.  Below is the coding for the page as I have it.

      After the filter has applied I need to get the values of the #qRecords.VR_Machine_Participant_Activity_Login_ID# and have them all approve as apposed to doing them individually which they are doing now.  I have looked at several methods, but they are not meeting my needs.  Some information cut for space but left the form action.

       

      <form name="form1" method="post">
          <table width="996" border="1">
                      
           <tr class="ReportColumnHeadingSmall">
            <td width="150">Approval Needed</td>
            <td width="100">Approved</td>
                              <td width="180">Business Unit</td>                    
           </tr>
           <tr class="data0Small">
            <td>
             <select name="cboApprovalRequired" class="smallFont">
              <!---<option value="All">All</option>--->
                       <option value="1"
               <cfif isDefined("vApprovalRequired")>
                <cfif vApprovalRequired eq 1>
                  selected
                </cfif>
               </cfif>
              >True</option>
                       <option value="0"
               <cfif isDefined("vApprovalRequired")>
                <cfif vApprovalRequired eq 0>
                  selected
                </cfif>
               </cfif>
              >False</option>
             </select>
            </td>
            <td>
             <select name="cboApproved" class="smallFont">
              <!---<option value="All">All</option>--->
                       <option value="1"
               <cfif isDefined("vApproved")>
                <cfif vApproved eq 1>
                  selected
                </cfif>
               </cfif>
              >True</option>
                       <option value="0"
               <cfif isDefined("vApproved")>
                <cfif vApproved eq 0>
                  selected
                </cfif>
               </cfif>
              >False</option>
             </select>
            </td>
                                <!--- Drop down showing the current available units to choose from --->
                               <td>
                         <select name="cbo_BusUnit" id="cbo_BusUnit">
                              <cfoutput query="qBusUnit">
                               <option value="#qBusUnit.BusinessUnit#"
                              <cfif (isDefined("vBusUnit") AND vBusUnit is qBusUnit.BusinessUnit)>selected                               </cfif>>#qBusUnit.BusinessUnit#</option>
                                </cfoutput>
                              </select>
                            </td>

       

       

      <!--- This is where I'd like to mark the items for approval. --->
                              <td><input type="submit" name="Submit" value="Apply Filter">
                              </td>                       
            <td width="450" align="right">
              This will approve all records displayed on the current page.
                                <input name="bVr_id" type="button" value="Approve">
                                       
        <cfoutput query="qRecords"><a href=   "vr_participantactivityapproval.cfm?participant=#qRecords.VR_Machine_Participant_Activity _Login_ID#">
          <img src="../Images/switch_user.gif" alt="Approve" width="16" height="16" border="0"></a>
         
          </cfoutput>
      </td>
           </tr>
           <tr class="ReportColumnHeadingSmall">
                           <td colspan="3" height="20"></td>
                          </tr>
          </table>
      <table width="996" border="1">
      <tr class="ReportColumnHeadingSmall">
          <td></td>
          <td>Machine or<br>Activity Type</td>
          <td>Activity</td>
          <td>Comments</td>
          <td>Oper.<br>ID</td>
          <td>Name</td>
          <td>Approved</td>
          <td>Login Status</td>
          <td>Login Date Time</td>
          <td>Minutes</td>
      </tr>
      <cfoutput query="qRecords">
      <tr class="data#Int(qRecords.CurrentRow MOD 2)#Small">
      <td>


                          <!--- Current method of approving them individually. --->    

      <a href="vr_participantactivityapproval.cfm?participant=#qRecords.VR_Machine_Participant_Act ivity_Login_ID#"><img src="../Images/switch_user.gif" alt="Approve" width="16" height="16" border="0"></a>
        </td>


        <td class="SmallFont">#qRecords.ActivityType#</td>
      <td class="SmallFont">#qRecords.Activity#</td>
          <td class="SmallFont">#qRecords.Value_Nvarchar#</td>
      <td class="SmallFont">#qRecords.VR_Department_Number#</td>
      <td class="SmallFont">#qRecords.FullName#</td>
      <td class="SmallFont"><cfif #qRecords.Approved# IS 0>False<cfelse>True</cfif></td>
          <td class="SmallFont">#qRecords.Login_Status#</td>
          <td class="SmallFont">#DateFormat(qRecords.Login_Date, 'ddd mm/dd/yyyy')# #TimeFormat(qRecords.Login_Date, 'H:mm')#</td>
          <td class="SmallFont">#qRecords.TotalTime#</td>
      </tr>
      </cfoutput>
      </table>
          </form>