Checkbox validation

N

nadesico

Hi,

I am trying to insert a function to validate that at least one checkbox
is checked. I have tried to do this on a separate page and it worked fine,
but when I tried to do this on the page that I want checked, the check does
not work. I am trying to update a page that I did not create and am not very
familiar with front page. Any help would be greatly appreciated.

This is what I used on the test page:

<script language="JavaScript" type="text/javascript">
<!--

function Validate(){
// require that at least one checkbox be checked
var checkSelected = false;
for (var i = 0; i < document.Page3.ServiceDate.length; i++){
if(Page3.ServiceDate.checked)
checkSelected = true;
}
if(!checkSelected){
alert("Please select at least 1 Service Date");
return (false);
}
return true
}
//-->

And this is the page that it did not work in. I inserted the above into the
<head> section of the document and placed "onsubmit="return Validate();"" in
the body section. I also had to remove most of the code for it to fit into
this post:

<%
provider_id = Request.ServerVariables ("LOGON_USER")
provider_id = UCASE(provider_id)
session("provider_id") = provider_id
%>

<html>

<head>

<script language="javascript" type="text/javascript" src="datetimepicker.js">

//Date Time Picker script- by TengYong Ng of http://www.rainforestnet.com
//Script featured on JavaScript Kit (http://www.javascriptkit.com)
//For this script, visit http://www.javascriptkit.com

</script>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>MTPS FY09 Form</title>
</head>

<body>


<form method="POST" action="--WEBBOT-SELF--" language="JavaScript"
name="FrontPage_Form1">
<!--webbot bot="SaveDatabase" startspan SuggestedExt="asp"
S-DataConnection="MTPSDailyFY09" S-RecordSource="MTPS"
U-Database-URL="../fpdb/MTPS Daily FY09.mdb"
U-Confirmation-Url="FY09Confirm.asp"
S-Form-Fields="ClinicianID PsychiatricMedDoseSched02 PsychiatricMedDose01
InterventionStrategy23 InterventionStrategy34 InterventionStrategy45
InterventionStrategy58_Other InterventionStrategy57_Other
InterventionStrategy56 InterventionStrategy12 InterventionStrategy01
TargetCompletionDate05 TargetProgressRating03 AXIS1CODE2 EligStatus Comment1
Discharge_LivingSit PsychiatricMedDoseSched03 PsychiatricMedDose02
PsychiatricMedication01 InterventionStrategy24 InterventionStrategy35
InterventionStrategy46 InterventionStrategy57 InterventionStrategy13
InterventionStrategy02 TargetCompletionDate06 TargetProgressRating04
AXIS1CODE3 FIRSTNAME Comment2 SupervisingClinicianID Projected_EndDate
PsychiatricMedDoseSched04 PsychiatricMedDose03 PsychiatricMedication02
PsychiatricMedChangeDesc01 InterventionStrategy36 InterventionStrategy47
InterventionStrategy58 InterventionStrategy03 InterventionStrategy14
InterventionStrategy25 TargetCompletionDate07 TargetProgressRating05 Comment3
Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
InterventionStrategy15 InterventionStrategy59 InterventionStrategy26 Target10
TargetCompletionDate08 TargetProgressRating06 Comment4 PsychiatricMedDose05
PsychiatricMedication04 PsychiatricMedChangeDesc03 InterventionStrategy49
InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07 DOB
Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
InterventionStrategy39 TargetProgressRating08 Target01 Comment10 Comment6
PsychiatricMedChangeDesc05 InterventionStrategy07 InterventionStrategy18
InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19 Target03
Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
Target03_Other ServiceSetting Comment9 Target05_Other Target05
InterventionStrategy60 Target07_Other Target06_Other Target06 Discharged
PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
TargetCompletionDate10 Target08_Other Target07 PrimaryDX LASTNAME
PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
InterventionStrategy40 Target10_Other Target09_Other Target08
ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
InterventionStrategy41 TargetProgressRating10 Target09 TargetCompletionDate01
ServiceSetting_OtherDesc LOC MonthYear_ofServices PsychiatricMedChange04
InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
ServiceDate AXIS2CODE1 CR ProviderID PsychiatricMedDoseSched01
InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
InterventionStrategy33 InterventionStrategy44 InterventionStrategy56_Other
InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
AXIS2CODE2"
S-Form-DBFields="ClinicianID PsychiatricMedDoseSched02
PsychiatricMedDose01 InterventionStrategy23 InterventionStrategy34
InterventionStrategy45 InterventionStrategy58_Other
InterventionStrategy57_Other InterventionStrategy56 InterventionStrategy12
InterventionStrategy01 TargetCompletionDate05 TargetProgressRating03
AXIS1CODE2 EligStatus Comment1 Discharge_LivingSit PsychiatricMedDoseSched03
PsychiatricMedDose02 PsychiatricMedication01 InterventionStrategy24
InterventionStrategy35 InterventionStrategy46 InterventionStrategy57
InterventionStrategy13 InterventionStrategy02 TargetCompletionDate06
TargetProgressRating04 AXIS1CODE3 Client_FirstName Comment2
SupervisingClinicianID Projected_EndDate PsychiatricMedDoseSched04
PsychiatricMedDose03 PsychiatricMedication02 PsychiatricMedChangeDesc01
InterventionStrategy36 InterventionStrategy47 InterventionStrategy58
InterventionStrategy03 InterventionStrategy14 InterventionStrategy25
TargetCompletionDate07 TargetProgressRating05 Comment3
Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
InterventionStrategy15 InterventionStrategy59 InterventionStrategy26 Target10
TargetCompletionDate08 TargetProgressRating06 Comment4 PsychiatricMedDose05
PsychiatricMedication04 PsychiatricMedChangeDesc03 InterventionStrategy49
InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07 DOB
Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
InterventionStrategy39 TargetProgressRating08 Target01 Comment10 Comment6
PsychiatricMedChangeDesc05 InterventionStrategy07 InterventionStrategy18
InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19 Target03
Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
Target03_Other ServiceSetting Comment9 Target05_Other Target05
InterventionStrategy60 Target07_Other Target06_Other Target06 Discharged
PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
TargetCompletionDate10 Target08_Other Target07 PrimaryDx Client_LastName
PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
InterventionStrategy40 Target10_Other Target09_Other Target08
ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
InterventionStrategy41 TargetProgressRating10 Target09 TargetCompletionDate01
ServiceSetting_OtherDesc LOC MonthYear_ofServices PsychiatricMedChange04
InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
ServiceDate AXIS2CODE1 CR_No AddID PsychiatricMedDoseSched01
InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
InterventionStrategy33 InterventionStrategy44 InterventionStrategy56_Other
InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
AXIS2CODE2"
U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden"
NAME="VTI-GROUP" VALUE="0"><!--#include
file="../_fpclass/fpdbform.inc"--><!--webbot
bot="SaveDatabase" endspan -->
<%
fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
CR = ::CR::)"
fp_sDefault="LOGON_USER=&CR="
fp_sNoRecords="No records returned."
fp_sDataConn="MTPSDailyFY09"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="LastMTPSDate"
fp_sMenuValue="LastMTPSDate"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=30
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" i-CheckSum="23913" endspan -->
<select NAME="LastMTPSDate" SIZE="1">
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
file="../_fpclass/fpdbrgn1.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52766" endspan -->
<option><%=FP_FieldHTML(fp_rs,"LastMTPSDate")%></option>
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
file="../_fpclass/fpdbrgn2.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52830" endspan -->
</select><!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside
local_preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> "
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> " --><!--webbot
bot="DatabaseRegionEnd" endspan -->
<br>
Last MTPS LOC:<!--webbot bot="DatabaseRegionStart" startspan

s-columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE" b-menuformat="TRUE"
s-menuchoice="LastMTPSLOC" s-menuvalue="LastMTPSLOC" b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-ListFormat="0" b-makeform="FALSE" s-recordsource
s-displaycolumns="LastMTPSLOC" s-criteria s-order
s-sql="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
CR = ::CR::)"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="LOGON_USER=&CR=" s-NoRecordsFound="No records returned."
i-MaxRecords="256" i-GroupSize="0" BOTID="32"
u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../_fpclass/fpdbrgn2.inc"
local_preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> "
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> " --><!--#include
file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
CR = ::CR::)"
fp_sDefault="LOGON_USER=&CR="
fp_sNoRecords="No records returned."
fp_sDataConn="MTPSDailyFY09"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="LastMTPSLOC"
fp_sMenuValue="LastMTPSLOC"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=32
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" i-CheckSum="8988" endspan -->
<select NAME="LastMTPSLOC" SIZE="1">
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
file="../_fpclass/fpdbrgn1.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52766" endspan -->
<option><%=FP_FieldHTML(fp_rs,"LastMTPSLOC")%></option>
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
file="../_fpclass/fpdbrgn2.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52830" endspan -->
</select><!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside
local_preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> "
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> " --><!--webbot
bot="DatabaseRegionEnd" endspan -->
</nobr></font></p>
<table border="1" width="100%" height="70">
<tr>
<td width="100%" height="23">CR#:<nobr><!--webbot
bot="DatabaseRegionStart" startspan

s-columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE"
b-menuformat="TRUE" s-menuchoice="CR" s-menuvalue="CR"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="FALSE" s-recordsource s-displaycolumns="CR" s-criteria
s-order
s-sql="SELECT * FROM ClientRegis WHERE (ProviderID =
'::LOGON_USER::' AND CR = ::CR::)"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="LOGON_USER=&CR="
s-NoRecordsFound="No records returned." i-MaxRecords="256"
i-GroupSize="0" BOTID="20" u-dblib="../_fpclass/fpdblib.inc"
u-dbrgn1="../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../_fpclass/fpdbrgn2.inc"
local_preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> "
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> " --><!--#include
file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
CR = ::CR::)"
fp_sDefault="LOGON_USER=&CR="
fp_sNoRecords="No records returned."
fp_sDataConn="MTPSDailyFY09"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="CR"
fp_sMenuValue="CR"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=20
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" i-CheckSum="13644" endspan -->
<select NAME="CR" SIZE="1">
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
file="../_fpclass/fpdbrgn1.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52766" endspan -->
<option><%=FP_FieldHTML(fp_rs,"CR")%></option>
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
file="../_fpclass/fpdbrgn2.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52830" endspan -->
</select><!--webbot bot="DatabaseRegionEnd" startspan
b-tableformat="FALSE" b-menuformat="TRUE"
u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
local_preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> "
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> " --><!--webbot
bot="DatabaseRegionEnd" endspan -->
</nobr> DOB: <nobr><!--webbot bot="DatabaseRegionStart"
startspan

