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>