Good Afternoon All,
Im having some trouble coming up with a solution to a calculation problem in Coldfusion, and the real problem is that I'm trying to calculate numbers from a CFLOOP where the data isn't actually in the database. So we have a simple web page, that lists budget items that are considered open, and needing action. In that data set, we have a date, and that date is the date the funding action was approved, and basically starts a clock. From that date, I use a cfscript, listed below to calculate the number of working days from the approval date to the current date and I display that on the web page, but that number is not in the database sinc eit changes every day until the action is closed. Everything works as I had anticipated it would, but now there is a request to get the total number of days, and the avg of days. Now I'm in trouble because it doesn't seem to be a simple as doing a calculation on the database. My code is listed below, and any help would be greatley appreciated!!!
<CFQUERY DATASOURCE="MCA_Oracle" NAME="CecomInput">
SELECT
DISTINCT BUDGET_MIPRS_SENT.MIPR_ID,
BUDGET_MIPRS_SENT.FY,
BUDGET_MIPRS_SENT.JONO,
BUDGET_MIPRS_SENT.ISEC_POC
,
BUDGET_MIPRS_SENT.CUSTOMER
_WBS,
BUDGET_MIPRS_SENT.CUSTOMER
_ORG,
BUDGET_MIPRS_SENT.STATE,
BUDGET_MIPRS_SENT.PROJ_NO,
BUDGET_MIPRS_SENT.MIPR_NUM
BER,
BUDGET_MIPRS_SENT.PURPOSE,
BUDGET_MIPRS_SENT.DATE_MIP
R_REQUESTE
D,
BUDGET_MIPRS_SENT.STATUS_C
OMMENT,
BUDGET_MIPRS_SENT.INC_DEC,
BUDGET_MIPRS_SENT.APPROVAL
_DATE,
BUDGET_MIPRS_SENT.PR_OAL,
BUDGET_MIPRS_SENT.PR_DATE,
BUDGET_MIPRS_SENT.PR_DAYS,
BUDGET_MIPRS_SENT.PR_COMME
NTS,
BUDGET_MIPRS_SENT.PR_PRIOR
ITY,
BUDGET_MIPRS_SENT.PR_ACTIO
N,
BUDGET_MIPRS_SENT.PR_AMOUN
T,
BUDGET_MIPRS_SENT.PR_ID,
BUDGET_MIPRS_POC.MIPR_TO,
SUBQUERY1.COMMITED,
SUBQUERY2.REVISEDTOTAL,
SUBQUERY3.INCDATE,
(SUBQUERY2.REVISEDTOTAL - SUBQUERY1.COMMITED) as diff
FROM MCA.BUDGET_MIPRS_SENT, MCA.BUDGET_MIPRS_POC,
(SELECT MIPR_ID, SUM(COALESCE(BUDGET_MIPRS_
TRANSACTIO
NS.A_COMMI
T,0)) AS
   COMMITED
   FROM MCA.BUDGET_MIPRS_TRANSACTI
ONS
   WHERE BUDGET_MIPRS_TRANSACTIONS.
INC_DEC IS NULL
   GROUP BY BUDGET_MIPRS_TRANSACTIONS.
MIPR_ID) SUBQUERY1,
(SELECT MIPR_ID, SUM(COALESCE(BUDGET_MIPRS_
TRANSACTIO
NS.A_COMMI
T,0)) AS
   REVISEDTOTAL
   FROM MCA.BUDGET_MIPRS_TRANSACTI
ONS
   GROUP BY BUDGET_MIPRS_TRANSACTIONS.
MIPR_ID) SUBQUERY2,
(SELECT MIPR_ID, MIN(INC_APPROVAL_DATE) AS
   INCDATE
   FROM MCA.BUDGET_MIPRS_TRANSACTI
ONS
   GROUP BY BUDGET_MIPRS_TRANSACTIONS.
MIPR_ID,BU
DGET_MIPRS
_TRANSACTI
ONS.INC_AP
PROVAL_DAT
E) SUBQUERY3
Â
  Â
WHERE
 BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY1.MIPR_ID
 AND BUDGET_MIPRS_SENT.MIPR_ID = BUDGET_MIPRS_POC.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY2.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY3.MIPR_ID