s-columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE"
b-menuformat="TRUE" s-menuchoice="DOB" s-menuvalue="DOB"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="FALSE" s-recordsource s-displaycolumns="DOB" s-criteria
s-order
s-sql="SELECT * FROM ClientRegis WHERE (ProviderID =
'::LOGON_USER::' AND CR = ::CR::)"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="LOGON_USER=&CR="
s-NoRecordsFound="No records returned." i-MaxRecords="256"
i-GroupSize="0" BOTID="23" u-dblib="../_fpclass/fpdblib.inc"
u-dbrgn1="../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../_fpclass/fpdbrgn2.inc"
local_preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> "
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> " --><!--#include
file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
CR = ::CR::)"
fp_sDefault="LOGON_USER=&CR="
fp_sNoRecords="No records returned."
fp_sDataConn="MTPSDailyFY09"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="DOB"
fp_sMenuValue="DOB"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=23
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" i-CheckSum="25245" endspan -->
<select NAME="DOB" SIZE="1">
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
file="../_fpclass/fpdbrgn1.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52766" endspan -->
<option><%=FP_FieldHTML(fp_rs,"DOB")%></option>
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
file="../_fpclass/fpdbrgn2.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52830" endspan -->
</select><!--webbot bot="DatabaseRegionEnd" startspan
b-tableformat="FALSE" b-menuformat="TRUE"
u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
local_preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> "
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> " --><!--webbot
bot="DatabaseRegionEnd" endspan -->
columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE"
b-menuformat="TRUE" s-menuchoice="AXIS1CODE2" s-menuvalue="AXIS1CODE2"
b-tableborder="TRUE" b-tableexpand="FALSE" b-tableheader="FALSE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="FALSE" s-recordsource s-displaycolumns="AXIS1CODE2"
s-criteria s-order
s-sql="SELECT * FROM ClientRegis WHERE (ProviderID =
'::LOGON_USER::' AND CR = ::CR::)"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="LOGON_USER=&CR="
s-NoRecordsFound="No records returned." i-MaxRecords="256"
i-GroupSize="0" BOTID="33" u-dblib="../_fpclass/fpdblib.inc"
u-dbrgn1="../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../_fpclass/fpdbrgn2.inc"
local_preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> "
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> " --><!--#include
file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
CR = ::CR::)"
fp_sDefault="LOGON_USER=&CR="
fp_sNoRecords="No records returned."
fp_sDataConn="MTPSDailyFY09"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="AXIS1CODE2"
fp_sMenuValue="AXIS1CODE2"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=33
fp_iRegion=BOTID
%>
<%
fp_sQry="SELECT * FROM code_LOC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="MTPSDailyFY09"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="LOC"
fp_sMenuValue="LOC"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=26
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" i-CheckSum="39552" endspan --><!--webbot
bot="Validation" S-Display-Name="LOC" B-Value-Required="TRUE"
B-Disallow-First-Item="TRUE" --><select NAME="LOC" SIZE="1">
<option>(Select an LOC)</option>

<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
file="../_fpclass/fpdbrgn1.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52766" endspan -->
<option><%=FP_FieldHTML(fp_rs,"LOC")%></option>
<!--webbot bot="AspInclude" startspan CLIENTSIDE
U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
file="../_fpclass/fpdbrgn2.inc"--><!--webbot
bot="AspInclude" i-CheckSum="52830" endspan -->
</select><!--webbot bot="DatabaseRegionEnd" startspan
b-tableformat="FALSE" b-menuformat="TRUE"
u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
local_preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> "
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> " --><!--webbot
bot="DatabaseRegionEnd" endspan -->
</nobr>
</nobr>
</td>
</tr>
</table>
<td><font face="Arial" size="2">Other Description:</font><input
type="text" name="ServiceFormat_OtherDesc" size="18"
maxlength=50> </td>
<td><font face="Arial" size="2">Other Description:</font><input
type="text" name="ServiceSetting_OtherDesc" size="18"
maxlength=50> </td>
</tr>
</table>
<p><b>Service Date(s) (Check All That Apply):</b></p>
<div align="left">
<table border="1" width="676" height="44">
<tr>
<td width="604" height="44" align="center">1st</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="1"></td>
<td width="604" height="44" align="center">2nd</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="2"></td>
<td width="604" height="44" align="center">3rd</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="3"></td>
<td width="604" height="44" align="center">4th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="4"></td>
<td width="604" height="44" align="center">5th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="5"></td>
<td width="604" height="44" align="center">6th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="6"></td>
<td width="604" height="44" align="center">7th</td>
<td width="676" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="7"></td>
</tr>
<tr>
<td width="604" height="44" align="center">8th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="8"></td>
<td width="604" height="44" align="center">9th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="9"></td>
<td width="604" height="44" align="center">10th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="10"></td>
<td width="604" height="44" align="center">11th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="11"></td>
<td width="604" height="44" align="center">12th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="12"></td>
<td width="604" height="44" align="center">13th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="13"></td>
<td width="604" height="44" align="center">14th</td>
<td width="676" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="14"></td>
</tr>
<tr>
<td width="604" height="44" align="center">15th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="15"></td>
<td width="604" height="44" align="center">16th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="16"></td>
<td width="604" height="44" align="center">17th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="17"></td>
<td width="604" height="44" align="center">18th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="18"></td>
<td width="604" height="44" align="center">19th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="19"></td>
<td width="604" height="44" align="center">20th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="20"></td>
<td width="604" height="44" align="center">21st</td>
<td width="676" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="21"></td>
</tr>
<tr>
<td width="604" height="44" align="center">22nd</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="22"></td>
<td width="604" height="44" align="center">23rd</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="23"></td>
<td width="604" height="44" align="center">24th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="24"></td>
<td width="604" height="44" align="center">25th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="25"></td>
<td width="604" height="44" align="center">26th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="26"></td>
<td width="604" height="44" align="center">27th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="27"></td>
<td width="604" height="44" align="center">28th</td>
<td width="676" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="28"></td>
</tr>
<tr>
<td width="604" height="44" align="center">29th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="29"></td>
<td width="604" height="44" align="center">30th</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="30"></td>
<td width="604" height="44" align="center">31st</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="31"></td>
<td width="604" height="44" align="center"></td>
<td width="604" height="44" align="center"></td>
<td width="604" height="44" align="center"></td>
<td width="604" height="44" align="center"></td>
<td width="604" height="44" align="center"></td>
<td width="604" height="44" align="center"></td>
<td width="604" height="44" align="center"></td>
<td width="676" height="44" align="center"></td>
</tr>
</table>

</form>

</b>

</body>

</html>
 
S

Stefan B Rusynko

All your ASP & Html code is not relevant to your question except the table with the 31 service date check boxes

1) All of your check box fields must have unique field names, yours are the same
(ServiceDate1 thru ServiceDate31)
2) There is no valid parameter named multiple for a check box field
(multiple only applies to dropdown boxes)
3) You can not use FP Form field validation in conjunction with Javascript validation
(remove all FP form field validation)
4) And the cell width of 604 for each check box should be removed
(it is an error)

So where you have say
<td width="604" height="44" align="center">1st</td>
<td width="604" height="44" align="center"><input type="checkbox" name="ServiceDate" multiple value="1"></td>
<td width="604" height="44" align="center">2nd</td>
<td width="604" height="44" align="center"><input type="checkbox" name="ServiceDate" multiple value="2"></td>
.... and so on
You should have
<td height="44" align="center">1st</td>
<td height="44" align="center"><input type="checkbox" name="ServiceDate1"value="1"></td>
<td height="44" align="center">2nd</td>
<td height="44" align="center"><input type="checkbox" name="ServiceDate2"value="2"></td>

.... and so on

Then use the following in the head section of your page to check if at least 1 box is checked in the form

<script type="text/javascript" language="JavaScript">
var NoDateMsg = 'WARNING: NO SERVICE DATES WERE SELECTED -' + '\n' + '\n'
+ 'You have Not Selected any Service Dates!' + '\n'
+ 'SELECT "Cancel" to Enter one Correctly!' + '\n' + '\n';
function validateValues(frmName) {
var valid = true; var checkBoxes = false; var checkboxChecked = false;
for (var i=0, j=frmName.elements.length; i<j; i++) { fldType = frmName.elements.type;
if (fldType == 'checkbox') { checkBoxes = true; if (frmName.elements.checked) { checkboxChecked = true; } }
}
if ((checkBoxes && !checkboxChecked)) { valid = false; if (!valid) { if (confirm( NoDateMsg )) {return true;} else { history.go(0);
return false;}; } }
}
</script>
and change your form tag to cal teh above vaidation script as

