Hi, I'm really, really new to CF and I acquired some work from a collegue who
relocated... anyhoo, I have a website that collects "percentages" of work
people have performed. We are collecting the data for 6 weeks...hence me
having 6 tables to collect the data. My problem is this. When I load the
information into week one data, I recieve and error on the website via the
Total button. also, my percent totals are not "running" or adding up. Here's
the code:
Thanks for any help in advance. Also, I'm using MX
function tally()
{ var number = 0;
number =
parseInt(document.forms['PercentInput'].Program911.options[document.forms['PercentInput'].Program911.selectedIndex].value)
+
parseInt(document.forms['PercentInput'].ProgramTechSupport.options[document.forms['PercentInput'].ProgramTechSupport.selectedIndex].value)
+
parseInt(document.forms['PercentInput'].Staffing.options[document.forms['PercentInput'].Staffing.selectedIndex].value)
+
parseInt(document.forms['PercentInput'].WorkForceManagement.options[document.forms['PercentInput'].WorkForceManagement.selectedIndex].value)
+
parseInt(document.forms['PercentInput'].SPP.options[document.forms['PercentInput'].SPP.selectedIndex].value)
+
parseInt(document.forms['PercentInput'].CMMI.options[document.forms['PercentInput'].CMMI.selectedIndex].value)
+
parseInt(document.forms['PercentInput'].OtherProcWork.options[document.forms['PercentInput'].OtherProcWork.selectedIndex].value)
+
parseInt(document.forms['PercentInput'].ToolsTech.options[document.forms['PercentInput'].ToolsTech.selectedIndex].value)
+
parseInt(document.forms['PercentInput'].GeneralAdmin.options[document.forms['PercentInput'].GeneralAdmin.selectedIndex].value)
+
parseInt(document.forms['PercentInput'].Absences.options[document.forms['PercentInput'].Absences.selectedIndex].value)
+ parseInt('0');
document.PercentInput.TotalPercent.value = number;
return true;
}
function checkInput(){
if(document.PercentInput.TotalPercent.value != "100"){
alert("Unable to submit without Total equaling 100 \n Please
change appropriate values");
return false;
}
}
</SCRIPT>
</HEAD>
<BODY onLoad=tally();>
<CFIF FORM.WeekendDate eq "10/01/06">
<CFSTOREDPROC
procedure = "GetInput092406"
dataSource = "insitesql"
username = "time"
password = "time">
<cfprocparam type = "IN" CFSQLType = "CF_SQL_VARCHAR" value = "#CGI.AUTH_USER#">
<cfprocresult name = Input>
</CFSTOREDPROC>
<CFELSEIF FORM.WeekendDate eq "10/08/06">
<CFSTOREDPROC
procedure = "GetInput100106"
dataSource = "insitesql"
username = "time"
password = "time">
<cfprocparam type = "IN" CFSQLType = "CF_SQL_VARCHAR" value = "#CGI.AUTH_USER#">
<cfprocresult name = Input>
</CFSTOREDPROC>
<CFELSEIF FORM.WeekendDate eq "10/15/06">
<CFSTOREDPROC
procedure = "GetInput100806"
dataSource = "insitesql"
username = "time"
password = "time">
<cfprocparam type = "IN" CFSQLType = "CF_SQL_VARCHAR" value = "#CGI.AUTH_USER#">
<cfprocresult name = Input>
</CFSTOREDPROC>
<CFELSEIF FORM.WeekendDate eq "10/22/06">
<CFSTOREDPROC
procedure = "GetInput101506"
dataSource = "insitesql"
username = "time"
password = "time">
<cfprocparam type = "IN" CFSQLType = "CF_SQL_VARCHAR" value = "#CGI.AUTH_USER#">
<cfprocresult name = Input>
</CFSTOREDPROC>
<CFELSEIF FORM.WeekendDate eq "10/29/06">
<CFSTOREDPROC
procedure = "GetInput102206"
dataSource = "insitesql"
username = "time"
password = "time">
<cfprocparam type = "IN" CFSQLType = "CF_SQL_VARCHAR" value = "#CGI.AUTH_USER#">
<cfprocresult name = Input>
</CFSTOREDPROC>
<CFELSEIF FORM.WeekendDate eq "11/05/06">
<CFSTOREDPROC
procedure = "GetInput102906"
dataSource = "insitesql"
username = "time"
password = "time">
<cfprocparam type = "IN" CFSQLType = "CF_SQL_VARCHAR" value = "#CGI.AUTH_USER#">
<cfprocresult name = Input>
</CFSTOREDPROC>
</CFIF>
<H1>Time Allocation Survey - Engineering Indirect Employees</H1><BR>
<H3>Do not take more than 10 minutes to complete - <SPAN CLASS="Emphasis">Keep
it simple</SPAN></H3>
<CFQUERY DATASOURCE="insitesql" USERNAME="time" PASSWORD="time" NAME="FullName">
SELECT LastName, FirstName FROM Indirect092406
WHERE Login = '#CGI.AUTH_USER#'
</CFQUERY>
<CFOUTPUT QUERY="FullName">Welcome #FirstName# #LastName# <BR><BR></CFOUTPUT>
Week Ending: <CFOUTPUT QUERY="Input">#FORM.WeekendDate#
<FORM METHOD="POST" ACTION="updateAllocation.cfm" NAME="PercentInput"
ID="PercentInputForm" onSubmit="return checkInput();">
<TABLE width="66%">
<TR>
<TH COLSPAN="2">Task Category</TH>
<TH>%Worked</TH>
</TR>
<TR>
<TD colspan="3" class="Task">Program Support
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A
HREF="##Program911(Reactive)Desc">Program 911(Reactive)</A></TD>
<TD width="3%">
<select name="Program911" onChange="tally();">
<option value="#Program911#">#Program911#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A
HREF="##ProgramTechSupportDesc">Program Technical Support(Proactive)</A></TD>
<TD width="3%">
<select name="ProgramTechSupport" onChange="tally();">
<option
value="#ProgramTechSupport#">#ProgramTechSupport#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
</TD>
</TR>
<TR>
<TD colspan="3" class="Task">Workforce Management
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A
HREF="##StaffingDesc">Staffing</A></TD>
<TD width="3%">
<select name="Staffing" onChange="tally();">
<option value="#Staffing#">#Staffing#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A HREF="##WFMDesc">Workforce
Management/<br>General Supervision Activities</A></TD>
<TD width="3%">
<select name="WorkForceManagement" onChange="tally();">
<option
value="#WorkForceManagement#">#WorkForceManagement#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
</TD>
</TR>
<TR>
<TD colspan="2" class="Task">Processes
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A HREF="##SPPDesc">SPP</A></TD>
<TD width="3%">
<select name="SPP" onChange="tally();">
<option value="#SPP#">#SPP#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A HREF="##CMMIDesc">CMMI</A></TD>
<TD width="3%">
<select name="CMMI" onChange="tally();">
<option value="#CMMI#">#CMMI#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
</TD>
</TR>
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A HREF="##OtherProcWorkDesc">Other
Process Work</A></TD>
<TD width="3%">
<select name="OtherProcWork" onChange="tally();">
<option value="#OtherProcWork#">#OtherProcWork#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
</TD>
</TR>
<TR>
<TD colspan="3" class="Task">Other Activities
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A
HREF="##ToolsTechDesc">Tools/Technology</A></TD>
<TD width="3%">
<select name="ToolsTech" onChange="tally();">
<option value="#ToolsTech#">#ToolsTech#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A HREF="##GeneralAdminDesc">General
Administrative Activities/Other</A></TD>
<TD width="3%">
<select name="GeneralAdmin" onChange="tally();">
<option value="#GeneralAdmin#">#GeneralAdmin#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
<TR>
<TD width="15%"><!--- Leave Blank ---></TD>
<TD width="79%"><A
HREF="##AbsencesDesc">Absences</A></TD>
<TD width="3%">
<select name="Absences" onChange="tally();">
<option value="#Absences#">#Absences#%
<option value="0">0%<option value="5">5%<option
value="10">10%<option value="15">15%
<option value="20">20%<option value="25">25%<option
value="30">30%<option value="35">35%
<option value="40">40%<option value="45">45%<option
value="50">50%<option value="55">55%
<option value="60">60%<option value="65">65%<option
value="70">70%<option value="75">75%
<option value="80">80%<option value="85">85%<option
value="90">90%<option value="95">95%
<option value="100">100%
</select>
</TD>
</TR>
</TD>
</TR>
<TR>
<TD colspan="2" class="Task">Total</TD>
<TD><input type="text" size="7" maxlength="3" value="0"
name="TotalPercent" readonly></TD>
</TR>
<TR>
<TD colspan="2"></TD>
<TD><INPUT TYPE="SUBMIT" NAME="Submit"
VALUE="Submit"></INPUT></TD>
</TR>
</TABLE>
<INPUT TYPE="HIDDEN" NAME="WeekendDate" VALUE="#FORM.WeekendDate#">
</FORM>
</CFOUTPUT>
If you are having problems viewing this page please go here <a
href="alternate.html">ALTERNATE ENTRY METHOD</a>
<HR WIDTH="75%">
<H2><U>Task Category Definitions</U></H2><BR>
<H3><U>Program Support</U></H3>
<UL>
<LI><A NAME="Program911(Reactive)Desc">Program 911 (Reactive)</A> -
Program/Engineering management requested support to programs. Special action
required.</LI>
<LI><A NAME="ProgramSupportDesc">Program Technical Support</A> - Routine
program support including technical guidance, CTC activities, INARS, IPARS, etc
...</LI>
</UL>
<BR>
<H3><U>Workforce Management</U></H3>
<UL>
<LI><A NAME="StaffingDesc">Staffing</A> - All activities relating to
staffing/de-staffing programs/functions.</LI>
<LI><A NAME="WFMDesc">Workforce Management/General Supervision Activities</A>
- Career planning, mentoring, staff/town hall meetings, Role-base tool,
training,
performance assessments, setting objectives, rankings, managing budgets,
employee
tasking, etc.</LI>
</UL>
<BR>
<H3><U>Processes</U></H3>
<UL>
<LI><A NAME="SPPDesc">SPP</A> - Activities related to development and
implementation of Domain Standard Planning Package (does not include activities
specifically required to support CMMI evaluation).</LI>
<LI><A NAME="CMMIDesc">CMMI</A> - Activities related to obtaining Level 3
evaluation (support of Gap Events, CAM activities, PCA resolution, OSP
authoring and development, SCAMPI, etc.).</LI>
<LI><A NAME="OtherProcWorkDesc">Other Process Work</A></LI>
</UL>
<BR>
<H3><U>Other Activities</U></H3>
<UL>
<LI><A NAME="ToolsTechDesc">Tools/Technology</A> - Work associated with
engineering objectives or specific core objectives relating to tools or
technology.</LI>
<LI><A NAME="GeneralAdminDesc">General Administrative Activities/Other -
Administrative activities or any other work assignments that don't fall under
categories above. </A></LI>
<LI><A NAME="AbsencesDesc">Absences - All absences (vacation, personal
illness, bereavement, etc...)</A></LI>
</UL>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2083
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