<!---AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY2.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY2A.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY3.MIPR_ID--->
AND (BUDGET_MIPRS_SENT.MIPR_NU
MBER <>Â 'MIPR0' and BUDGET_MIPRS_SENT.MIPR_NUM
BER = 'pending' and BUDGET_MIPRS_SENT.MIPR_NUM
BER <>Â 'hold')
AND BUDGET_MIPRS_SENT.CANCELLE
D is null
and BUDGET_MIPRS_SENT.APPROVAL
_DATE IS NOT NULL
and SUBQUERY1.COMMITED <>Â 0
OR
 BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY1.MIPR_ID
 AND BUDGET_MIPRS_SENT.MIPR_ID = BUDGET_MIPRS_POC.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY2.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY3.MIPR_ID
<!---AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY2.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY2A.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY3.MIPR_ID--->
AND (BUDGET_MIPRS_SENT.MIPR_NU
MBER <>Â 'MIPR0' and BUDGET_MIPRS_SENT.MIPR_NUM
BER <>Â 'pending' and BUDGET_MIPRS_SENT.MIPR_NUM
BER <>Â 'hold')
AND BUDGET_MIPRS_SENT.CANCELLE
D is null
AND BUDGET_MIPRS_SENT.INC_DEC IS NOT NULL
AND SUBQUERY3.INCDATE IS NOT NULL
and SUBQUERY1.COMMITED <>Â 0
OR
 BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY1.MIPR_ID
 AND BUDGET_MIPRS_SENT.MIPR_ID = BUDGET_MIPRS_POC.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY2.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY3.MIPR_ID