<form method="POST" action="--WEBBOT-SELF--" name="FrontPage_Form1" onSubmit="return validateValues(document.FrontPage_Form1)">


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi,
|
| I am trying to insert a function to validate that at least one checkbox
| is checked. I have tried to do this on a separate page and it worked fine,
| but when I tried to do this on the page that I want checked, the check does
| not work. I am trying to update a page that I did not create and am not very
| familiar with front page. Any help would be greatly appreciated.
|
| This is what I used on the test page:
|
| <script language="JavaScript" type="text/javascript">
| <!--
|
| function Validate(){
| // require that at least one checkbox be checked
| var checkSelected = false;
| for (var i = 0; i < document.Page3.ServiceDate.length; i++){
| if(Page3.ServiceDate.checked)
| checkSelected = true;
| }
| if(!checkSelected){
| alert("Please select at least 1 Service Date");
| return (false);
| }
| return true
| }
| //-->
|
| And this is the page that it did not work in. I inserted the above into the
| <head> section of the document and placed "onsubmit="return Validate();"" in
| the body section. I also had to remove most of the code for it to fit into
| this post:
|
| <%
| provider_id = Request.ServerVariables ("LOGON_USER")
| provider_id = UCASE(provider_id)
| session("provider_id") = provider_id
| %>
|
| <html>
|
| <head>
|
| <script language="javascript" type="text/javascript" src="datetimepicker.js">
|
| //Date Time Picker script- by TengYong Ng of http://www.rainforestnet.com
| //Script featured on JavaScript Kit (http://www.javascriptkit.com)
| //For this script, visit http://www.javascriptkit.com
|
| </script>
|
| <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
| <meta name="ProgId" content="FrontPage.Editor.Document">
| <title>MTPS FY09 Form</title>
| </head>
|
| <body>
|
|
| <form method="POST" action="--WEBBOT-SELF--" language="JavaScript"
| name="FrontPage_Form1">
| <!--webbot bot="SaveDatabase" startspan SuggestedExt="asp"
| S-DataConnection="MTPSDailyFY09" S-RecordSource="MTPS"
| U-Database-URL="../fpdb/MTPS Daily FY09.mdb"
| U-Confirmation-Url="FY09Confirm.asp"
| S-Form-Fields="ClinicianID PsychiatricMedDoseSched02 PsychiatricMedDose01
| InterventionStrategy23 InterventionStrategy34 InterventionStrategy45
| InterventionStrategy58_Other InterventionStrategy57_Other
| InterventionStrategy56 InterventionStrategy12 InterventionStrategy01
| TargetCompletionDate05 TargetProgressRating03 AXIS1CODE2 EligStatus Comment1
| Discharge_LivingSit PsychiatricMedDoseSched03 PsychiatricMedDose02
| PsychiatricMedication01 InterventionStrategy24 InterventionStrategy35
| InterventionStrategy46 InterventionStrategy57 InterventionStrategy13
| InterventionStrategy02 TargetCompletionDate06 TargetProgressRating04
| AXIS1CODE3 FIRSTNAME Comment2 SupervisingClinicianID Projected_EndDate
| PsychiatricMedDoseSched04 PsychiatricMedDose03 PsychiatricMedication02
| PsychiatricMedChangeDesc01 InterventionStrategy36 InterventionStrategy47
| InterventionStrategy58 InterventionStrategy03 InterventionStrategy14
| InterventionStrategy25 TargetCompletionDate07 TargetProgressRating05 Comment3
| Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
| PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
| InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
| InterventionStrategy15 InterventionStrategy59 InterventionStrategy26 Target10
| TargetCompletionDate08 TargetProgressRating06 Comment4 PsychiatricMedDose05
| PsychiatricMedication04 PsychiatricMedChangeDesc03 InterventionStrategy49
| InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
| InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07 DOB
| Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
| InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
| InterventionStrategy39 TargetProgressRating08 Target01 Comment10 Comment6
| PsychiatricMedChangeDesc05 InterventionStrategy07 InterventionStrategy18
| InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
| ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19 Target03
| Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
| Target03_Other ServiceSetting Comment9 Target05_Other Target05
| InterventionStrategy60 Target07_Other Target06_Other Target06 Discharged
| PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
| TargetCompletionDate10 Target08_Other Target07 PrimaryDX LASTNAME
| PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
| InterventionStrategy40 Target10_Other Target09_Other Target08
| ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
| InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
| InterventionStrategy41 TargetProgressRating10 Target09 TargetCompletionDate01
| ServiceSetting_OtherDesc LOC MonthYear_ofServices PsychiatricMedChange04
| InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
| InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
| PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
| InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
| InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
| ServiceDate AXIS2CODE1 CR ProviderID PsychiatricMedDoseSched01
| InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
| InterventionStrategy33 InterventionStrategy44 InterventionStrategy56_Other
| InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
| AXIS2CODE2"
| S-Form-DBFields="ClinicianID PsychiatricMedDoseSched02
| PsychiatricMedDose01 InterventionStrategy23 InterventionStrategy34
| InterventionStrategy45 InterventionStrategy58_Other
| InterventionStrategy57_Other InterventionStrategy56 InterventionStrategy12
| InterventionStrategy01 TargetCompletionDate05 TargetProgressRating03
| AXIS1CODE2 EligStatus Comment1 Discharge_LivingSit PsychiatricMedDoseSched03
| PsychiatricMedDose02 PsychiatricMedication01 InterventionStrategy24
| InterventionStrategy35 InterventionStrategy46 InterventionStrategy57
| InterventionStrategy13 InterventionStrategy02 TargetCompletionDate06
| TargetProgressRating04 AXIS1CODE3 Client_FirstName Comment2
| SupervisingClinicianID Projected_EndDate PsychiatricMedDoseSched04
| PsychiatricMedDose03 PsychiatricMedication02 PsychiatricMedChangeDesc01
| InterventionStrategy36 InterventionStrategy47 InterventionStrategy58
| InterventionStrategy03 InterventionStrategy14 InterventionStrategy25
| TargetCompletionDate07 TargetProgressRating05 Comment3
| Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
| PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
| InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
| InterventionStrategy15 InterventionStrategy59 InterventionStrategy26 Target10
| TargetCompletionDate08 TargetProgressRating06 Comment4 PsychiatricMedDose05
| PsychiatricMedication04 PsychiatricMedChangeDesc03 InterventionStrategy49
| InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
| InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07 DOB
| Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
| InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
| InterventionStrategy39 TargetProgressRating08 Target01 Comment10 Comment6
| PsychiatricMedChangeDesc05 InterventionStrategy07 InterventionStrategy18
| InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
| ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19 Target03
| Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
| Target03_Other ServiceSetting Comment9 Target05_Other Target05
| InterventionStrategy60 Target07_Other Target06_Other Target06 Discharged
| PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
| TargetCompletionDate10 Target08_Other Target07 PrimaryDx Client_LastName
| PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
| InterventionStrategy40 Target10_Other Target09_Other Target08
| ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
| InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
| InterventionStrategy41 TargetProgressRating10 Target09 TargetCompletionDate01
| ServiceSetting_OtherDesc LOC MonthYear_ofServices PsychiatricMedChange04
| InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
| InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
| PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
| InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
| InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
| ServiceDate AXIS2CODE1 CR_No AddID PsychiatricMedDoseSched01
| InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
| InterventionStrategy33 InterventionStrategy44 InterventionStrategy56_Other
| InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
| AXIS2CODE2"
| U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden"
| NAME="VTI-GROUP" VALUE="0"><!--#include
| file="../_fpclass/fpdbform.inc"--><!--webbot
| bot="SaveDatabase" endspan -->
| <%
| fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| CR = ::CR::)"
| fp_sDefault="LOGON_USER=&CR="
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="LastMTPSDate"
| fp_sMenuValue="LastMTPSDate"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=30
| fp_iRegion=BOTID
| %>
| <!--webbot bot="DatabaseRegionStart" i-CheckSum="23913" endspan -->
| <select NAME="LastMTPSDate" SIZE="1">
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
| file="../_fpclass/fpdbrgn1.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52766" endspan -->
| <option><%=FP_FieldHTML(fp_rs,"LastMTPSDate")%></option>
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
| file="../_fpclass/fpdbrgn2.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52830" endspan -->
| </select><!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
| b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
| clientside
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> " --><!--webbot
| bot="DatabaseRegionEnd" endspan -->
| <br>
| Last MTPS LOC:<!--webbot bot="DatabaseRegionStart" startspan
|
|
s-columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
| s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
| s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE" b-menuformat="TRUE"
| s-menuchoice="LastMTPSLOC" s-menuvalue="LastMTPSLOC" b-tableborder="TRUE"
| b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
| b-listseparator="TRUE" i-ListFormat="0" b-makeform="FALSE" s-recordsource
| s-displaycolumns="LastMTPSLOC" s-criteria s-order
| s-sql="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| CR = ::CR::)"
| b-procedure="FALSE" clientside SuggestedExt="asp"
| s-DefaultFields="LOGON_USER=&CR=" s-NoRecordsFound="No records returned."
| i-MaxRecords="256" i-GroupSize="0" BOTID="32"
| u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc"
| u-dbrgn2="../_fpclass/fpdbrgn2.inc"
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> " --><!--#include
| file="../_fpclass/fpdblib.inc"-->
| <%
| fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| CR = ::CR::)"
| fp_sDefault="LOGON_USER=&CR="
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="LastMTPSLOC"
| fp_sMenuValue="LastMTPSLOC"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=32
| fp_iRegion=BOTID
| %>
| <!--webbot bot="DatabaseRegionStart" i-CheckSum="8988" endspan -->
| <select NAME="LastMTPSLOC" SIZE="1">
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
| file="../_fpclass/fpdbrgn1.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52766" endspan -->
| <option><%=FP_FieldHTML(fp_rs,"LastMTPSLOC")%></option>
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
| file="../_fpclass/fpdbrgn2.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52830" endspan -->
| </select><!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
| b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
| clientside
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> " --><!--webbot
| bot="DatabaseRegionEnd" endspan -->
| </nobr></font></p>
| <table border="1" width="100%" height="70">
| <tr>
| <td width="100%" height="23">CR#:<nobr><!--webbot
| bot="DatabaseRegionStart" startspan
|
|
s-columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
| s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
| s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE"
| b-menuformat="TRUE" s-menuchoice="CR" s-menuvalue="CR"
| b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
| b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
| b-makeform="FALSE" s-recordsource s-displaycolumns="CR" s-criteria
| s-order
| s-sql="SELECT * FROM ClientRegis WHERE (ProviderID =
| '::LOGON_USER::' AND CR = ::CR::)"
| b-procedure="FALSE" clientside SuggestedExt="asp"
| s-DefaultFields="LOGON_USER=&CR="
| s-NoRecordsFound="No records returned." i-MaxRecords="256"
| i-GroupSize="0" BOTID="20" u-dblib="../_fpclass/fpdblib.inc"
| u-dbrgn1="../_fpclass/fpdbrgn1.inc"
| u-dbrgn2="../_fpclass/fpdbrgn2.inc"
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> " --><!--#include
| file="../_fpclass/fpdblib.inc"-->
| <%
| fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| CR = ::CR::)"
| fp_sDefault="LOGON_USER=&CR="
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="CR"
| fp_sMenuValue="CR"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=20
| fp_iRegion=BOTID
| %>
| <!--webbot bot="DatabaseRegionStart" i-CheckSum="13644" endspan -->
| <select NAME="CR" SIZE="1">
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
| file="../_fpclass/fpdbrgn1.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52766" endspan -->
| <option><%=FP_FieldHTML(fp_rs,"CR")%></option>
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
| file="../_fpclass/fpdbrgn2.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52830" endspan -->
| </select><!--webbot bot="DatabaseRegionEnd" startspan
| b-tableformat="FALSE" b-menuformat="TRUE"
| u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> " --><!--webbot
| bot="DatabaseRegionEnd" endspan -->
| </nobr> DOB: <nobr><!--webbot bot="DatabaseRegionStart"
| startspan
|
|
s-columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
| s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
| s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE"
| b-menuformat="TRUE" s-menuchoice="DOB" s-menuvalue="DOB"
| b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
| b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
| b-makeform="FALSE" s-recordsource s-displaycolumns="DOB" s-criteria
| s-order
| s-sql="SELECT * FROM ClientRegis WHERE (ProviderID =
| '::LOGON_USER::' AND CR = ::CR::)"
| b-procedure="FALSE" clientside SuggestedExt="asp"
| s-DefaultFields="LOGON_USER=&CR="
| s-NoRecordsFound="No records returned." i-MaxRecords="256"
| i-GroupSize="0" BOTID="23" u-dblib="../_fpclass/fpdblib.inc"
| u-dbrgn1="../_fpclass/fpdbrgn1.inc"
| u-dbrgn2="../_fpclass/fpdbrgn2.inc"
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> " --><!--#include
| file="../_fpclass/fpdblib.inc"-->
| <%
| fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| CR = ::CR::)"
| fp_sDefault="LOGON_USER=&CR="
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="DOB"
| fp_sMenuValue="DOB"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=23
| fp_iRegion=BOTID
| %>
| <!--webbot bot="DatabaseRegionStart" i-CheckSum="25245" endspan -->
| <select NAME="DOB" SIZE="1">
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
| file="../_fpclass/fpdbrgn1.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52766" endspan -->
| <option><%=FP_FieldHTML(fp_rs,"DOB")%></option>
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
| file="../_fpclass/fpdbrgn2.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52830" endspan -->
| </select><!--webbot bot="DatabaseRegionEnd" startspan
| b-tableformat="FALSE" b-menuformat="TRUE"
| u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> " --><!--webbot
| bot="DatabaseRegionEnd" endspan -->
|
columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
| s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
| s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE"
| b-menuformat="TRUE" s-menuchoice="AXIS1CODE2" s-menuvalue="AXIS1CODE2"
| b-tableborder="TRUE" b-tableexpand="FALSE" b-tableheader="FALSE"
| b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
| b-makeform="FALSE" s-recordsource s-displaycolumns="AXIS1CODE2"
| s-criteria s-order
| s-sql="SELECT * FROM ClientRegis WHERE (ProviderID =
| '::LOGON_USER::' AND CR = ::CR::)"
| b-procedure="FALSE" clientside SuggestedExt="asp"
| s-DefaultFields="LOGON_USER=&CR="
| s-NoRecordsFound="No records returned." i-MaxRecords="256"
| i-GroupSize="0" BOTID="33" u-dblib="../_fpclass/fpdblib.inc"
| u-dbrgn1="../_fpclass/fpdbrgn1.inc"
| u-dbrgn2="../_fpclass/fpdbrgn2.inc"
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> " --><!--#include
| file="../_fpclass/fpdblib.inc"-->
| <%
| fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| CR = ::CR::)"
| fp_sDefault="LOGON_USER=&CR="
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="AXIS1CODE2"
| fp_sMenuValue="AXIS1CODE2"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=33
| fp_iRegion=BOTID
| %>
| <%
| fp_sQry="SELECT * FROM code_LOC"
| fp_sDefault=""
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="LOC"
| fp_sMenuValue="LOC"
| fp_iDisplayCols=1
| fp_fCustomQuery=False
| BOTID=26
| fp_iRegion=BOTID
| %>
| <!--webbot bot="DatabaseRegionStart" i-CheckSum="39552" endspan --><!--webbot
| bot="Validation" S-Display-Name="LOC" B-Value-Required="TRUE"
| B-Disallow-First-Item="TRUE" --><select NAME="LOC" SIZE="1">
| <option>(Select an LOC)</option>
|
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
| file="../_fpclass/fpdbrgn1.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52766" endspan -->
| <option><%=FP_FieldHTML(fp_rs,"LOC")%></option>
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
| file="../_fpclass/fpdbrgn2.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52830" endspan -->
| </select><!--webbot bot="DatabaseRegionEnd" startspan
| b-tableformat="FALSE" b-menuformat="TRUE"
| u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> " --><!--webbot
| bot="DatabaseRegionEnd" endspan -->
| </nobr>
| </nobr>
| </td>
| </tr>
| </table>
| <td><font face="Arial" size="2">Other Description:</font><input
| type="text" name="ServiceFormat_OtherDesc" size="18"
| maxlength=50> </td>
| <td><font face="Arial" size="2">Other Description:</font><input
| type="text" name="ServiceSetting_OtherDesc" size="18"
| maxlength=50> </td>
| </tr>
| </table>
| <p><b>Service Date(s) (Check All That Apply):</b></p>
| <div align="left">
| <table border="1" width="676" height="44">
| <tr>
| <td width="604" height="44" align="center">1st</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="1"></td>
| <td width="604" height="44" align="center">2nd</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="2"></td>
| <td width="604" height="44" align="center">3rd</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="3"></td>
| <td width="604" height="44" align="center">4th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="4"></td>
| <td width="604" height="44" align="center">5th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="5"></td>
| <td width="604" height="44" align="center">6th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="6"></td>
| <td width="604" height="44" align="center">7th</td>
| <td width="676" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="7"></td>
| </tr>
| <tr>
| <td width="604" height="44" align="center">8th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="8"></td>
| <td width="604" height="44" align="center">9th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="9"></td>
| <td width="604" height="44" align="center">10th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="10"></td>
| <td width="604" height="44" align="center">11th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="11"></td>
| <td width="604" height="44" align="center">12th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="12"></td>
| <td width="604" height="44" align="center">13th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="13"></td>
| <td width="604" height="44" align="center">14th</td>
| <td width="676" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="14"></td>
| </tr>
| <tr>
| <td width="604" height="44" align="center">15th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="15"></td>
| <td width="604" height="44" align="center">16th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="16"></td>
| <td width="604" height="44" align="center">17th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="17"></td>
| <td width="604" height="44" align="center">18th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="18"></td>
| <td width="604" height="44" align="center">19th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="19"></td>
| <td width="604" height="44" align="center">20th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="20"></td>
| <td width="604" height="44" align="center">21st</td>
| <td width="676" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="21"></td>
| </tr>
| <tr>
| <td width="604" height="44" align="center">22nd</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="22"></td>
| <td width="604" height="44" align="center">23rd</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="23"></td>
| <td width="604" height="44" align="center">24th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="24"></td>
| <td width="604" height="44" align="center">25th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="25"></td>
| <td width="604" height="44" align="center">26th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="26"></td>
| <td width="604" height="44" align="center">27th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="27"></td>
| <td width="604" height="44" align="center">28th</td>
| <td width="676" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="28"></td>
| </tr>
| <tr>
| <td width="604" height="44" align="center">29th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="29"></td>
| <td width="604" height="44" align="center">30th</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="30"></td>
| <td width="604" height="44" align="center">31st</td>
| <td width="604" height="44" align="center"><input type="checkbox"
| name="ServiceDate" multiple value="31"></td>
| <td width="604" height="44" align="center"></td>
| <td width="604" height="44" align="center"></td>
| <td width="604" height="44" align="center"></td>
| <td width="604" height="44" align="center"></td>
| <td width="604" height="44" align="center"></td>
| <td width="604" height="44" align="center"></td>
| <td width="604" height="44" align="center"></td>
| <td width="676" height="44" align="center"></td>
| </tr>
| </table>
|
| </form>
|
| </b>
|
| </body>
|
| </html>
|
|
 
