|
| |
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
 |
Checkboxes and Values - 4/16/2008 12:22:06
I have a line of code:
<td><input type="checkbox" id="chkPTO<%=i%>" name="chkPTO<%=i%>" <%if rs("PTO") = -1 then%> checked <%end if%> value="-1" onChange="SaveRecord('[PTO]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtPTOHrs<%=i%>, chkPTO<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
The problem I am having is when it is checked, it passes a -1...thats good. However, when i uncheck it, it passes a -1 again. How do I make it pass a 0 when it is unchecked? Or, just pass nothing?
|
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Checkboxes and Values - 4/17/2008 14:08:36
When I take out the value of -1, then it returns the value ON even when it is unchecked. Any ideas? I would rally rather have a checkbox then a yes / no drop down.
| |
|
|
|
rdouglass
Posts: 9228
From: Biddeford, ME USA
Status: offline
|
RE: Checkboxes and Values - 4/18/2008 1:55:37
You should be able to do this; use the checkbox like that. Can you post more code to give us a better understanding of what you're trying to do?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Checkboxes and Values - 4/18/2008 8:45:40
<!-- #include file="dbole.inc" -->
<%
dim rs, ssql
dim i
dim intLineCount
i = 1
set rs = Server.CreateObject ("adodb.Recordset")
ssql = "SELECT COUNT(VacaID) AS LineCount FROM VacationData WHERE (VacaEndDate >= #"&Date()&"#) AND (Approved = -1) AND (FilterOut = 0)"
rs.Open ssql, dbc, adOpenForwardOnly, adLockReadOnly
if not rs.eof then
intLineCount = rs("LineCount")
end if
rs.close
set rs=nothing
set rs = Server.CreateObject ("adodb.Recordset")
ssql = " SELECT VacationData.VacaID, VacationData.VacaStartDate, VacationData.VacaEndDate, VacationData.[Last Name] AS LastName, VacationData.[First Name] AS FirstName, VacationData.VacaEnter, VacationData.ApprovedBy, VacationData.Vacation, VacationData.PTO, VacationData.PTOHrs, VacationData.InternalNotes, VacationData.Approved, VacationData.FilterOut"
ssql = ssql & " FROM VacationData"
ssql = ssql & " WHERE (VacationData.VacaEndDate >= #"&Date()&"#) AND (VacationData.Approved = -1) AND (VacationData.FilterOut = 0)"
ssql = ssql & " ORDER BY VacationData.VacaStartDate"
rs.Open ssql, dbc, adOpenForwardOnly, adLockReadOnly
%>
<html>
<head>
<title>Vacation Mgmt Menu Approved</title>
<script type="text/javascript">
<!--
function enterFirstLine(NextField, NextFieldDown)
{
if(window.event && window.event.keyCode == 40) {
NextFieldDown.focus();}
if(window.event && window.event.keyCode == 13) {
NextField.focus();
return false; }
else
return true;
}
function enterLastLine(NextField, NextFieldUp)
{
if(window.event && window.event.keyCode == 38) {
NextFieldUp.focus();}
if(window.event && window.event.keyCode == 13) {
NextField.focus();
return false; }
else
return true;
}
function enterOnlyLine(NextField)
{
if(window.event && window.event.keyCode == 13) {
NextField.focus();
return false; }
else
return true;
}
function ChangeColor(Cell, i)
{
document.getElementById(Cell).style.backgroundColor='cyan';
document.getElementById("tr" + i).style.backgroundColor='red';
}
function ChangeColorBlur(Cell, i)
{
document.getElementById(Cell).style.backgroundColor='';
document.getElementById("tr" + i).style.backgroundColor='';
}
function enter(NextField, NextFieldDown, NextFieldUp)
{
if(window.event && window.event.keyCode == 40) {
NextFieldDown.focus();}
if(window.event && window.event.keyCode == 38) {
NextFieldUp.focus();}
if(window.event && window.event.keyCode == 13) {
NextField.focus();
return false; }
else
return true;
}
function CheckDate(input) {
var reg = /^(\d{1,2})\/(\d{1,2})\/(\d{2}|\d{4})$/;
if (!reg.test(input.value))
alert("Invalid Date Format. Please correct and submit again.")
var m = input.value.match(reg);
if (m) {
var month = m[1];
var day = m[2];
var year = 2000 + parseInt(m[3]);
// Check for valid date
var date = new Date(year,month-1,day);
if (date.getMonth()+1 != month || date.getDate() != day || date.getFullYear() != year)
alert("Invalid Day, Month, or Year range detected. Please correct and submit again.")
return false;
return true;
}
else {
input.select();
return false;
}
}
var xmlHttp;
var intI;
function SaveRecord(strFieldName, VacaID, strValue)
{
var url="VacationMgmtMenu-save.asp?Value=" + strValue + "&FieldName=" + strFieldName + "&VacaID=" + VacaID
alert(url)
xmlHttp=GetXmlHttpObject(stateChangedSaveRecord)
xmlHttp.open("GET", url , true)
xmlHttp.send(null)
}
function stateChangedSaveRecord()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
xmlHttp.responseText
}
}
function GetXmlHttpObject(handler)
{
var objXmlHttp=null
if (navigator.userAgent.indexOf("Opera")>=0)
{
alert("Opera not supported...")
return;
}
if (navigator.userAgent.indexOf("MSIE")>=0)
{
var strName="Msxml2.XMLHTTP"
if (navigator.appVersion.indexOf("MSIE 5.5")>=0)
{
strName="Microsoft.XMLHTTP"
}
try
{
objXmlHttp=new ActiveXObject(strName)
objXmlHttp.onreadystatechange=handler
return objXmlHttp
}
catch(e)
{
alert("Error. Scripting for ActiveX might be disabled")
return
}
}
if (navigator.userAgent.indexOf("Mozilla")>=0)
{
objXmlHttp=new XMLHttpRequest()
objXmlHttp.onload=handler
objXmlHttp.onerror=handler
return objXmlHttp
}
}
-->
</script>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<th><font face="verdana" size="1">VacID</font></th>
<th><font face="verdana" size="1">Vac Start Date</font></th>
<th><font face="verdana" size="1">Vac End Date</font></th>
<th><font face="verdana" size="1">Last Name</font></th>
<th><font face="verdana" size="1">First Name</font></th>
<th><font face="verdana" size="1">Vac Enter Date</font></th>
<th><font face="verdana" size="1">Vacation</font></th>
<th><font face="verdana" size="1">PTO</font></th>
<th><font face="verdana" size="1">PTO Hours</font></th>
<th><font face="verdana" size="1">Approved</font></th>
<th><font face="verdana" size="1">Approved By</font></th>
<th><font face="verdana" size="1">Filter Out</font></th>
<th><font face="verdana" size="1">Internal Notes</font></th>
</tr>
<%
do while not rs.eof
i = i + 1
if i = 2 then
%>
<tr id="tr<%=i%>">
<td><input type="text" id="txtVacaID<%=i%>" name="txtVacaID<%=i%>" value="<%=rs("VacaID")%>" onkeydown="return enterFirstLine(txtVacaStartDate<%=i%>, txtVacaID<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate<%=i%>" name="txtVacaStartDate<%=i%>" value="<%=rs("VacaStartDate")%>" onChange="CheckDate(this), SaveRecord('[VacaStartDate]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtVacaEndDate<%=i%>, txtVacaStartDate<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate<%=i%>" name="txtVacaEndDate<%=i%>" value="<%=rs("VacaEndDate")%>" onChange="CheckDate(this), SaveRecord('[VacaEndDate]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtLastName<%=i%>, txtVacaEndDate<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName<%=i%>" name="txtLastName<%=i%>" value="<%=rs("LastName")%>" onChange="SaveRecord('[Last Name]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtFirstName<%=i%>, txtLastName<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName<%=i%>" name="txtFirstName<%=i%>" value="<%=rs("FirstName")%>" onChange="SaveRecord('[First Name]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtVacaEnter<%=i%>, txtFirstName<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter<%=i%>" name="txtVacaEnter<%=i%>" value="<%=rs("VacaEnter")%>" onChange="CheckDate(this), SaveRecord('[VacaEnter]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtVacaEndDate<%=i%>, txtVacaEnter<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td>
<input type="checkbox" id="chkVacation<%=i%>" name="chkVacation<%=i%>" <% if rs("Vacation") = -1 then%>checked<%end if%> onChange="SaveRecord('[Vacation]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(chkPTO<%=i%>, chkVacation<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off" value="ON"></td>
<td><input type="checkbox" id="chkPTO<%=i%>" name="chkPTO<%=i%>" <%if rs("PTO") = -1 then%> checked <%end if%> value="-1" onChange="SaveRecord('[PTO]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtPTOHrs<%=i%>, chkPTO<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs<%=i%>" name="txtPTOHrs<%=i%>" value="<%=rs("PTOHrs")%>" onChange="SaveRecord('[PTOHrs]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(chkApproved<%=i%>, txtPTOHrs<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved<%=i%>" name="chkApproved<%=i%>" <%if rs("Approved") = -1 then%> checked<%end if%> value="-1" onChange="SaveRecord('[Approved]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtApprovedBy<%=i%>, chkApproved<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy<%=i%>" name="txtApprovedBy<%=i%>" value="<%=rs("ApprovedBy")%>" onChange="SaveRecord('[ApprovedBy]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(chkFilterOut<%=i%>, txtApprovedBy<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut<%=i%>" name="chkFilterOut<%=i%>" <%if rs("FilterOut") = -1 then%> checked<%end if%> value="-1" onChange="SaveRecord('[FilterOut]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtInternalNotes<%=i%>, chkFilterOut<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes<%=i%>" name="txtInternalNotes<%=i%>" value="<%=rs("InternalNotes")%>" onChange="SaveRecord('[InternalNotes]', <%=rs("VacaID")%>, this.value)" onkeydown="return enterFirstLine(txtVacaID<%=i+1%>, txtInternalNotes<%=i+1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<%
else
if i > 2 and i < intLineCount+1 then
%>
<tr id="tr<%=i%>">
<td><input type="text" id="txtVacaID<%=i%>" name="txtVacaID<%=i%>" value="<%=rs("VacaID")%>" onkeydown="return enter(txtVacaStartDate<%=i%>, txtVacaID<%=i+1%>, txtVacaID<%=i-1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate<%=i%>" name="txtVacaStartDate<%=i%>" value="<%=rs("VacaStartDate")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate<%=i%>" name="txtVacaEndDate<%=i%>" value="<%=rs("VacaEndDate")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName<%=i%>" name="txtLastName<%=i%>" value="<%=rs("LastName")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName<%=i%>" name="txtFirstName<%=i%>" value="<%=rs("FirstName")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter<%=i%>" name="txtVacaEnter<%=i%>" value="<%=rs("VacaEnter")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation<%=i%>" name="chkVacation<%=i%>" <% if rs("Vacation") = -1 then%>checked<%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO<%=i%>" name="chkPTO<%=i%>" <%if rs("PTO") = -1 then%> checked <%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs<%=i%>" name="txtPTOHrs<%=i%>" value="<%=rs("PTOHrs")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved<%=i%>" name="chkApproved<%=i%>" <%if rs("Approved") = -1 then%> checked<%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy<%=i%>" name="txtApprovedBy<%=i%>" value="<%=rs("ApprovedBy")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut<%=i%>" name="chkFilterOut<%=i%>" <%if rs("FilterOut") = -1 then%> checked<%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes<%=i%>" name="txtInternalNotes<%=i%>" value="<%=rs("InternalNotes")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<%
else
if cInt(intLineCount)+1 = i then
%>
<tr id="tr<%=i%>">
<td><input type="text" id="txtVacaID<%=i%>" name="txtVacaID<%=i%>" value="<%=rs("VacaID")%>" onkeydown="return enterLastLine(txtVacaStartDate<%=i%>, txtVacaID<%=i-1%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate<%=i%>" name="txtVacaStartDate<%=i%>" value="<%=rs("VacaStartDate")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate<%=i%>" name="txtVacaEndDate<%=i%>" value="<%=rs("VacaEndDate")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName<%=i%>" name="txtLastName<%=i%>" value="<%=rs("LastName")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName<%=i%>" name="txtFirstName<%=i%>" value="<%=rs("FirstName")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter<%=i%>" name="txtVacaEnter<%=i%>" value="<%=rs("VacaEnter")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation<%=i%>" name="chkVacation<%=i%>" <% if rs("Vacation") = -1 then%>checked<%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO<%=i%>" name="chkPTO<%=i%>" <%if rs("PTO") = -1 then%> checked <%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs<%=i%>" name="txtPTOHrs<%=i%>" value="<%=rs("PTOHrs")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved<%=i%>" name="chkApproved<%=i%>" <%if rs("Approved") = -1 then%> checked<%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy<%=i%>" name="txtApprovedBy<%=i%>" value="<%=rs("ApprovedBy")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut<%=i%>" name="chkFilterOut<%=i%>" <%if rs("FilterOut") = -1 then%> checked<%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes<%=i%>" name="txtInternalNotes<%=i%>" value="<%=rs("InternalNotes")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<%
else
if intLineCount = 1 then
%>
<tr id="tr<%=i%>">
<td><input type="text" id="txtVacaID<%=i%>" name="txtVacaID<%=i%>" value="<%=rs("VacaID")%>" onkeydown="return enterOnlyLine(txtVacaStartDate<%=i%>)" onFocus="ChangeColor(this.id, <%=i%>)" onBlur="ChangeColorBlur(this.id, <%=i%>)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate<%=i%>" name="txtVacaStartDate<%=i%>" value="<%=rs("VacaStartDate")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate<%=i%>" name="txtVacaEndDate<%=i%>" value="<%=rs("VacaEndDate")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName<%=i%>" name="txtLastName<%=i%>" value="<%=rs("LastName")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName<%=i%>" name="txtFirstName<%=i%>" value="<%=rs("FirstName")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter<%=i%>" name="txtVacaEnter<%=i%>" value="<%=rs("VacaEnter")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation<%=i%>" name="chkVacation<%=i%>" <% if rs("Vacation") = -1 then%>checked<%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO<%=i%>" name="chkPTO<%=i%>" <%if rs("PTO") = -1 then%> checked <%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs<%=i%>" name="txtPTOHrs<%=i%>" value="<%=rs("PTOHrs")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved<%=i%>" name="chkApproved<%=i%>" <%if rs("Approved") = -1 then%> checked<%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy<%=i%>" name="txtApprovedBy<%=i%>" value="<%=rs("ApprovedBy")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut<%=i%>" name="chkFilterOut<%=i%>" <%if rs("FilterOut") = -1 then%> checked<%end if%> value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes<%=i%>" name="txtInternalNotes<%=i%>" value="<%=rs("InternalNotes")%>" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<%
end if
end if
end if
end if
rs.moveNext
Loop
rs.close
set rs=nothing
dbc.close
set dbc=nothing
%>
</table>
</body>
</html>
The first section of the table rows on the if then statement is the only one I am working on at the moment, then I will do the rest of the if then statements. It is basically an ajax paget that saves the data on change. However, for the checkbox, for my alert(url), it always shows either -1 (or ON if I put no value on the checkbox).
thanks
| |
|
|
|
rdouglass
Posts: 9228
From: Biddeford, ME USA
Status: offline
|
RE: Checkboxes and Values - 4/18/2008 9:09:35
Have you checked a loaded page (view source) to see if there are duplicate checkbox names?
I haven't looked at it too deeply but with all those 'i's in there, you could be duplicating a box.
Also, is there a chance you have a URL where we can look? I am specifically looking for what is actually written to the browser with this:
onChange="SaveRecord('[PTOHrs]', <%=rs("VacaID")%>, this.value)"
so I guess I'm asking what the rendered page looks like.
Further, in this statement:
"However, for the checkbox, for my alert(url), it always shows either -1 (or ON if I put no value on the checkbox)"
what exactly is 'it'? Is it the section here:
function SaveRecord(strFieldName, VacaID, strValue)
{
var url="VacationMgmtMenu-save.asp?Value=" + strValue + "&FieldName=" + strFieldName + "&VacaID=" + VacaID
alert(url)
xmlHttp=GetXmlHttpObject(stateChangedSaveRecord)
xmlHttp.open("GET", url , true)
xmlHttp.send(null)
}
where your posting via AJAX? How are you determining the value it's picking up / where exactly do you see it?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Checkboxes and Values - 4/18/2008 11:51:52
I can't post the page because it is password protected...but I'll look if I can find a web to post it on that isn't password protected (the whole site is)
I am not even getting to the ajax page at this point...well, it gets there, but it is sending the wrong information there.
When i say "it", i mean the alert(url) I have placed on the javascript function.
The ajax page that does the save is this:
<!-- #include file="dbole.inc" -->
<%
dim rs, ssql
dim strFieldName, strValue
dim intVacaID
strFieldName = request.querystring("FieldName")
strValue = request.querystring("Value")
intVacaID = request.querystring("VacaID")
ssql = "UPDATE VacationData SET "&strFieldName&" = '"&strValue&"' WHERE (VacaID = "&intVacaID&")"
response.write(ssql)
dbc.execute(ssql)
%>
The saves work on everything else on that page, and, technically work on the checkboxes also; however, a -1 (or on) is always sent so I cant' uncheck them and save the data. I know this by the alert I have posted on the OnChange event.
| |
|
|
|
rdouglass
Posts: 9228
From: Biddeford, ME USA
Status: offline
|
RE: Checkboxes and Values - 4/18/2008 12:11:45
Oh!!! (light bulb gets a little brighter)
I think with JS, a -1 is Null so you are getting the stuff (I think anyways). Or is it really supposed to be -1
Without seeing the page code its togh to say tho. What would be the chance of you PM'ing me a fully rendered page with all the stuff in it? (Not the ASP page but once it's sent to the browser?)
If not, can you at least post this full alert message that comes from this:
var url="VacationMgmtMenu-save.asp?Value=" + strValue + "&FieldName=" + strFieldName + "&VacaID=" + VacaID
alert(url)
Are you picking up *any* of those values?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Checkboxes and Values - 4/18/2008 15:08:29
quote:
VacationMgmtMenu-save.asp?Value=-1&FieldName=[Vacation]&VacaID=4149
That is the pop-up regardless if it is checked or not.
Somethign wierd here. If you have the PTO box highlihgted on the first row (the only real row with code on it for the onchange event), then refresh the page without changing the data, then tab away, the OnChange event fires off. I do not know why, but it leaves it as checked.
Here is the view source:
<html>
<head>
<title>Vacation Mgmt Menu Approved</title>
<script type="text/javascript">
<!--
function enterFirstLine(NextField, NextFieldDown)
{
if(window.event && window.event.keyCode == 40) {
NextFieldDown.focus();}
if(window.event && window.event.keyCode == 13) {
NextField.focus();
return false; }
else
return true;
}
function enterLastLine(NextField, NextFieldUp)
{
if(window.event && window.event.keyCode == 38) {
NextFieldUp.focus();}
if(window.event && window.event.keyCode == 13) {
NextField.focus();
return false; }
else
return true;
}
function enterOnlyLine(NextField)
{
if(window.event && window.event.keyCode == 13) {
NextField.focus();
return false; }
else
return true;
}
function ChangeColor(Cell, i)
{
document.getElementById(Cell).style.backgroundColor='cyan';
document.getElementById("tr" + i).style.backgroundColor='red';
}
function ChangeColorBlur(Cell, i)
{
document.getElementById(Cell).style.backgroundColor='';
document.getElementById("tr" + i).style.backgroundColor='';
}
function enter(NextField, NextFieldDown, NextFieldUp)
{
if(window.event && window.event.keyCode == 40) {
NextFieldDown.focus();}
if(window.event && window.event.keyCode == 38) {
NextFieldUp.focus();}
if(window.event && window.event.keyCode == 13) {
NextField.focus();
return false; }
else
return true;
}
function CheckDate(input) {
var reg = /^(\d{1,2})\/(\d{1,2})\/(\d{2}|\d{4})$/;
if (!reg.test(input.value))
alert("Invalid Date Format. Please correct and submit again.")
var m = input.value.match(reg);
if (m) {
var month = m[1];
var day = m[2];
var year = 2000 + parseInt(m[3]);
// Check for valid date
var date = new Date(year,month-1,day);
if (date.getMonth()+1 != month || date.getDate() != day || date.getFullYear() != year)
alert("Invalid Day, Month, or Year range detected. Please correct and submit again.")
return false;
return true;
}
else {
input.select();
return false;
}
}
var xmlHttp;
var intI;
function SaveRecord(strFieldName, VacaID, strValue)
{
var url="VacationMgmtMenu-save.asp?Value=" + strValue + "&FieldName=" + strFieldName + "&VacaID=" + VacaID
alert(url)
xmlHttp=GetXmlHttpObject(stateChangedSaveRecord)
xmlHttp.open("GET", url , true)
xmlHttp.send(null)
}
function stateChangedSaveRecord()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
xmlHttp.responseText
}
}
function GetXmlHttpObject(handler)
{
var objXmlHttp=null
if (navigator.userAgent.indexOf("Opera")>=0)
{
alert("Opera not supported...")
return;
}
if (navigator.userAgent.indexOf("MSIE")>=0)
{
var strName="Msxml2.XMLHTTP"
if (navigator.appVersion.indexOf("MSIE 5.5")>=0)
{
strName="Microsoft.XMLHTTP"
}
try
{
objXmlHttp=new ActiveXObject(strName)
objXmlHttp.onreadystatechange=handler
return objXmlHttp
}
catch(e)
{
alert("Error. Scripting for ActiveX might be disabled")
return
}
}
if (navigator.userAgent.indexOf("Mozilla")>=0)
{
objXmlHttp=new XMLHttpRequest()
objXmlHttp.onload=handler
objXmlHttp.onerror=handler
return objXmlHttp
}
}
-->
</script>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0">
<tr>
<th><font face="verdana" size="1">VacID</font></th>
<th><font face="verdana" size="1">Vac Start Date</font></th>
<th><font face="verdana" size="1">Vac End Date</font></th>
<th><font face="verdana" size="1">Last Name</font></th>
<th><font face="verdana" size="1">First Name</font></th>
<th><font face="verdana" size="1">Vac Enter Date</font></th>
<th><font face="verdana" size="1">Vacation</font></th>
<th><font face="verdana" size="1">PTO</font></th>
<th><font face="verdana" size="1">PTO Hours</font></th>
<th><font face="verdana" size="1">Approved</font></th>
<th><font face="verdana" size="1">Approved By</font></th>
<th><font face="verdana" size="1">Filter Out</font></th>
<th><font face="verdana" size="1">Internal Notes</font></th>
</tr>
<tr id="tr2">
<td><input type="text" id="txtVacaID2" name="txtVacaID2" value="4149" onkeydown="return enterFirstLine(txtVacaStartDate2, txtVacaID3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate2" name="txtVacaStartDate2" value="4/22/2008" onChange="CheckDate(this), SaveRecord('[VacaStartDate]', 4149, this.value)" onkeydown="return enterFirstLine(txtVacaEndDate2, txtVacaStartDate3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate2" name="txtVacaEndDate2" value="4/22/2008" onChange="CheckDate(this), SaveRecord('[VacaEndDate]', 4149, this.value)" onkeydown="return enterFirstLine(txtLastName2, txtVacaEndDate3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName2" name="txtLastName2" value="Prull" onChange="SaveRecord('[Last Name]', 4149, this.value)" onkeydown="return enterFirstLine(txtFirstName2, txtLastName3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName2" name="txtFirstName2" value="Sandy" onChange="SaveRecord('[First Name]', 4149, this.value)" onkeydown="return enterFirstLine(txtVacaEnter2, txtFirstName3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter2" name="txtVacaEnter2" value="4/17/2008" onChange="CheckDate(this), SaveRecord('[VacaEnter]', 4149, this.value)" onkeydown="return enterFirstLine(txtVacaEndDate2, txtVacaEnter3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td>
<input type="checkbox" id="chkVacation2" name="chkVacation2" value="-1" onChange="SaveRecord('[Vacation]', 4149, this.value)" onkeydown="return enterFirstLine(chkPTO2, chkVacation3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off" value="ON"></td>
<td><input type="checkbox" id="chkPTO2" name="chkPTO2" checked value="-1" onChange="SaveRecord('[PTO]', 4149, this.value)" onkeydown="return enterFirstLine(txtPTOHrs2, chkPTO3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs2" name="txtPTOHrs2" value="3" onChange="SaveRecord('[PTOHrs]', 4149, this.value)" onkeydown="return enterFirstLine(chkApproved2, txtPTOHrs3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved2" name="chkApproved2" checked value="-1" onChange="SaveRecord('[Approved]', 4149, this.value)" onkeydown="return enterFirstLine(txtApprovedBy2, chkApproved3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy2" name="txtApprovedBy2" value="JEG" onChange="SaveRecord('[ApprovedBy]', 4149, this.value)" onkeydown="return enterFirstLine(chkFilterOut2, txtApprovedBy3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut2" name="chkFilterOut2" value="-1" onChange="SaveRecord('[FilterOut]', 4149, this.value)" onkeydown="return enterFirstLine(txtInternalNotes2, chkFilterOut3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes2" name="txtInternalNotes2" value="Doctor with Larry" onChange="SaveRecord('[InternalNotes]', 4149, this.value)" onkeydown="return enterFirstLine(txtVacaID3, txtInternalNotes3)" onFocus="ChangeColor(this.id, 2)" onBlur="ChangeColorBlur(this.id, 2)" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr3">
<td><input type="text" id="txtVacaID3" name="txtVacaID3" value="4148" onkeydown="return enter(txtVacaStartDate3, txtVacaID4, txtVacaID2)" onFocus="ChangeColor(this.id, 3)" onBlur="ChangeColorBlur(this.id, 3)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate3" name="txtVacaStartDate3" value="4/22/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate3" name="txtVacaEndDate3" value="4/22/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName3" name="txtLastName3" value="Pfranger" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName3" name="txtFirstName3" value="Lisa" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter3" name="txtVacaEnter3" value="4/17/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation3" name="chkVacation3" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO3" name="chkPTO3" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs3" name="txtPTOHrs3" value="1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved3" name="chkApproved3" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy3" name="txtApprovedBy3" value="JEG" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut3" name="chkFilterOut3" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes3" name="txtInternalNotes3" value="Personal reason" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr4">
<td><input type="text" id="txtVacaID4" name="txtVacaID4" value="4143" onkeydown="return enter(txtVacaStartDate4, txtVacaID5, txtVacaID3)" onFocus="ChangeColor(this.id, 4)" onBlur="ChangeColorBlur(this.id, 4)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate4" name="txtVacaStartDate4" value="4/29/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate4" name="txtVacaEndDate4" value="4/29/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName4" name="txtLastName4" value="Burrows" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName4" name="txtFirstName4" value="Maylene " style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter4" name="txtVacaEnter4" value="4/14/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation4" name="chkVacation4" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO4" name="chkPTO4" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs4" name="txtPTOHrs4" value="1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved4" name="chkApproved4" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy4" name="txtApprovedBy4" value="JEG" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut4" name="chkFilterOut4" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes4" name="txtInternalNotes4" value="Heart Doctor" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr5">
<td><input type="text" id="txtVacaID5" name="txtVacaID5" value="3857" onkeydown="return enter(txtVacaStartDate5, txtVacaID6, txtVacaID4)" onFocus="ChangeColor(this.id, 5)" onBlur="ChangeColorBlur(this.id, 5)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate5" name="txtVacaStartDate5" value="5/22/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate5" name="txtVacaEndDate5" value="5/27/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName5" name="txtLastName5" value="Zirkelbach" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName5" name="txtFirstName5" value="Dave " style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter5" name="txtVacaEnter5" value="11/9/2007" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation5" name="chkVacation5" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO5" name="chkPTO5" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs5" name="txtPTOHrs5" value="0" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved5" name="chkApproved5" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy5" name="txtApprovedBy5" value="Todd" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut5" name="chkFilterOut5" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes5" name="txtInternalNotes5" value="" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr6">
<td><input type="text" id="txtVacaID6" name="txtVacaID6" value="4020" onkeydown="return enter(txtVacaStartDate6, txtVacaID7, txtVacaID5)" onFocus="ChangeColor(this.id, 6)" onBlur="ChangeColorBlur(this.id, 6)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate6" name="txtVacaStartDate6" value="5/27/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate6" name="txtVacaEndDate6" value="5/30/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName6" name="txtLastName6" value="Kjenaas" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName6" name="txtFirstName6" value="Rita" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter6" name="txtVacaEnter6" value="2/13/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation6" name="chkVacation6" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO6" name="chkPTO6" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs6" name="txtPTOHrs6" value="32" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved6" name="chkApproved6" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy6" name="txtApprovedBy6" value="Todd" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut6" name="chkFilterOut6" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes6" name="txtInternalNotes6" value="vacation; houseboat --- ok'd the 5/27 even though Dianne is gone too that day" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr7">
<td><input type="text" id="txtVacaID7" name="txtVacaID7" value="3970" onkeydown="return enter(txtVacaStartDate7, txtVacaID8, txtVacaID6)" onFocus="ChangeColor(this.id, 7)" onBlur="ChangeColorBlur(this.id, 7)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate7" name="txtVacaStartDate7" value="5/27/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate7" name="txtVacaEndDate7" value="5/27/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName7" name="txtLastName7" value="Barfels" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName7" name="txtFirstName7" value="Dianne" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter7" name="txtVacaEnter7" value="1/15/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation7" name="chkVacation7" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO7" name="chkPTO7" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs7" name="txtPTOHrs7" value="0" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved7" name="chkApproved7" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy7" name="txtApprovedBy7" value="Todd" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut7" name="chkFilterOut7" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes7" name="txtInternalNotes7" value="" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr8">
<td><input type="text" id="txtVacaID8" name="txtVacaID8" value="3997" onkeydown="return enter(txtVacaStartDate8, txtVacaID9, txtVacaID7)" onFocus="ChangeColor(this.id, 8)" onBlur="ChangeColorBlur(this.id, 8)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate8" name="txtVacaStartDate8" value="6/27/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate8" name="txtVacaEndDate8" value="6/30/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName8" name="txtLastName8" value="Edmonds" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName8" name="txtFirstName8" value="Debbie" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter8" name="txtVacaEnter8" value="2/5/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation8" name="chkVacation8" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO8" name="chkPTO8" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs8" name="txtPTOHrs8" value="0" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved8" name="chkApproved8" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy8" name="txtApprovedBy8" value="Todd" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut8" name="chkFilterOut8" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes8" name="txtInternalNotes8" value="" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr9">
<td><input type="text" id="txtVacaID9" name="txtVacaID9" value="3996" onkeydown="return enter(txtVacaStartDate9, txtVacaID10, txtVacaID8)" onFocus="ChangeColor(this.id, 9)" onBlur="ChangeColorBlur(this.id, 9)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate9" name="txtVacaStartDate9" value="6/27/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate9" name="txtVacaEndDate9" value="6/30/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName9" name="txtLastName9" value="Edmonds" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName9" name="txtFirstName9" value="Don" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter9" name="txtVacaEnter9" value="2/5/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation9" name="chkVacation9" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO9" name="chkPTO9" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs9" name="txtPTOHrs9" value="0" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved9" name="chkApproved9" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy9" name="txtApprovedBy9" value="JEG" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut9" name="chkFilterOut9" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes9" name="txtInternalNotes9" value="" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr10">
<td><input type="text" id="txtVacaID10" name="txtVacaID10" value="3610" onkeydown="return enter(txtVacaStartDate10, txtVacaID11, txtVacaID9)" onFocus="ChangeColor(this.id, 10)" onBlur="ChangeColorBlur(this.id, 10)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate10" name="txtVacaStartDate10" value="7/2/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate10" name="txtVacaEndDate10" value="7/4/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName10" name="txtLastName10" value="Barfels" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName10" name="txtFirstName10" value="Dianne" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter10" name="txtVacaEnter10" value="7/5/2007" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation10" name="chkVacation10" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO10" name="chkPTO10" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs10" name="txtPTOHrs10" value="0" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved10" name="chkApproved10" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy10" name="txtApprovedBy10" value="Todd" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut10" name="chkFilterOut10" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes10" name="txtInternalNotes10" value="" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr11">
<td><input type="text" id="txtVacaID11" name="txtVacaID11" value="3615" onkeydown="return enter(txtVacaStartDate11, txtVacaID12, txtVacaID10)" onFocus="ChangeColor(this.id, 11)" onBlur="ChangeColorBlur(this.id, 11)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate11" name="txtVacaStartDate11" value="7/7/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate11" name="txtVacaEndDate11" value="7/7/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName11" name="txtLastName11" value="Wolf" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName11" name="txtFirstName11" value="Claudia" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter11" name="txtVacaEnter11" value="7/6/2007" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation11" name="chkVacation11" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO11" name="chkPTO11" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs11" name="txtPTOHrs11" value="8" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved11" name="chkApproved11" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy11" name="txtApprovedBy11" value="Todd" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut11" name="chkFilterOut11" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes11" name="txtInternalNotes11" value="" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
<tr id="tr12">
<td><input type="text" id="txtVacaID12" name="txtVacaID12" value="3939" onkeydown="return enterLastLine(txtVacaStartDate12, txtVacaID11)" onFocus="ChangeColor(this.id, 12)" onBlur="ChangeColorBlur(this.id, 12)" style="font: Verdana; font-size: 8pt" size="20" readonly autocomplete="off"></td>
<td><input type="text" id="txtVacaStartDate12" name="txtVacaStartDate12" value="12/26/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEndDate12" name="txtVacaEndDate12" value="12/26/2008" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtLastName12" name="txtLastName12" value="Wolf" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtFirstName12" name="txtFirstName12" value="Claudia" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtVacaEnter12" name="txtVacaEnter12" value="12/31/2007" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkVacation12" name="chkVacation12" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkPTO12" name="chkPTO12" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtPTOHrs12" name="txtPTOHrs12" value="8" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkApproved12" name="chkApproved12" checked value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtApprovedBy12" name="txtApprovedBy12" value="Todd" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="checkbox" id="chkFilterOut12" name="chkFilterOut12" value="-1" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"></td>
<td><input type="text" id="txtInternalNotes12" name="txtInternalNotes12" value="" style="font: Verdana; font-size: 8pt" size="20" autocomplete="off"</td>
</tr>
</table>
</body>
</html>
And I am going to PM you a site that has the page on an non-password protected page. I'll give instructinos on what to change and what not to change on the PM.
I'm not too concerned what values are passed on teh checkbox as I can always do an if then statemetn on the save page to change the values, I just need them to be different when on and off and consistent.
| |
|
|
|
rdouglass
Posts: 9228
From: Biddeford, ME USA
Status: offline
|
RE: Checkboxes and Values - 4/21/2008 10:15:14
Hi Dave,
I don't know if this will affect other areas but I think I know what you were trying to do. SO what I did was to rework that SaveRecord JS function like this:
function SaveRecord(strFieldName, VacaID, strFormField)
{
var url=""
if (strFormField.checked) {
url="VacationMgmtMenu-save.asp?Value=" + strFormField.value + "&FieldName=" + strFieldName + "&VacaID=" + VacaID
} else {
url="VacationMgmtMenu-save.asp?Value=0&FieldName=" + strFieldName + "&VacaID=" + VacaID
} alert(url)
xmlHttp=GetXmlHttpObject(stateChangedSaveRecord)
xmlHttp.open("GET", url , true)
xmlHttp.send(null)
}
and changed the onChange for the checkboxes to this:
onChange="SaveRecord('[PTO]', <%=rs("VacaID")%>, this)"
See, what I did was instead of passing the checkbox value (this.value), I pass the whole checkbox object (this). Then the JS function determines if it's checked or not. If i'ts checked, it puts the '-1' (whic I assume is for true) and if not, it uses a '0' for false.
I didn't see where you'd use the value anywhere else in that function so I think this should work for you.
Hope it helps.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
dzirkelb1
Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Checkboxes and Values - 4/21/2008 11:48:22
That did the trick for the checkboxes, thanks a lot!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