<!---AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY2.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY2A.MIPR_ID
AND BUDGET_MIPRS_SENT.MIPR_ID = SUBQUERY3.MIPR_ID--->
AND (BUDGET_MIPRS_SENT.MIPR_NU
MBER <>Â 'MIPR0' and BUDGET_MIPRS_SENT.MIPR_NUM
BER <>Â 'pending' and BUDGET_MIPRS_SENT.MIPR_NUM
BER <>Â 'hold')
AND BUDGET_MIPRS_SENT.CANCELLE
D is null
AND BUDGET_MIPRS_SENT.PR_OAL = 'Yes'
and SUBQUERY1.COMMITED <>Â 0
ORDER BY BUDGET_MIPRS_SENT.PR_PRIOR
ITY ASC, BUDGET_MIPRS_SENT.PR_DAYS DESC
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "
http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 <title>MCA Pending Actions List</title>
Â
<style type="text/css">
html {
    overflow-y:hidden;
}
div#headerwrap {
   position: absolute;
   width:100%;
   top:0;
   left:0 auto;
   height:90px;
}
/* position:fixed for modern browsers - header and footer do not scroll */
body>div#headerwrap {
   position:fixed;
}
div#header {
   height:25px;
   width:1675px;
       top:-25px;  Â
}
div#headerwrap2 {
   position: absolute;
   width:1675px;
   top:0px;
   left:-3px;
       background-color:#FFFF00;
}
/* position:fixed for modern browsers - header and footer do not scroll */
body>div#headerwrap2 {
   position:fixed;
}
div#headerwrap3 {
   position: absolute;
   width:1675px;
   top:0px;
   left:-3px;
       background-color:#FFFF00;
}
/* position:fixed for modern browsers - header and footer do not scroll */
body>div#headerwrap3 {
   position:fixed;
}
div#headerwrap1 {
   position: absolute;
   width:100%;
   top:25px;
   left:-3px;
   height:70px;
}
/* position:fixed for modern browsers - header and footer do not scroll */
body>div#headerwrap1 {
   position:fixed;
}
p {
  margin:0 0 1em;
      border:medium;
}
table p {
  margin :0
}
.wrap {
  margin:91px 0 0 0%;
  float:left;
  position:relative;
  overflow:hidden;
  padding:22px 0 0;
  background:#FFFFE8;
 Â
  width:1700px;
      left:2px;
     Â
}
.inner2 {
  float:left;
  width:100%;
  height:675px;
  position:relative;
  padding:30px 0 17px;
  overflow-y:hidden;
  overflow-x:hidden;
  background:#FFFFE8;
}
.inner {
  width:1700px;
  float:left;
  height:625px;
  overflow-y:auto;
  overflow-x:hidden
}
table {
  width:1700px;
  margin:0 0 0 -1px;
  float:left;
      background-color:#FFFFE8;
}
td {
  padding:5px;
 Â
      border-bottom:1px solid #036;
  text-align:center;
  background:#FFFFE8;
}
td1 {
  padding:5px;
  text-align:center;
  background:#FFFFE8;
      height:70px;
}
td2 {
  padding:5px;
  text-align:center;
  background:#FFFF00;
      height:70px;
}
tfoot th, thead th {
  font-weight:bold;
  text-align:left;
 Â
  padding:0 3px 0 5px;
  background:#FFFFE8;
}
thead th {
      text-align:center;
}
thead tr p {
  position:absolute;
      top:0px;
 Â
}
div#footer h2 {
   text-align:left;
   padding:0;
   margin:0;
      Â
}
div #footer p {
   margin:0;
   padding:0;
   text-align:left;
       vertical-align:middle;
      Â
}
div#footer a {
   color:#fff;
       vertical-align:middle;
      Â
}
div#footerwrap {
   width:1675px;
   position:absolute;
   bottom:0;
   left:0;
   height:35px;
       background:#000;
      Â
}
body>div#footerwrap {
   position:fixed;
}
div#footer {
   height:35px;
   width:100%;
   margin:0 auto;
       position:fixed
      Â
}
.last {
  padding-right:15px!importa
nt;
}
</style>
</head>
<body bgcolor="#FFFFE8">
<div id="headerwrap2" align="left">
<div id="header"><td2><font size="2" face="Arial, Helvetica, sans-serif" color="#000000"><strong>&n
bsp;
You are logged in as: <cfoutput>#FDEDLeads.FIRST
NAME# Â #FDEDLeads.LASTNAME#</cfou
tput></str
ong></font
></td2>
<td2><font size="2" face="Arial, Helvetica, sans-serif" color="#000000"><strong>
&n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p &nb
sp; &
nbsp; 
; &nb
sp; &
nbsp; 
; &nb
sp; &
nbsp; 
; &nb
sp; &
nbsp; 
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
&nbs
p; &n
bsp;
***** UNCLASSIFIED *****</strong></font></td2
>
</div>
<div id="header">
<td><img src="Images/MCA_OBI.gif" width="1675" height="60" alt=""/></td>
</div></div>
       Â
<CFIF #FDEDLeads.EXPERTAREA# NEQ 'DBA' AND #FDEDLeads.EXPERTAREA# NEQ 'SA'>
<cfform id="Form_RequestAccess" method="post">
<div class="wrap">
  <div class="inner2">
    <div class="inner">
      <table id="data" cellspacing="0" cellpadding="10">
        <thead>
       Â
        <TR><TH><font color="#FF0000" size="5" face="Arial, Helvetica, sans-serif"><strong>You do not have permissions to view this page.</strong></font></TH>
</TR></the
ad></table
></div></d
iv></div>
        </cfform>
       Â
        <CFELSE>
<cfform id="Form_RequestAccess" method="post">
<div class="wrap">
  <div class="inner2">
    <div class="inner">
      <table id="data" cellspacing="0" cellpadding="10">
        <thead>
       Â
       Â
                      <CFIF #CecomInput.RECORDCOUNT# EQ 0>
        <tr>
        <th>
         <font color="#FF0000" size="5" face="Arial, Helvetica, sans-serif"><strong>There are no Open Budget Issues at this time.</strong></font></th>