N

nadesico

Hi,

Thanks for the help. I made the changes you recommended and the check
still does not work. Would having other checkboxes in the form make a
difference? I have another area of the form with checkboxes?

Stefan B Rusynko said:
All your ASP & Html code is not relevant to your question except the table with the 31 service date check boxes

1) All of your check box fields must have unique field names, yours are the same
(ServiceDate1 thru ServiceDate31)
2) There is no valid parameter named multiple for a check box field
(multiple only applies to dropdown boxes)
3) You can not use FP Form field validation in conjunction with Javascript validation
(remove all FP form field validation)
4) And the cell width of 604 for each check box should be removed
(it is an error)

So where you have say
<td width="604" height="44" align="center">1st</td>
<td width="604" height="44" align="center"><input type="checkbox" name="ServiceDate" multiple value="1"></td>
<td width="604" height="44" align="center">2nd</td>
<td width="604" height="44" align="center"><input type="checkbox" name="ServiceDate" multiple value="2"></td>
.... and so on
You should have
<td height="44" align="center">1st</td>
<td height="44" align="center"><input type="checkbox" name="ServiceDate1"value="1"></td>
<td height="44" align="center">2nd</td>
<td height="44" align="center"><input type="checkbox" name="ServiceDate2"value="2"></td>

.... and so on

Then use the following in the head section of your page to check if at least 1 box is checked in the form