</tr>
        <cfelse>
       Â
       Â
       Â
       Â
       Â
          <tr>
            <th width="55" height="30"><img src="Images/PR_1.gif" width="56" height="9" alt=""/>
            </th>
            <th width="50"  height="30"><img src="Images/PR_2.gif" width="14" height="9" alt=""/>
            </th>
            <th width="46"  height="30"><img src="Images/PR_3.gif" width="117" height="9" alt=""/>
            </th>
            <th width="25"  height="30"><img src="Images/PR_4.gif" width="69" height="9" alt=""/>
            </th>
            <th width="55"  height="30"><img src="Images/PR_5.gif" width="140" height="11" alt=""/>
            </th>
            <th width="25"  height="30"><img src="Images/PR_6A.gif" width="60" height="23" alt=""/>
            </th>
            <th width="25"  height="30"><img src="Images/PR_7A.gif" alt=""/>
            </th>
            <th width="25"  height="30"><img src="Images/PR_7.gif" width="98" height="9" alt=""/>
            </th>
           Â
            <th width="115"  height="30"><img src="Images/PR_8A.gif" width="37" height="23" alt=""/>
            </th>
            <th width="45"  height="30"><img src="Images/PR_9A.gif" width="81" height="23" alt=""/>
            </th>
            <th width="45"  height="30"><img src="Images/PR_10.gif" width="57" height="9" alt=""/>
            </th>
            <th width="45"  height="30"><img src="Images/PR_11A.gif" width="61" height="23" alt=""/>
            </th>
            <th width="40"  height="30"><img src="Images/PR_12A.gif" width="34" height="23" alt=""/>
            </th>
            <th width="45"  height="30"><img src="Images/PR_13.gif" width="145" height="9" alt=""/>
            </th>
            <th width="30"  height="30"><span style='position:absolute;z
-index:6; left:1253px;top:16px;width
:522px;hei
ght:43px'>
            </th>
            <th width="17"  height="30"><span style='position:absolute;z
-index:6; left:1333px;top:5px;width:
522px;heig
ht:43px'>
            </th>
<th width="55" Â height="30"><span style='position:absolute;z
-index:6; left:1440px;top:32px;width
:500px;hei
ght:43px'>
            </th>
           Â
<th width="70" Â height="30"><span style='position:absolute;z
-index:6; left:1580px;top:27px;width
:500px;hei
ght:43px'>
            </th>
            <th width="40"  height="30" class="last"></th>
          </tr></cfif>
         Â
        </thead>
       Â
<cfloop query="CecomInput"> Â
<cfset prilist = #CecomInput.recordCount#> Â Â Â Â Â Â
        <tbody>
          <tr>
         Â
           <td width="40">
          Â
           <!---RecordCount.CecomInpu
t--->
Â
          Â
Â
           <cfselect name="sequence#CurrentRow#
">
           <CFOUTPUT><option value="#CecomInput.PR_PRIO
RITY#">#Ce
comInput.P
R_PRIORITY
#</option>
</CFOUTPUT
>
 <cfloop index="i" from="1" to="#prilist#" step="1">>
 <cfoutput>
 <option value="#i#">#i#</option></
cfoutput>
 </cfloop>
 </cfselect></td>
Â
           <td width="65"><CFINPUT TYPE="TEXT"
           NAME="FY#CurrentRow#"
           VALUE="#CecomInput.FY#"
           SIZE="4"
           MAXLENGTH="35"
           style="font-size:11px"></t
d>
 Â
           <td width="85">
           <CFIF #CecomInput.MIPR_NUMBER# EQ 'pending'>
           <CFINPUT TYPE="TEXT"
           NAME="ACTION_RQD#CurrentRo
w#"
           VALUE="NEW"
           SIZE="18"
           MAXLENGTH="20"
           style="font-size:11px">
           <cfelseif #CecomInput.MIPR_NUMBER# nEQ 'pending' and #CecomInput.INC_DEC# EQ 'INCREASE'>
           <CFINPUT TYPE="TEXT"
           NAME="ACTION_RQD#CurrentRo
w#"
           VALUE="INCREASE"
           SIZE="18"
           MAXLENGTH="20"
           style="font-size:11px">
          Â
           <cfelseif #CecomInput.MIPR_NUMBER# nEQ 'pending' and #CecomInput.INC_DEC# EQ 'DECREASE'>
           <CFINPUT TYPE="TEXT"
           NAME="ACTION_RQD#CurrentRo