<script type="text/javascript" language="JavaScript">
var NoDateMsg = 'WARNING: NO SERVICE DATES WERE SELECTED -' + '\n' + '\n'
+ 'You have Not Selected any Service Dates!' + '\n'
+ 'SELECT "Cancel" to Enter one Correctly!' + '\n' + '\n';
function validateValues(frmName) {
var valid = true; var checkBoxes = false; var checkboxChecked = false;
for (var i=0, j=frmName.elements.length; i<j; i++) { fldType = frmName.elements.type;
if (fldType == 'checkbox') { checkBoxes = true; if (frmName.elements.checked) { checkboxChecked = true; } }
}
if ((checkBoxes && !checkboxChecked)) { valid = false; if (!valid) { if (confirm( NoDateMsg )) {return true;} else { history.go(0);
return false;}; } }
}
</script>
and change your form tag to cal teh above vaidation script as

<form method="POST" action="--WEBBOT-SELF--" name="FrontPage_Form1" onSubmit="return validateValues(document.FrontPage_Form1)">


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi,
|
| I am trying to insert a function to validate that at least one checkbox
| is checked. I have tried to do this on a separate page and it worked fine,
| but when I tried to do this on the page that I want checked, the check does
| not work. I am trying to update a page that I did not create and am not very
| familiar with front page. Any help would be greatly appreciated.
|
| This is what I used on the test page:
|
| <script language="JavaScript" type="text/javascript">
| <!--
|
| function Validate(){
| // require that at least one checkbox be checked
| var checkSelected = false;
| for (var i = 0; i < document.Page3.ServiceDate.length; i++){
| if(Page3.ServiceDate.checked)
| checkSelected = true;
| }
| if(!checkSelected){
| alert("Please select at least 1 Service Date");
| return (false);
| }
| return true
| }
| //-->
|
| And this is the page that it did not work in. I inserted the above into the
| <head> section of the document and placed "onsubmit="return Validate();"" in
| the body section. I also had to remove most of the code for it to fit into
| this post:
|
| <%
| provider_id = Request.ServerVariables ("LOGON_USER")
| provider_id = UCASE(provider_id)
| session("provider_id") = provider_id
| %>
|
| <html>
|
| <head>
|
| <script language="javascript" type="text/javascript" src="datetimepicker.js">
|
| //Date Time Picker script- by TengYong Ng of http://www.rainforestnet.com
| //Script featured on JavaScript Kit (http://www.javascriptkit.com)
| //For this script, visit http://www.javascriptkit.com
|
| </script>
|
| <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
| <meta name="ProgId" content="FrontPage.Editor.Document">
| <title>MTPS FY09 Form</title>
| </head>
|
| <body>
|
|
| <form method="POST" action="--WEBBOT-SELF--" language="JavaScript"
| name="FrontPage_Form1">
| <!--webbot bot="SaveDatabase" startspan SuggestedExt="asp"
| S-DataConnection="MTPSDailyFY09" S-RecordSource="MTPS"
| U-Database-URL="../fpdb/MTPS Daily FY09.mdb"
| U-Confirmation-Url="FY09Confirm.asp"
| S-Form-Fields="ClinicianID PsychiatricMedDoseSched02 PsychiatricMedDose01
| InterventionStrategy23 InterventionStrategy34 InterventionStrategy45
| InterventionStrategy58_Other InterventionStrategy57_Other
| InterventionStrategy56 InterventionStrategy12 InterventionStrategy01
| TargetCompletionDate05 TargetProgressRating03 AXIS1CODE2 EligStatus Comment1
| Discharge_LivingSit PsychiatricMedDoseSched03 PsychiatricMedDose02
| PsychiatricMedication01 InterventionStrategy24 InterventionStrategy35
| InterventionStrategy46 InterventionStrategy57 InterventionStrategy13
| InterventionStrategy02 TargetCompletionDate06 TargetProgressRating04
| AXIS1CODE3 FIRSTNAME Comment2 SupervisingClinicianID Projected_EndDate
| PsychiatricMedDoseSched04 PsychiatricMedDose03 PsychiatricMedication02
| PsychiatricMedChangeDesc01 InterventionStrategy36 InterventionStrategy47
| InterventionStrategy58 InterventionStrategy03 InterventionStrategy14
| InterventionStrategy25 TargetCompletionDate07 TargetProgressRating05 Comment3
| Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
| PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
| InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
| InterventionStrategy15 InterventionStrategy59 InterventionStrategy26 Target10
| TargetCompletionDate08 TargetProgressRating06 Comment4 PsychiatricMedDose05
| PsychiatricMedication04 PsychiatricMedChangeDesc03 InterventionStrategy49
| InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
| InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07 DOB
| Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
| InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
| InterventionStrategy39 TargetProgressRating08 Target01 Comment10 Comment6
| PsychiatricMedChangeDesc05 InterventionStrategy07 InterventionStrategy18
| InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
| ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19 Target03
| Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
| Target03_Other ServiceSetting Comment9 Target05_Other Target05
| InterventionStrategy60 Target07_Other Target06_Other Target06 Discharged
| PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
| TargetCompletionDate10 Target08_Other Target07 PrimaryDX LASTNAME
| PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
| InterventionStrategy40 Target10_Other Target09_Other Target08
| ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
| InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
| InterventionStrategy41 TargetProgressRating10 Target09 TargetCompletionDate01
| ServiceSetting_OtherDesc LOC MonthYear_ofServices PsychiatricMedChange04
| InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
| InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
| PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
| InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
| InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
| ServiceDate AXIS2CODE1 CR ProviderID PsychiatricMedDoseSched01
| InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
| InterventionStrategy33 InterventionStrategy44 InterventionStrategy56_Other
| InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
| AXIS2CODE2"
| S-Form-DBFields="ClinicianID PsychiatricMedDoseSched02
| PsychiatricMedDose01 InterventionStrategy23 InterventionStrategy34
| InterventionStrategy45 InterventionStrategy58_Other
| InterventionStrategy57_Other InterventionStrategy56 InterventionStrategy12
| InterventionStrategy01 TargetCompletionDate05 TargetProgressRating03
| AXIS1CODE2 EligStatus Comment1 Discharge_LivingSit PsychiatricMedDoseSched03
| PsychiatricMedDose02 PsychiatricMedication01 InterventionStrategy24
| InterventionStrategy35 InterventionStrategy46 InterventionStrategy57
| InterventionStrategy13 InterventionStrategy02 TargetCompletionDate06
| TargetProgressRating04 AXIS1CODE3 Client_FirstName Comment2
| SupervisingClinicianID Projected_EndDate PsychiatricMedDoseSched04
| PsychiatricMedDose03 PsychiatricMedication02 PsychiatricMedChangeDesc01
| InterventionStrategy36 InterventionStrategy47 InterventionStrategy58
| InterventionStrategy03 InterventionStrategy14 InterventionStrategy25
| TargetCompletionDate07 TargetProgressRating05 Comment3
| Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
| PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
| InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
| InterventionStrategy15 InterventionStrategy59 InterventionStrategy26 Target10
| TargetCompletionDate08 TargetProgressRating06 Comment4 PsychiatricMedDose05
| PsychiatricMedication04 PsychiatricMedChangeDesc03 InterventionStrategy49
| InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
| InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07 DOB
| Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
| InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
| InterventionStrategy39 TargetProgressRating08 Target01 Comment10 Comment6
| PsychiatricMedChangeDesc05 InterventionStrategy07 InterventionStrategy18
| InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
| ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19 Target03
| Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
| Target03_Other ServiceSetting Comment9 Target05_Other Target05
| InterventionStrategy60 Target07_Other Target06_Other Target06 Discharged
| PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
| TargetCompletionDate10 Target08_Other Target07 PrimaryDx Client_LastName
| PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
| InterventionStrategy40 Target10_Other Target09_Other Target08
| ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
| InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
| InterventionStrategy41 TargetProgressRating10 Target09 TargetCompletionDate01
| ServiceSetting_OtherDesc LOC MonthYear_ofServices PsychiatricMedChange04
| InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
| InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
| PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
| InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
| InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
| ServiceDate AXIS2CODE1 CR_No AddID PsychiatricMedDoseSched01
| InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
| InterventionStrategy33 InterventionStrategy44 InterventionStrategy56_Other
| InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
| AXIS2CODE2"
| U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden"
| NAME="VTI-GROUP" VALUE="0"><!--#include
| file="../_fpclass/fpdbform.inc"--><!--webbot
| bot="SaveDatabase" endspan -->
| <%
| fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| CR = ::CR::)"
| fp_sDefault="LOGON_USER=&CR="
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="LastMTPSDate"
| fp_sMenuValue="LastMTPSDate"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=30
| fp_iRegion=BOTID
| %>
| <!--webbot bot="DatabaseRegionStart" i-CheckSum="23913" endspan -->
| <select NAME="LastMTPSDate" SIZE="1">
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
| file="../_fpclass/fpdbrgn1.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52766" endspan -->
| <option><%=FP_FieldHTML(fp_rs,"LastMTPSDate")%></option>
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
| file="../_fpclass/fpdbrgn2.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52830" endspan -->
| </select><!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
| b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
| clientside
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> " --><!--webbot
| bot="DatabaseRegionEnd" endspan -->
| <br>
| Last MTPS LOC:<!--webbot bot="DatabaseRegionStart" startspan
|
|
s-columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
| s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
| s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE" b-menuformat="TRUE"
| s-menuchoice="LastMTPSLOC" s-menuvalue="LastMTPSLOC" b-tableborder="TRUE"
| b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
| b-listseparator="TRUE" i-ListFormat="0" b-makeform="FALSE" s-recordsource
| s-displaycolumns="LastMTPSLOC" s-criteria s-order
| s-sql="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| CR = ::CR::)"
| b-procedure="FALSE" clientside SuggestedExt="asp"
| s-DefaultFields="LOGON_USER=&CR=" s-NoRecordsFound="No records returned."
| i-MaxRecords="256" i-GroupSize="0" BOTID="32"
| u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc"
| u-dbrgn2="../_fpclass/fpdbrgn2.inc"
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> " --><!--#include
| file="../_fpclass/fpdblib.inc"-->
| <%
| fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| CR = ::CR::)"
| fp_sDefault="LOGON_USER=&CR="
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="LastMTPSLOC"
| fp_sMenuValue="LastMTPSLOC"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=32
| fp_iRegion=BOTID
Click to expand...
 
S

Stefan B Rusynko

Yes
- the script check all checkboxes in the form

IMHO
your approach for 31 checkboxes for 31 days is cumbersome at best
- consider using an alternate where the enter up to x dates in textboxes


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi,
|
| Thanks for the help. I made the changes you recommended and the check
| still does not work. Would having other checkboxes in the form make a
| difference? I have another area of the form with checkboxes?
|
| "Stefan B Rusynko" wrote:
|
| > All your ASP & Html code is not relevant to your question except the table with the 31 service date check boxes
| >
| > 1) All of your check box fields must have unique field names, yours are the same
| > (ServiceDate1 thru ServiceDate31)
| > 2) There is no valid parameter named multiple for a check box field
| > (multiple only applies to dropdown boxes)
| > 3) You can not use FP Form field validation in conjunction with Javascript validation
| > (remove all FP form field validation)
| > 4) And the cell width of 604 for each check box should be removed
| > (it is an error)
| >
| > So where you have say
| > <td width="604" height="44" align="center">1st</td>
| > <td width="604" height="44" align="center"><input type="checkbox" name="ServiceDate" multiple value="1"></td>
| > <td width="604" height="44" align="center">2nd</td>
| > <td width="604" height="44" align="center"><input type="checkbox" name="ServiceDate" multiple value="2"></td>
| > .... and so on
| > You should have
| > <td height="44" align="center">1st</td>
| > <td height="44" align="center"><input type="checkbox" name="ServiceDate1"value="1"></td>
| > <td height="44" align="center">2nd</td>
| > <td height="44" align="center"><input type="checkbox" name="ServiceDate2"value="2"></td>
| >
| > .... and so on
| >
| > Then use the following in the head section of your page to check if at least 1 box is checked in the form
| >
| > <script type="text/javascript" language="JavaScript">
| > var NoDateMsg = 'WARNING: NO SERVICE DATES WERE SELECTED -' + '\n' + '\n'
| > + 'You have Not Selected any Service Dates!' + '\n'
| > + 'SELECT "Cancel" to Enter one Correctly!' + '\n' + '\n';
| > function validateValues(frmName) {
| > var valid = true; var checkBoxes = false; var checkboxChecked = false;
| > for (var i=0, j=frmName.elements.length; i<j; i++) { fldType = frmName.elements.type;
| > if (fldType == 'checkbox') { checkBoxes = true; if (frmName.elements.checked) { checkboxChecked = true; } }
| > }
| > if ((checkBoxes && !checkboxChecked)) { valid = false; if (!valid) { if (confirm( NoDateMsg )) {return true;} else {
history.go(0);
| > return false;}; } }
| > }
| > </script>
| > and change your form tag to cal teh above vaidation script as
| >
| > <form method="POST" action="--WEBBOT-SELF--" name="FrontPage_Form1" onSubmit="return validateValues(document.FrontPage_Form1)">
| >
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Hi,
| > |
| > | I am trying to insert a function to validate that at least one checkbox
| > | is checked. I have tried to do this on a separate page and it worked fine,
| > | but when I tried to do this on the page that I want checked, the check does
| > | not work. I am trying to update a page that I did not create and am not very
| > | familiar with front page. Any help would be greatly appreciated.
| > |
| > | This is what I used on the test page:
| > |
| > | <script language="JavaScript" type="text/javascript">
| > | <!--
| > |
| > | function Validate(){
| > | // require that at least one checkbox be checked
| > | var checkSelected = false;
| > | for (var i = 0; i < document.Page3.ServiceDate.length; i++){
| > | if(Page3.ServiceDate.checked)
| > | checkSelected = true;
| > | }
| > | if(!checkSelected){
| > | alert("Please select at least 1 Service Date");
| > | return (false);
| > | }
| > | return true
| > | }
| > | //-->
| > |
| > | And this is the page that it did not work in. I inserted the above into the
| > | <head> section of the document and placed "onsubmit="return Validate();"" in
| > | the body section. I also had to remove most of the code for it to fit into
| > | this post:
| > |
| > | <%
| > | provider_id = Request.ServerVariables ("LOGON_USER")
| > | provider_id = UCASE(provider_id)
| > | session("provider_id") = provider_id
| > | %>
| > |
| > | <html>
| > |
| > | <head>
| > |
| > | <script language="javascript" type="text/javascript" src="datetimepicker.js">
| > |
| > | //Date Time Picker script- by TengYong Ng of http://www.rainforestnet.com
| > | //Script featured on JavaScript Kit (http://www.javascriptkit.com)
| > | //For this script, visit http://www.javascriptkit.com
| > |
| > | </script>
| > |
| > | <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
| > | <meta name="ProgId" content="FrontPage.Editor.Document">
| > | <title>MTPS FY09 Form</title>
| > | </head>
| > |
| > | <body>
| > |
| > |
| > | <form method="POST" action="--WEBBOT-SELF--" language="JavaScript"
| > | name="FrontPage_Form1">
| > | <!--webbot bot="SaveDatabase" startspan SuggestedExt="asp"
| > | S-DataConnection="MTPSDailyFY09" S-RecordSource="MTPS"
| > | U-Database-URL="../fpdb/MTPS Daily FY09.mdb"
| > | U-Confirmation-Url="FY09Confirm.asp"
| > | S-Form-Fields="ClinicianID PsychiatricMedDoseSched02 PsychiatricMedDose01
| > | InterventionStrategy23 InterventionStrategy34 InterventionStrategy45
| > | InterventionStrategy58_Other InterventionStrategy57_Other
| > | InterventionStrategy56 InterventionStrategy12 InterventionStrategy01
| > | TargetCompletionDate05 TargetProgressRating03 AXIS1CODE2 EligStatus Comment1
| > | Discharge_LivingSit PsychiatricMedDoseSched03 PsychiatricMedDose02
| > | PsychiatricMedication01 InterventionStrategy24 InterventionStrategy35
| > | InterventionStrategy46 InterventionStrategy57 InterventionStrategy13
| > | InterventionStrategy02 TargetCompletionDate06 TargetProgressRating04
| > | AXIS1CODE3 FIRSTNAME Comment2 SupervisingClinicianID Projected_EndDate
| > | PsychiatricMedDoseSched04 PsychiatricMedDose03 PsychiatricMedication02
| > | PsychiatricMedChangeDesc01 InterventionStrategy36 InterventionStrategy47
| > | InterventionStrategy58 InterventionStrategy03 InterventionStrategy14
| > | InterventionStrategy25 TargetCompletionDate07 TargetProgressRating05 Comment3
| > | Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
| > | PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
| > | InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
| > | InterventionStrategy15 InterventionStrategy59 InterventionStrategy26 Target10
| > | TargetCompletionDate08 TargetProgressRating06 Comment4 PsychiatricMedDose05
| > | PsychiatricMedication04 PsychiatricMedChangeDesc03 InterventionStrategy49
| > | InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
| > | InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07 DOB
| > | Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
| > | InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
| > | InterventionStrategy39 TargetProgressRating08 Target01 Comment10 Comment6
| > | PsychiatricMedChangeDesc05 InterventionStrategy07 InterventionStrategy18
| > | InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
| > | ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19 Target03
| > | Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
| > | Target03_Other ServiceSetting Comment9 Target05_Other Target05
| > | InterventionStrategy60 Target07_Other Target06_Other Target06 Discharged
| > | PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
| > | TargetCompletionDate10 Target08_Other Target07 PrimaryDX LASTNAME
| > | PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
| > | InterventionStrategy40 Target10_Other Target09_Other Target08
| > | ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
| > | InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
| > | InterventionStrategy41 TargetProgressRating10 Target09 TargetCompletionDate01
| > | ServiceSetting_OtherDesc LOC MonthYear_ofServices PsychiatricMedChange04
| > | InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
| > | InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
| > | PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
| > | InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
| > | InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
| > | ServiceDate AXIS2CODE1 CR ProviderID PsychiatricMedDoseSched01
| > | InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
| > | InterventionStrategy33 InterventionStrategy44 InterventionStrategy56_Other
| > | InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
| > | AXIS2CODE2"
| > | S-Form-DBFields="ClinicianID PsychiatricMedDoseSched02
| > | PsychiatricMedDose01 InterventionStrategy23 InterventionStrategy34
| > | InterventionStrategy45 InterventionStrategy58_Other
| > | InterventionStrategy57_Other InterventionStrategy56 InterventionStrategy12
| > | InterventionStrategy01 TargetCompletionDate05 TargetProgressRating03
| > | AXIS1CODE2 EligStatus Comment1 Discharge_LivingSit PsychiatricMedDoseSched03
| > | PsychiatricMedDose02 PsychiatricMedication01 InterventionStrategy24
| > | InterventionStrategy35 InterventionStrategy46 InterventionStrategy57
| > | InterventionStrategy13 InterventionStrategy02 TargetCompletionDate06
| > | TargetProgressRating04 AXIS1CODE3 Client_FirstName Comment2
| > | SupervisingClinicianID Projected_EndDate PsychiatricMedDoseSched04
| > | PsychiatricMedDose03 PsychiatricMedication02 PsychiatricMedChangeDesc01
| > | InterventionStrategy36 InterventionStrategy47 InterventionStrategy58
| > | InterventionStrategy03 InterventionStrategy14 InterventionStrategy25
| > | TargetCompletionDate07 TargetProgressRating05 Comment3
| > | Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
| > | PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
| > | InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
| > | InterventionStrategy15 InterventionStrategy59 InterventionStrategy26 Target10
| > | TargetCompletionDate08 TargetProgressRating06 Comment4 PsychiatricMedDose05
| > | PsychiatricMedication04 PsychiatricMedChangeDesc03 InterventionStrategy49
| > | InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
| > | InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07 DOB
| > | Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
| > | InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
| > | InterventionStrategy39 TargetProgressRating08 Target01 Comment10 Comment6
| > | PsychiatricMedChangeDesc05 InterventionStrategy07 InterventionStrategy18
| > | InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
| > | ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19 Target03
| > | Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
| > | Target03_Other ServiceSetting Comment9 Target05_Other Target05
| > | InterventionStrategy60 Target07_Other Target06_Other Target06 Discharged
| > | PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
| > | TargetCompletionDate10 Target08_Other Target07 PrimaryDx Client_LastName
| > | PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
| > | InterventionStrategy40 Target10_Other Target09_Other Target08
| > | ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
| > | InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
| > | InterventionStrategy41 TargetProgressRating10 Target09 TargetCompletionDate01
| > | ServiceSetting_OtherDesc LOC MonthYear_ofServices PsychiatricMedChange04
| > | InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
| > | InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
| > | PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
| > | InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
| > | InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
| > | ServiceDate AXIS2CODE1 CR_No AddID PsychiatricMedDoseSched01
| > | InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
| > | InterventionStrategy33 InterventionStrategy44 InterventionStrategy56_Other
| > | InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
| > | AXIS2CODE2"
| > | U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden"
| > | NAME="VTI-GROUP" VALUE="0"><!--#include
| > | file="../_fpclass/fpdbform.inc"--><!--webbot
| > | bot="SaveDatabase" endspan -->
| > | <%
| > | fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| > | CR = ::CR::)"
| > | fp_sDefault="LOGON_USER=&CR="
| > | fp_sNoRecords="No records returned."
| > | fp_sDataConn="MTPSDailyFY09"
| > | fp_iMaxRecords=256
| > | fp_iCommandType=1
| > | fp_iPageSize=0
| > | fp_fTableFormat=False
| > | fp_fMenuFormat=True
| > | fp_sMenuChoice="LastMTPSDate"
| > | fp_sMenuValue="LastMTPSDate"
| > | fp_iDisplayCols=1
| > | fp_fCustomQuery=True
| > | BOTID=30
| > | fp_iRegion=BOTID
| > | %>
| > | <!--webbot bot="DatabaseRegionStart" i-CheckSum="23913" endspan -->
| > | <select NAME="LastMTPSDate" SIZE="1">
| > | <!--webbot bot="AspInclude" startspan CLIENTSIDE
| > | U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
| > | file="../_fpclass/fpdbrgn1.inc"--><!--webbot
| > | bot="AspInclude" i-CheckSum="52766" endspan -->
| > | <option><%=FP_FieldHTML(fp_rs,"LastMTPSDate")%></option>
| > | <!--webbot bot="AspInclude" startspan CLIENTSIDE
| > | U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
| > | file="../_fpclass/fpdbrgn2.inc"--><!--webbot
| > | bot="AspInclude" i-CheckSum="52830" endspan -->
| > | </select><!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
| > | b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
| > | clientside
| > | local_preview=" <span style="color: rgb(0,0,0); background-color:
| > | rgb(255,255,0)">Results</span> "
| > | preview=" <span style="color: rgb(0,0,0); background-color:
| > | rgb(255,255,0)">Results</span> " --><!--webbot
| > | bot="DatabaseRegionEnd" endspan -->
| > | <br>
| > | Last MTPS LOC:<!--webbot bot="DatabaseRegionStart" startspan
| > |
| > |
| >
s-columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
| > | s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
| > | s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE" b-menuformat="TRUE"
| > | s-menuchoice="LastMTPSLOC" s-menuvalue="LastMTPSLOC" b-tableborder="TRUE"
| > | b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
| > | b-listseparator="TRUE" i-ListFormat="0" b-makeform="FALSE" s-recordsource
| > | s-displaycolumns="LastMTPSLOC" s-criteria s-order
| > | s-sql="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| > | CR = ::CR::)"
| > | b-procedure="FALSE" clientside SuggestedExt="asp"
| > | s-DefaultFields="LOGON_USER=&CR=" s-NoRecordsFound="No records returned."
| > | i-MaxRecords="256" i-GroupSize="0" BOTID="32"
| > | u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc"
| > | u-dbrgn2="../_fpclass/fpdbrgn2.inc"
| > | local_preview=" <span style="color: rgb(0,0,0); background-color:
| > | rgb(255,255,0)">Database</span> "
| > | preview=" <span style="color: rgb(0,0,0); background-color:
| > | rgb(255,255,0)">Database</span> " --><!--#include
| > | file="../_fpclass/fpdblib.inc"-->
| > | <%
| > | fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::' AND
| > | CR = ::CR::)"
| > | fp_sDefault="LOGON_USER=&CR="
| > | fp_sNoRecords="No records returned."
| > | fp_sDataConn="MTPSDailyFY09"
| > | fp_iMaxRecords=256
| > | fp_iCommandType=1
| > | fp_iPageSize=0
| > | fp_fTableFormat=False
| > | fp_fMenuFormat=True
| > | fp_sMenuChoice="LastMTPSLOC"
| > | fp_sMenuValue="LastMTPSLOC"
| > | fp_iDisplayCols=1
| > | fp_fCustomQuery=True
| > | BOTID=32
| > | fp_iRegion=BOTID
 