w#"
           VALUE="DECREASE"
           SIZE="18"
           MAXLENGTH="20"
           style="font-size:11px">
          Â
           <cfelse>
           <cfselect id="select1" name="ACTION_RQD#CurrentRo
w#" size="1" style="font-size:11px">
           <CFOUTPUT><option value="#CecomInput.PR_ACTI
ON#">#Ceco
mInput.PR_
ACTION#</o
ption></CF
OUTPUT>
                            <OPTION value="null"></OPTION>
                            <OPTION value="TROUBLESHOOT">TROUB
LESHOOT</O
PTION>
                            <OPTION value="OBLIGATE">OBLIGATE<
/OPTION>
                            <OPTION value="DEOBLIGATE">DEOBLIG
ATE</OPTIO
N>
                            <OPTION value="ON HOLD">ON HOLD</OPTION></cfselect>
          Â
          Â
          Â
          Â
          Â
          Â
           </CFIF>
           </td>
          Â
           <td width="80"><CFINPUT TYPE="TEXT"
           NAME="JONO#CurrentRow#"
           VALUE="#CecomInput.JONO#"
           SIZE="17"
           MAXLENGTH="35"
           style="font-size:11px"></t
d> Â
          Â
           <CFIF #CecomInput.MIPR_NUMBER# NEQ 'pending'>
           <td width="80"><CFINPUT TYPE="TEXT"
           NAME="CUSTOMER_WBS#Current
Row#"
           VALUE="#CecomInput.MIPR_NU
MBER#"
           SIZE="25"
           MAXLENGTH="45"
           style="font-size:11px"></t
d>
          Â
           <CFELSE>
          Â
           <td width="80"><CFINPUT TYPE="TEXT"
           NAME="CUSTOMER_WBS#Current
Row#"
           VALUE="#CecomInput.CUSTOME
R_WBS#"
           SIZE="25"
           MAXLENGTH="45"
           style="font-size:11px"></t
d></CFIF>
          Â
           <CFIF #CecomInput.PR_OAL# EQ 'Yes'>
           <td width="100"><CFINPUT TYPE="TEXT"
           NAME="COMMITED#CurrentRow#
"
           VALUE="#LSNumberFormat(Cec
omInput.PR
_AMOUNT,'9
,999.99')#
"
           SIZE="12"
           MAXLENGTH="20"
           style="font-size:11px; text-align:right"></td>
                           Â
                            <cfELSEif #CecomInput.INC_DEC# EQ "">
           <td width="100"><CFINPUT TYPE="TEXT"
           NAME="COMMITED#CurrentRow#
"
           VALUE="#LSNumberFormat(Cec
omInput.CO
MMITED,'9,
999.99')#"
           SIZE="12"
           MAXLENGTH="20"
           style="font-size:11px; text-align:right"></td>
           <CFELSE>         Â
           <td width="100"><CFINPUT TYPE="TEXT"
           NAME="COMMITED#CurrentRow#
"
           VALUE="#LSNumberFormat(Cec
omInput.di
ff,'9,999.
99')#"
           SIZE="12"
           MAXLENGTH="20"
           style="font-size:11px; text-align:right"></td>
           </cfif>
          Â
          Â
           <td width="100"><CFINPUT TYPE="TEXT"
           NAME="MIPR_TO#CurrentRow#"
           VALUE="#CecomInput.MIPR_TO
#"
           SIZE="20"
           MAXLENGTH="20"
           style="font-size:11px"></t
d>
          Â
          Â
           <td width="80"><cfoutput><text
area rows="4" Â cols="18" name="CUSTOMER_ORG#Current
Row#" id="CUSTOMER_ORG" style="font-size:11px">#Ce
comInput.C
USTOMER_OR
G#</textar
ea></cfout
put></td>
          Â
           <td width="100"><cfoutput><tex
tarea rows="4" Â cols="8" name="STATE#CurrentRow#" id="STATE" style="font-size:11px">#Ce
comInput.S
TATE#</tex
tarea></cf
output></t
d>
          Â
          Â
           <td width="75"><CFINPUT TYPE="TEXT"
           NAME="ISEC_POC#CurrentRow#