J

Jon Spivey

Hi,
you might be better naming the checkboxes you want to check with a unique
prefix, eg ServiceBox1, ServiceBox2 etc then you can just check at least 1
of the boxes with that prefix has been checked, this should stop other
checkboxes in the form interfering with your script, eg

<script type="text/javascript">
function checkForm(f){
var ok=false,f1=f.elements;
for(x=0;x<f1.length;x++){
if(f1(x).name.substr(0,10)=='ServiceBox' && f1(x).checked){ok=true;break;}}
if(!ok){alert('error message');return false;}return true;
}
</script>
<form onsubmit="return checkForm(this);">
<input type="checkbox" name="ServiceBox1" />
<input type="checkbox" name="ServiceBox2" />
etc.....

Cheers,
Jon


nadesico said:
Hi,

Thanks for the help. I made the changes you recommended and the check
still does not work. Would having other checkboxes in the form make a
difference? I have another area of the form with checkboxes?

Stefan B Rusynko said:
All your ASP & Html code is not relevant to your question except the
table with the 31 service date check boxes

1) All of your check box fields must have unique field names, yours are
the same
(ServiceDate1 thru ServiceDate31)
2) There is no valid parameter named multiple for a check box field
(multiple only applies to dropdown boxes)
3) You can not use FP Form field validation in conjunction with
Javascript validation
(remove all FP form field validation)
4) And the cell width of 604 for each check box should be removed
(it is an error)

So where you have say
<td width="604" height="44" align="center">1st</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="1"></td>
<td width="604" height="44" align="center">2nd</td>
<td width="604" height="44" align="center"><input type="checkbox"
name="ServiceDate" multiple value="2"></td>
.... and so on
You should have
<td height="44" align="center">1st</td>
<td height="44" align="center"><input type="checkbox"
name="ServiceDate1"value="1"></td>
<td height="44" align="center">2nd</td>
<td height="44" align="center"><input type="checkbox"
name="ServiceDate2"value="2"></td>

.... and so on

Then use the following in the head section of your page to check if at
least 1 box is checked in the form

<script type="text/javascript" language="JavaScript">
var NoDateMsg = 'WARNING: NO SERVICE DATES WERE SELECTED -' + '\n' + '\n'
+ 'You have Not Selected any Service Dates!' + '\n'
+ 'SELECT "Cancel" to Enter one Correctly!' + '\n' + '\n';
function validateValues(frmName) {
var valid = true; var checkBoxes = false; var checkboxChecked = false;
for (var i=0, j=frmName.elements.length; i<j; i++) { fldType =
frmName.elements.type;
if (fldType == 'checkbox') { checkBoxes = true; if
(frmName.elements.checked) { checkboxChecked = true; } }
}
if ((checkBoxes && !checkboxChecked)) { valid = false; if (!valid) { if
(confirm( NoDateMsg )) {return true;} else { history.go(0);
return false;}; } }
}
</script>
and change your form tag to cal teh above vaidation script as

<form method="POST" action="--WEBBOT-SELF--" name="FrontPage_Form1"
onSubmit="return validateValues(document.FrontPage_Form1)">


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi,
|
| I am trying to insert a function to validate that at least one
checkbox
| is checked. I have tried to do this on a separate page and it worked
fine,
| but when I tried to do this on the page that I want checked, the check
does
| not work. I am trying to update a page that I did not create and am
not very
| familiar with front page. Any help would be greatly appreciated.
|
| This is what I used on the test page:
|
| <script language="JavaScript" type="text/javascript">
| <!--
|
| function Validate(){
| // require that at least one checkbox be checked
| var checkSelected = false;
| for (var i = 0; i < document.Page3.ServiceDate.length; i++){
| if(Page3.ServiceDate.checked)
| checkSelected = true;
| }
| if(!checkSelected){
| alert("Please select at least 1 Service Date");
| return (false);
| }
| return true
| }
| //-->
|
| And this is the page that it did not work in. I inserted the above
into the
| <head> section of the document and placed "onsubmit="return
Validate();"" in
| the body section. I also had to remove most of the code for it to fit
into
| this post:
|
| <%
| provider_id = Request.ServerVariables ("LOGON_USER")
| provider_id = UCASE(provider_id)
| session("provider_id") = provider_id
| %>
|
| <html>
|
| <head>
|
| <script language="javascript" type="text/javascript"
src="datetimepicker.js">
|
| //Date Time Picker script- by TengYong Ng of
http://www.rainforestnet.com
| //Script featured on JavaScript Kit (http://www.javascriptkit.com)
| //For this script, visit http://www.javascriptkit.com
|
| </script>
|
| <meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
| <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
| <meta name="ProgId" content="FrontPage.Editor.Document">
| <title>MTPS FY09 Form</title>
| </head>
|
| <body>
|
|
| <form method="POST" action="--WEBBOT-SELF--" language="JavaScript"
| name="FrontPage_Form1">
| <!--webbot bot="SaveDatabase" startspan SuggestedExt="asp"
| S-DataConnection="MTPSDailyFY09" S-RecordSource="MTPS"
| U-Database-URL="../fpdb/MTPS Daily FY09.mdb"
| U-Confirmation-Url="FY09Confirm.asp"
| S-Form-Fields="ClinicianID PsychiatricMedDoseSched02
PsychiatricMedDose01
| InterventionStrategy23 InterventionStrategy34 InterventionStrategy45
| InterventionStrategy58_Other InterventionStrategy57_Other
| InterventionStrategy56 InterventionStrategy12 InterventionStrategy01
| TargetCompletionDate05 TargetProgressRating03 AXIS1CODE2 EligStatus
Comment1
| Discharge_LivingSit PsychiatricMedDoseSched03 PsychiatricMedDose02
| PsychiatricMedication01 InterventionStrategy24 InterventionStrategy35
| InterventionStrategy46 InterventionStrategy57 InterventionStrategy13
| InterventionStrategy02 TargetCompletionDate06 TargetProgressRating04
| AXIS1CODE3 FIRSTNAME Comment2 SupervisingClinicianID Projected_EndDate
| PsychiatricMedDoseSched04 PsychiatricMedDose03 PsychiatricMedication02
| PsychiatricMedChangeDesc01 InterventionStrategy36
InterventionStrategy47
| InterventionStrategy58 InterventionStrategy03 InterventionStrategy14
| InterventionStrategy25 TargetCompletionDate07 TargetProgressRating05
Comment3
| Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
| PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
| InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
| InterventionStrategy15 InterventionStrategy59 InterventionStrategy26
Target10
| TargetCompletionDate08 TargetProgressRating06 Comment4
PsychiatricMedDose05
| PsychiatricMedication04 PsychiatricMedChangeDesc03
InterventionStrategy49
| InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
| InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07
DOB
| Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
| InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
| InterventionStrategy39 TargetProgressRating08 Target01 Comment10
Comment6
| PsychiatricMedChangeDesc05 InterventionStrategy07
InterventionStrategy18
| InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
| ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19
Target03
| Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
| Target03_Other ServiceSetting Comment9 Target05_Other Target05
| InterventionStrategy60 Target07_Other Target06_Other Target06
Discharged
| PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
| TargetCompletionDate10 Target08_Other Target07 PrimaryDX LASTNAME
| PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
| InterventionStrategy40 Target10_Other Target09_Other Target08
| ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
| InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
| InterventionStrategy41 TargetProgressRating10 Target09
TargetCompletionDate01
| ServiceSetting_OtherDesc LOC MonthYear_ofServices
PsychiatricMedChange04
| InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
| InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
| PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
| InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
| InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
| ServiceDate AXIS2CODE1 CR ProviderID PsychiatricMedDoseSched01
| InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
| InterventionStrategy33 InterventionStrategy44
InterventionStrategy56_Other
| InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
| AXIS2CODE2"
| S-Form-DBFields="ClinicianID PsychiatricMedDoseSched02
| PsychiatricMedDose01 InterventionStrategy23 InterventionStrategy34
| InterventionStrategy45 InterventionStrategy58_Other
| InterventionStrategy57_Other InterventionStrategy56
InterventionStrategy12
| InterventionStrategy01 TargetCompletionDate05 TargetProgressRating03
| AXIS1CODE2 EligStatus Comment1 Discharge_LivingSit
PsychiatricMedDoseSched03
| PsychiatricMedDose02 PsychiatricMedication01 InterventionStrategy24
| InterventionStrategy35 InterventionStrategy46 InterventionStrategy57
| InterventionStrategy13 InterventionStrategy02 TargetCompletionDate06
| TargetProgressRating04 AXIS1CODE3 Client_FirstName Comment2
| SupervisingClinicianID Projected_EndDate PsychiatricMedDoseSched04
| PsychiatricMedDose03 PsychiatricMedication02 PsychiatricMedChangeDesc01
| InterventionStrategy36 InterventionStrategy47 InterventionStrategy58
| InterventionStrategy03 InterventionStrategy14 InterventionStrategy25
| TargetCompletionDate07 TargetProgressRating05 Comment3
| Discharge_LivingSit_Other DischargeMonth PsychiatricMedDoseSched05
| PsychiatricMedDose04 PsychiatricMedication03 PsychiatricMedChangeDesc02
| InterventionStrategy37 InterventionStrategy48 InterventionStrategy04
| InterventionStrategy15 InterventionStrategy59 InterventionStrategy26
Target10
| TargetCompletionDate08 TargetProgressRating06 Comment4
PsychiatricMedDose05
| PsychiatricMedication04 PsychiatricMedChangeDesc03
InterventionStrategy49
| InterventionStrategy05 InterventionStrategy16 InterventionStrategy27
| InterventionStrategy38 TargetCompletionDate09 TargetProgressRating07
DOB
| Comment5 PsychiatricMedication05 PsychiatricMedChangeDesc04
| InterventionStrategy06 InterventionStrategy17 InterventionStrategy28
| InterventionStrategy39 TargetProgressRating08 Target01 Comment10
Comment6
| PsychiatricMedChangeDesc05 InterventionStrategy07
InterventionStrategy18
| InterventionStrategy29 TargetProgressRating09 Target02 Target01_Other
| ServiceFormat Comment7 InterventionStrategy08 InterventionStrategy19
Target03
| Target02_Other Comment8 InterventionStrategy09 Target04_Other Target04
| Target03_Other ServiceSetting Comment9 Target05_Other Target05
| InterventionStrategy60 Target07_Other Target06_Other Target06
Discharged
| PsychiatricMedChange01 InterventionStrategy50 InterventionStrategy61
| TargetCompletionDate10 Target08_Other Target07 PrimaryDx
Client_LastName
| PsychiatricMedChange02 InterventionStrategy51 InterventionStrategy62
| InterventionStrategy40 Target10_Other Target09_Other Target08
| ServiceFormat_OtherDesc Discharged_OtherDesc PsychiatricMedChange03
| InterventionStrategy52 InterventionStrategy63 InterventionStrategy30
| InterventionStrategy41 TargetProgressRating10 Target09
TargetCompletionDate01
| ServiceSetting_OtherDesc LOC MonthYear_ofServices
PsychiatricMedChange04
| InterventionStrategy64 InterventionStrategy20 InterventionStrategy31
| InterventionStrategy42 InterventionStrategy53 TargetCompletionDate02
| PsychiatricMedChange05 InterventionStrategy10 InterventionStrategy65
| InterventionStrategy21 InterventionStrategy32 InterventionStrategy43
| InterventionStrategy54 TargetCompletionDate03 TargetProgressRating01
| ServiceDate AXIS2CODE1 CR_No AddID PsychiatricMedDoseSched01
| InterventionStrategy11 InterventionStrategy66 InterventionStrategy22
| InterventionStrategy33 InterventionStrategy44
InterventionStrategy56_Other
| InterventionStrategy55 TargetCompletionDate04 TargetProgressRating02
| AXIS2CODE2"
| U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden"
| NAME="VTI-GROUP" VALUE="0"><!--#include
| file="../_fpclass/fpdbform.inc"--><!--webbot
| bot="SaveDatabase" endspan -->
| <%
| fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID =
'::LOGON_USER::' AND
| CR = ::CR::)"
| fp_sDefault="LOGON_USER=&CR="
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="LastMTPSDate"
| fp_sMenuValue="LastMTPSDate"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=30
| fp_iRegion=BOTID
| %>
| <!--webbot bot="DatabaseRegionStart" i-CheckSum="23913" endspan -->
| <select NAME="LastMTPSDate" SIZE="1">
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn1.inc" --><!--#include
| file="../_fpclass/fpdbrgn1.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52766" endspan -->
| <option><%=FP_FieldHTML(fp_rs,"LastMTPSDate")%></option>
| <!--webbot bot="AspInclude" startspan CLIENTSIDE
| U-INCFILE="../_fpclass/fpdbrgn2.inc" --><!--#include
| file="../_fpclass/fpdbrgn2.inc"--><!--webbot
| bot="AspInclude" i-CheckSum="52830" endspan -->
| </select><!--webbot bot="DatabaseRegionEnd" startspan
b-tableformat="FALSE"
| b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc"
i-groupsize="0"
| clientside
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Results</span> " --><!--webbot
| bot="DatabaseRegionEnd" endspan -->
| <br>
| Last MTPS LOC:<!--webbot bot="DatabaseRegionStart" startspan
|
|
s-columnnames="ProviderID,Login,CR,LASTNAME,FIRSTNAME,DOB,LastMTPSDate,LastMTPSPeriod,PrimaryDX,LastMTPSLOC,AXIS1CODE2,AXIS1CODE3,AXIS2CODE1,AXIS2CODE2"
| s-columntypes="202,202,5,202,202,135,202,202,202,202,202,202,202,202"
| s-dataconnection="MTPSDailyFY09" b-tableformat="FALSE"
b-menuformat="TRUE"
| s-menuchoice="LastMTPSLOC" s-menuvalue="LastMTPSLOC"
b-tableborder="TRUE"
| b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
| b-listseparator="TRUE" i-ListFormat="0" b-makeform="FALSE"
s-recordsource
| s-displaycolumns="LastMTPSLOC" s-criteria s-order
| s-sql="SELECT * FROM ClientRegis WHERE (ProviderID = '::LOGON_USER::'
AND
| CR = ::CR::)"
| b-procedure="FALSE" clientside SuggestedExt="asp"
| s-DefaultFields="LOGON_USER=&CR=" s-NoRecordsFound="No records
returned."
| i-MaxRecords="256" i-GroupSize="0" BOTID="32"
| u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc"
| u-dbrgn2="../_fpclass/fpdbrgn2.inc"
| local_preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> "
| preview=" <span style="color: rgb(0,0,0); background-color:
| rgb(255,255,0)">Database</span> " --><!--#include
| file="../_fpclass/fpdblib.inc"-->
| <%
| fp_sQry="SELECT * FROM ClientRegis WHERE (ProviderID =
'::LOGON_USER::' AND
| CR = ::CR::)"
| fp_sDefault="LOGON_USER=&CR="
| fp_sNoRecords="No records returned."
| fp_sDataConn="MTPSDailyFY09"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=True
| fp_sMenuChoice="LastMTPSLOC"
| fp_sMenuValue="LastMTPSLOC"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=32
| fp_iRegion=BOTID
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Grouping 2
Can one include data from javascript in form 1
Error message "An error has occured in the script on this page" 1
Database table add record form w/DD - not working 3
second page 1
help with script 0
Frontpage removes javascript after save 6
Checking For Null 0

Top