"
           VALUE="#CecomInput.ISEC_PO
C#"
           SIZE="15"
           MAXLENGTH="20"
           style="font-size:11px"></t
d>
          Â
           <td width="115"><cfoutput><tex
tarea rows="4" Â cols="20" name="PURPOSE#CurrentRow#"
id="PURPOSE" style="font-size:11px">#Ce
comInput.P
URPOSE#</t
extarea></
cfoutput><
/td>
          Â
           <cfif #CecomInput.INC_DEC# EQ 'DECREASE' OR #CecomInput.INC_DEC# EQ 'INCREASE'>
           <td width="50">
           <CFINPUT TYPE="TEXT"
           NAME="APPROVAL_DATE#Curren
tRow#"
           VALUE="#CecomInput.INCDATE
#"
           SIZE="8"
           MAXLENGTH="15"
           style="font-size:11px"
           VALIDATE="date" >
          Â
           <cfset numberofdays="0">
           <cfscript>
           /**Calculates the number of business days between 2 dates.*/
           while (#CecomInput.INCDATE# LTE now()) {
           if(dayOfWeek(#CecomInput.I
NCDATE#)
                            GTE 2 AND dayOfWeek(#CecomInput.INCD
ATE#) LTE 6) numberOfDays = Â Â Â Â Â Â Â Â Â Â incrementValue(numberOfDay
s);
           #CecomInput.INCDATE# = dateAdd("d",1,#CecomInput.
INCDATE#);
           }
           </cfscript>
           <td width="60"><CFINPUT TYPE="TEXT"
           NAME="days#CurrentRow#"
           VALUE="#numberOfDays#"
           SIZE="5"
           MAXLENGTH="15"
           style="font-size:11px"></t
d>
          Â
           <CFELSEIF #CecomInput.PR_OAL# EQ 'Yes'>
           <td width="50">
           <CFINPUT TYPE="TEXT"
           NAME="APPROVAL_DATE#Curren
tRow#"
           VALUE="#CecomInput.PR_DATE
#"
           SIZE="8"
           MAXLENGTH="15"
           style="font-size:11px"
           VALIDATE="date" >
          Â
           <cfset numberofdays="0">
           <cfscript>
           /**Calculates the number of business days between 2 dates.*/
           while (#CecomInput.PR_DATE# LTE now()) {
           if(dayOfWeek(#CecomInput.P
R_DATE#)
                            GTE 2 AND dayOfWeek(#CecomInput.PR_D
ATE#) LTE 6) numberOfDays = Â Â Â Â Â Â Â Â Â Â incrementValue(numberOfDay
s);
           #CecomInput.PR_DATE# = dateAdd("d",1,#CecomInput.
PR_DATE#);
           }
           </cfscript>
           <td width="60"><CFINPUT TYPE="TEXT"
           NAME="days#CurrentRow#"
           VALUE="#numberOfDays#"
           SIZE="3"
           MAXLENGTH="15"
           style="font-size:11px"></t
d>
           <CFELSE>
          Â
           <td width="50">
           <CFINPUT TYPE="TEXT"
           NAME="APPROVAL_DATE#Curren
tRow#"
           VALUE="#CecomInput.APPROVA
L_DATE#"
           SIZE="8"
           MAXLENGTH="15"
           style="font-size:11px"
           VALIDATE="date" >
          Â
           <cfset numberofdays="0">
           <cfscript>
           /**Calculates the number of business days between 2 dates.*/
           while (#CecomInput.APPROVAL_DATE
# LTE now()) {
           if(dayOfWeek(#CecomInput.A
PPROVAL_DA
TE#)
                            GTE 2 AND dayOfWeek(#CecomInput.APPR
OVAL_DATE#
) LTE 6) numberOfDays = Â Â Â Â Â Â Â Â Â Â incrementValue(numberOfDay
s);
           #CecomInput.APPROVAL_DATE#
= dateAdd("d",1,#CecomInput.
APPROVAL_D
ATE#);
           }
           </cfscript>
           <td width="50"><CFINPUT TYPE="TEXT"
           NAME="days#CurrentRow#"
           VALUE="#numberOfDays#"
           SIZE="5"
           MAXLENGTH="15"
           style="font-size:11px"></t
d></cfif>
          Â
           <!---<cfset days = dateDiff("d", #CecomInput.APPROVAL_DATE#
, now()) />--->
          Â
Â
           <td width="60"><cfoutput><text
area rows="4" Â cols="20" name="PR_COMMENTS#CurrentR
ow#" id="PR_COMMENTS" style="font-size:11px">#Ce
comInput.P
R_COMMENTS
#</textare
a></cfoutp
ut></td>
          Â
          Â
           <CFIF #CecomInput.PR_OAL# EQ 'Yes'>
           <td width="5">
          Â
          Â
           <cfselect id="select1" name="Closed#CurrentRow#" size="1" style="font-size:11px">
                            <OPTION value="null"></OPTION>
                            <OPTION value="Close">Close</OPTIO
N>
                            </cfselect>
           <!---<input type="checkbox" name="Closed">--->
           </td>
          Â
           <cfelse>
           <td width="5">
          Â
          Â
           <cfselect id="select1" name="Closed#CurrentRow#" size="1" style="font-size:11px; display:none">
                            <OPTION value="null"></OPTION>
                            <OPTION value="Close">Close</OPTIO
N>
                            </cfselect>
           <!---<input type="checkbox" name="Closed">--->
           </td></CFIF>
          Â
          Â
            <td><CFINPUT TYPE="hidden"
           NAME="MIPR_ID#CurrentRow#"
           VALUE="#CecomInput.MIPR_ID
#"
           SIZE="7"
           MAXLENGTH="15"
           style="font-size:11px">
          Â
           <CFINPUT TYPE="hidden"
           NAME="ID#CurrentRow#"
           VALUE="#CecomInput.PR_ID#"
           SIZE="7"
           MAXLENGTH="15"
           style="font-size:11px">
           </td>
            <td class="last"></td>
          </tr>
         Â
Â
          </tr>
        </tbody>
        </cfloop>
       Â
        <cfoutput><input type="hidden" name="numRecords" value="#CecomInput.recordC
ount#"></c
foutput>
       Â
      </table>
    </div>
  </div>
</div>
<div id="footerwrap">
   <div id="footer">
     Â
<div id="labfooter">
   <p>  
;<input name="submit" type="submit" value="  Update  " onclick="javascript: form.action='OpenActionsUp
date1.cfm'
;"/> | <input name="export" type="submit" value="  Export  " onclick="javascript: form.action='OpenActionsUp
date2.cfm'
;"/> | <input name="export" type="submit" value="  Export and Email  " onclick="javascript: form.action='OpenActionsUp
date3.cfm'
;"/> | <input name="reset" type="reset" value="Discard Changes"> | <input type="button" value="Back" onClick="history.go(-1);re
turn true;" alt="Return to the previous page" border="0"> &nb
sp; &
nbsp; 
; &nb
sp; &
nbsp; 
; &nb
sp; &
nbsp; 
; &nb
sp; &
nbsp; 
; &nb
sp; &
nbsp; 
; &nb
sp; &
nbsp; 
; &nb
sp; &
nbsp; 
; &nb
sp;<a href="/mcadev/PendingRepor
tPortal.cf
m"><font face="Trebuchet MS, Arial, Helvetica, sans-serif" size="-1" color="#FFFFFF">Refresh</f
ont></a> <font face="Trebuchet MS, Arial, Helvetica, sans-serif" size="-1" color="#FFFFFF">|</font> <a href="/mcadev/PendingRepor
tPortal.cf
m"><font face="Trebuchet MS, Arial, Helvetica, sans-serif" size="-1" color="#FFFFFF">Home</font
></a> <font face="Trebuchet MS, Arial, Helvetica, sans-serif" size="-1" color="#FFFFFF">|</font> <a href="/mcadev/SearchFundRe
quest.cfm"
><font face="Trebuchet MS, Arial, Helvetica, sans-serif" size="-1" color="#FFFFFF">Search by Funding Document</font></a>
   </p>
</div>
   </div>
</div>
</cfform></CFIF>
        Â
</body>
</html>