Checkbox in Form from DRW

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Checkbox in Form from DRW

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Checkbox in Form from DRW

Page: [1]


truwebs Posts: 80 Joined: 7/10/2006 Status: offline	Checkbox in Form from DRW - 8/28/2006 22:17:28 hello, I have a form that queries a table from my ms database. I have a checkbox next to each item. The user will have the opportunity to check up to 100 check boxes. When somebody checks the box I need that information that is next to the check box (data brought up in form) submitted to another table. How do I make the check box submit the information from the original DRW query?


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Checkbox in Form from DRW - 8/29/2006 1:19:22 One way would be to make the name of the checkboxes the same (for instance 'ItemID') and the values of the checkbox being the PrimaryKey ID of the record (again for instance 'ItemID'). Then when you Request.Form("ItemID") (or with a DRW ::ItemID::) then you would be recieving a comma-delimited list of ID's that you can then manipulate using IN or separating into an array or other things. Does that make any sense? To me it's kinda' difficult using the DRW but easier without it. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to truwebs)

truwebs

Posts: 80
Joined: 7/10/2006
Status: offline

RE: Checkbox in Form from DRW - 8/29/2006 1:39:12

Some sample code would help me understand better.

quote:

ORIGINAL: rdouglass

One way would be to make the name of the checkboxes the same (for instance 'ItemID') and the values of the checkbox being the PrimaryKey ID of the record (again for instance 'ItemID').

Then when you Request.Form("ItemID") (or with a DRW ::ItemID::) then you would be recieving a comma-delimited list of ID's that you can then manipulate using IN or separating into an array or other things.

Does that make any sense?

To me it's kinda' difficult using the DRW but easier without it.

quote:

again for instance 'ItemID'

(in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Checkbox in Form from DRW - 8/29/2006 1:43:08 quote: Some sample code would help me understand better. Me too. SHow me what you have first and I'll try to post something relevant. I don't really want to post 5 examples hoping to be 'close'. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to truwebs)

truwebs

Posts: 80
Joined: 7/10/2006
Status: offline

RE: Checkbox in Form from DRW - 8/29/2006 7:47:13

Here is a short version of the desired form.

<form method="POST" action="--WEBBOT-SELF--">
	<!--webbot bot="SaveResults" U-File="_private/form_results.csv" S-Format="TEXT/CSV" S-Label-Fields="TRUE" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--webbot bot="SaveResults" i-checksum="43374" endspan -->
	<p align="center"><b><font face="Verdana" size="4">TEST</font></b></p>
	<p><font face="Verdana"><b>Choose Standards</b></font></p>
	<table>
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,sStandard,sDescription" s-columntypes="3,202,202" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Standards" s-displaycolumns="ID,sDescription" s-criteria s-order="[sStandard] +" s-sql="SELECT * FROM Standards ORDER BY sStandard ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Standards ORDER BY sStandard ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&sStandard=202&sDescription=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="53428" --><tr>
				<td>
				<input type="checkbox" name="C1" value="ON"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,sStandard,sDescription" s-column="sDescription" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>sDescription<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"sDescription")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30343" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<p><font face="Verdana"><b>Choose Benchmarks and Indicators</b></font></p>
	<p><font face="Verdana">Standard 1</font></p>
	<table>
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 1  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  1)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="1" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  1)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="47041" --><tr>
				<td>
				<input type="checkbox" name="C2" value="ON"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xBenchmarks" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xBenchmarks<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"xBenchmarks")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28293" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<blockquote>
		<p><font face="Verdana" size="2">Test Indicators</font></p>
		<table id="table7">
			<tbody>
				<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 1  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  1)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="8" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  1)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=8
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="47097" --><tr>
					<td>
				<input type="checkbox" name="C3" value="ON"></td>
					<td><font face="Verdana" size="2">
					<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xindicatorsk" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xindicatorsk<font size="-1">>></font>" startspan s-ColumnTypes="3,203,3,202,202,203,203" --><%=FP_FieldVal(fp_rs,"xindicatorsk")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36112" --></font></td>
				</tr>
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
		</table>
	</blockquote>
	<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

< Message edited by rdouglass -- 8/29/2006 9:11:23 >

(in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Checkbox in Form from DRW - 8/29/2006 9:19:33 quote: <input type="checkbox" name="C1" value="ON"> Right there is where I would make it happen. If you make your checkbox values look like this: <input type="checkbox" name="C1" value="<%=FP_FieldVal(fp_rs,"ID")%>"> (change the name of the column if it is not ID) this will aloow us to grab all the ID's of the first group when we Request.form("C1") or ::C1:: when using the DRW. That would return a list of ID's separated by commas like: 2,3,5,8 or whatever. Now you can do many things at this point. You can save all items in a single field in a database. You can separate them into an array to act on each one: <%myArray = split(Request.form("C1"),",") FOR i = 0 TO UBOUND(myArray,1) 'do this for each item NEXT%> At this point you now have ID's of all the 'checked' items from the form. You can do this with C2, C3, etc. That help any? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to truwebs)


truwebs Posts: 80 Joined: 7/10/2006 Status: offline	RE: Checkbox in Form from DRW - 8/29/2006 22:47:24 OK... I did do the following as you suggested. I changed the value to ID, but I do not think this is the direction I want to go as the ID numbers will do me no good. So, I gave it another value which does bring up the field content in the source of the page. This shows that I am on the right track. Right there is where I would make it happen. If you make your checkbox values look like this: <input type="checkbox" name="C1" value="<%=FP_FieldVal(fp_rs,"ID")%>"> Now is where I am confused. It seems like you are leading me to different options. What I would like to do is have all checked items be submitted to their own field in the db. So, I guess I use the Array code you have provided, but not sure where I place it. I have tried to place it and FP does not like it and removes it upon a save. Where are you leading me with "when we Request.form("C1") or ::C1::" this will aloow us to grab all the ID's of the first group when we Request.form("C1") or ::C1:: when using the DRW. That would return a list of ID's separated by commas like: 2,3,5,8 or whatever. Now you can do many things at this point. You can save all items in a single field in a database. You can separate them into an array to act on each one: <%myArray = split(Request.form("C1"),",") FOR i = 0 TO UBOUND(myArray,1) 'do this for each item NEXT%> At this point you now have ID's of all the 'checked' items from the form. You can do this with C2, C3, etc. That help any? quote: <%myArray = split(Request.form("C1"),",") FOR i = 0 TO UBOUND(myArray,1) 'do this for each item NEXT%> (in reply to rdouglass)

rdouglass

Posts: 9280
From: Biddeford, ME USA
Status: offline

RE: Checkbox in Form from DRW - 8/29/2006 23:14:48

quote:

as the ID numbers will do me no good.

What would you need? What value for the checkbox? To normalize the database, you'd usually use an ID for something like that.

quote:

What I would like to do is have all checked items be submitted to their own field in the db.

Please be very, very specific about what this means.

What field? Is it a related record to something else? is it 1 checkbox is 1 field? Or do you want all checkboxes be saved in 1 field? Soory to ask such bothersome questions but I just want to provide you with the right stuff.

what I *tried* to show is how you can collect *any* amount of checkbox data by naming all the checkboxes the same value.

You *can* give each checkbox a different name and check whether it is on or off but that leads you to a number of loops / iterations that shortly grows large and cumbersome. Change the checkbox names to support groupings if you need to.

By naming the checkboxes the same name, you can grab *all* checked boxes in 1 request.form call. That should be very significant if you want to know which checkboxes are checked. If you only have 1 or two, no problem and make the names different and check each one individually. But what if you have a lot and/or need to make changes to the list? Use a DB call and do it programmatically.

You can get *all* the values out the 'other side' by request.form the checkbox to get the full list then use SPLIT to separate the values. You're talking about a HUNDRED checkboxes! You *don't* want to check each one of those individually do you? I thought what I posted was exactly what you asked for; a easy way to check a large number of checkboxes.

I am just trying to show you the easiest method to grab the values in the least amount of code.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to truwebs)


truwebs Posts: 80 Joined: 7/10/2006 Status: offline	RE: Checkbox in Form from DRW - 8/30/2006 1:12:35 quote: ORIGINAL: rdouglass quote: as the ID numbers will do me no good. Instead of submitting the IDs back to a table I will actually be submitting the data that was pulled from a table that fed the form. Let me explain a little more... The form actually creates about 55 checkboxes with a sentence or phrase after the checkbox. A user will choose any where from 3 to 55 checkboxes. Probably never 55, but the possibility is there. User will choose up to 7 "Standards" User will choose up to 5 "Benchmarks" for possibly each of the 7 "Standards" User will choose up to 5 "Indicators" for each "Benchmark" Ideally I think I would like each checkbox of data submitted to it's own unique database field. So each checkbox would need its own unique name. So to answer your question I guess I want "1 checkbox is 1 field" But, as I work with this I see what you mean about "cumbersome". I might have to do groupings instead. I will post one of the forms so that you can see how much code is actually being generated. (in reply to rdouglass)

truwebs

Posts: 80
Joined: 7/10/2006
Status: offline

RE: Checkbox in Form from DRW - 8/30/2006 1:17:42

Here is one form. This is just part of my original which I have already broken down to smaller parts/forms. Getting too big or is it beyond the capabilities of the drw?

<form method="POST" action="--WEBBOT-SELF--">
	<!--webbot bot="SaveResults" U-File="_private/form_results.csv" S-Format="TEXT/CSV" S-Label-Fields="TRUE" startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--webbot bot="SaveResults" i-checksum="43374" endspan -->
	<p><font face="Verdana"><b>Choose Standards</b></font></p>
	<table>
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,sStandard,sDescription" s-columntypes="3,202,202" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Standards" s-displaycolumns="ID,sDescription" s-criteria s-order="[sStandard] +" s-sql="SELECT * FROM Standards ORDER BY sStandard ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Standards ORDER BY sStandard ASC"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&sStandard=202&sDescription=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="53428" --><tr>
				<td>
				<input type="checkbox" name="cStandards" value="<%=FP_FieldVal(fp_rs,"sDescription")%>"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,sStandard,sDescription" s-column="sDescription" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>sDescription<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"sDescription")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30343" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<p><font face="Verdana"><b>Choose Benchmarks and Indicators</b></font></p>
	<p><font face="Verdana">Standard 1</font></p>
	<table>
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 1  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  1)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="1" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  1)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="47041" --><tr>
				<td>
				<input type="checkbox" name="cBenchmarks1" value="<%=FP_FieldVal(fp_rs,"xBenchmarks")%>"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xBenchmarks" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xBenchmarks<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"xBenchmarks")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28293" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<blockquote>
		<p><font face="Verdana" size="2">Kindergarten Indicators</font></p>
		<table id="table7">
			<tbody>
				<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 1  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  1)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="8" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  1)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=8
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="47097" --><tr>
					<td>
					<input type="checkbox" name="cIndicators1" value="<%=FP_FieldVal(fp_rs,"xindicatorsk")%>"></td>
					<td><font face="Verdana" size="2">
					<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xindicatorsk" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xindicatorsk<font size="-1">>></font>" startspan s-ColumnTypes="3,203,3,202,202,203,203" --><%=FP_FieldVal(fp_rs,"xindicatorsk")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36112" --></font></td>
				</tr>
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
		</table>
	</blockquote>
	<p><font face="Verdana">Standard 2</font></p>
	<table id="table1">
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 2  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  2)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="2" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  2)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="48330" --><tr>
				<td>
				<input type="checkbox" name="cBenchmarks2" value="<%=FP_FieldVal(fp_rs,"xBenchmarks")%>"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xBenchmarks" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xBenchmarks<font size="-1">>></font>" startspan s-ColumnTypes="3,203,3,202,202,203,203" --><%=FP_FieldVal(fp_rs,"xBenchmarks")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28293" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<blockquote>
		<p><font face="Verdana" size="2">Kindergarten Indicators</font></p>
		<table id="table9">
			<tbody>
				<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 2  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  2)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="10" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  2)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=10
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="54999" --><tr>
					<td>
					<input type="checkbox" name="cIndicators2" value="<%=FP_FieldVal(fp_rs,"xindicatorsk")%>"></td>
					<td><font face="Verdana" size="2">
					<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xindicatorsk" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xindicatorsk<font size="-1">>></font>" startspan s-ColumnTypes="3,203,3,202,202,203,203" --><%=FP_FieldVal(fp_rs,"xindicatorsk")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36112" --></font></td>
				</tr>
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
		</table>
	</blockquote>
	<p><font face="Verdana">Standard 3</font></p>
	<table id="table2">
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 3  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  3)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="3" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  3)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=3
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="48462" --><tr>
				<td>
				<input type="checkbox" name="cBenchmarks3" value="<%=FP_FieldVal(fp_rs,"xBenchmarks")%>"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xBenchmarks" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xBenchmarks<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"xBenchmarks")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28293" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<blockquote>
		<p><font face="Verdana" size="2">Kindergarten Indicators</font></p>
		<table id="table11">
			<tbody>
				<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 3  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  3)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="12" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  3)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=12
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="55005" --><tr>
					<td>
					<input type="checkbox" name="cIndicators3" value="<%=FP_FieldVal(fp_rs,"xindicatorsk")%>"></td>
					<td><font face="Verdana" size="2">
					<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xindicatorsk" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xindicatorsk<font size="-1">>></font>" startspan s-ColumnTypes="3,203,3,202,202,203,203" --><%=FP_FieldVal(fp_rs,"xindicatorsk")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36112" --></font></td>
				</tr>
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
		</table>
	</blockquote>
	<p><font face="Verdana">Standard 4</font></p>
	<table id="table3">
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 4  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  4)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="4" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  4)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=4
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="48594" --><tr>
				<td>
				<input type="checkbox" name="cBenchmarks4" value="<%=FP_FieldVal(fp_rs,"xBenchmarks")%>"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xBenchmarks" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xBenchmarks<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"xBenchmarks")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28293" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<blockquote>
		<p><font face="Verdana" size="2">Kindergarten Indicators</font></p>
		<table id="table13">
			<tbody>
				<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 4  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  4)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="14" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  4)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=14
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="55011" --><tr>
					<td>
					<input type="checkbox" name="cIndicators4" value="<%=FP_FieldVal(fp_rs,"xindicatorsk")%>"></td>
					<td><font face="Verdana" size="2">
					<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xindicatorsk" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xindicatorsk<font size="-1">>></font>" startspan s-ColumnTypes="3,203,3,202,202,203,203" --><%=FP_FieldVal(fp_rs,"xindicatorsk")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36112" --></font></td>
				</tr>
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
		</table>
	</blockquote>
	<p><font face="Verdana">Standard 5</font></p>
	<table id="table4">
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 5  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  5)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="5" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  5)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=5
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="48726" --><tr>
				<td>
				<input type="checkbox" name="cBenchmarks5" value="<%=FP_FieldVal(fp_rs,"xBenchmarks")%>"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xBenchmarks" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xBenchmarks<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"xBenchmarks")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28293" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<blockquote>
		<p><font face="Verdana" size="2">Kindergarten Indicators</font></p>
		<table id="table15">
			<tbody>
				<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 5  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  5)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="16" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  5)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=16
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="55017" --><tr>
					<td>
					<input type="checkbox" name="cIndicators5" value="<%=FP_FieldVal(fp_rs,"xindicatorsk")%>"></td>
					<td><font face="Verdana" size="2">
					<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xindicatorsk" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xindicatorsk<font size="-1">>></font>" startspan s-ColumnTypes="3,203,3,202,202,203,203" --><%=FP_FieldVal(fp_rs,"xindicatorsk")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36112" --></font></td>
				</tr>
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
		</table>
	</blockquote>
	<p><font face="Verdana">Standard 6</font></p>
	<table id="table5">
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 6  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  6)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="6" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  6)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=6
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="48858" --><tr>
				<td>
				<input type="checkbox" name="cBenchmarks6" value="<%=FP_FieldVal(fp_rs,"xBenchmarks")%>"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xBenchmarks" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xBenchmarks<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"xBenchmarks")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28293" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<blockquote>
		<p><font face="Verdana" size="2">Kindergarten Indicators</font></p>
		<table id="table17">
			<tbody>
				<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 6  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  6)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="18" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  6)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=18
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="55023" --><tr>
					<td>
					<input type="checkbox" name="cIndicators6" value="<%=FP_FieldVal(fp_rs,"xindicatorsk")%>"></td>
					<td><font face="Verdana" size="2">
					<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xindicatorsk" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xindicatorsk<font size="-1">>></font>" startspan s-ColumnTypes="3,203,3,202,202,203,203" --><%=FP_FieldVal(fp_rs,"xindicatorsk")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36112" --></font></td>
				</tr>
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
		</table>
	</blockquote>
	<p><font face="Verdana">Standard 7</font></p>
	<table id="table6">
		<tbody>
			<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 7  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  7)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="7" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  7)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=7
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="48990" --><tr>
				<td>
				<input type="checkbox" name="cBenchmarks7" value="<%=FP_FieldVal(fp_rs,"xBenchmarks")%>"></td>
				<td>
				<font face="Verdana">
				<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xBenchmarks" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xBenchmarks<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"xBenchmarks")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28293" --></font></td>
			</tr>
			<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
	</table>
	<blockquote>
		<p><font face="Verdana" size="2">Kindergarten Indicators</font></p>
		<table id="table19">
			<tbody>
				<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-columntypes="3,203,3,202,202,203,203" s-dataconnection="peplans" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ID" s-menuvalue="ID" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="standard1_K2" s-displaycolumns="ID,xBenchmarks" s-criteria="{xStandard} EQ 7  +" s-order s-sql="SELECT * FROM standard1_K2 WHERE (xStandard =  7)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="20" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-InForm="TRUE" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM standard1_K2 WHERE (xStandard =  7)"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=2 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="peplans"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="ID"
fp_sMenuValue="ID"
fp_sColTypes="&ID=3&xStandardsDesc=203&xStandard=3&xGrades=202&xBenchmarks=202&xindicatorsk=203&xindicators2=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=20
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="55147" --><tr>
					<td>
					<input type="checkbox" name="cIndicators7" value="<%=FP_FieldVal(fp_rs,"xindicatorsk")%>"></td>
					<td><font face="Verdana" size="2">
					<!--webbot bot="DatabaseResultColumn" s-columnnames="ID,xStandardsDesc,xStandard,xGrades,xBenchmarks,xindicatorsk,xindicators2" s-column="xindicatorsk" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>xindicatorsk<font size="-1">>></font>" startspan s-ColumnTypes="3,203,3,202,202,203,203" --><%=FP_FieldVal(fp_rs,"xindicatorsk")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="36112" --></font></td>
				</tr>
				<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
		</table>
	</blockquote>
	<p> </p>
	<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

< Message edited by rdouglass -- 8/30/2006 10:17:32 >

(in reply to truwebs)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Checkbox in Form from DRW - 8/30/2006 10:30:11 quote: Ideally I think I would like each checkbox of data submitted to it's own unique database field. Even doing them ingroups as you are trying to do ("Standards", etc) you will need to grab all the values and SPLIT them. This line right here: <input type="checkbox" name="cStandards" value="<%=FP_FieldVal(fp_rs,"sDescription")%>"> is doing exactly what I'm suggesting except it's using the text instead of the ID. If you want to collect all the cStandard items that wree checked, you could do it like this: <%cStandardsArray = split(request.form("cStandards"),",")%> and then you can display them (or continue to work with them, or add them to a DB, etc.) by looping thru the array like this: <%FOR i = 0 TO ubound(cStandardsArray) response.write(cStandardsArray(i) & "<br>") NEXT%> Humor me and try those 2 lines of code on the page that you post the form to. You should see all the cStandards items that were checked are now displayed. Or maybe you're trying to do all of this using just the DRW. If so, I don't believe it can be done. That any better? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to truwebs)


truwebs Posts: 80 Joined: 7/10/2006 Status: offline	RE: Checkbox in Form from DRW - 8/30/2006 21:56:02 Ahhhh Ok... Definitely making some headway. But... I believe the comma is used to be a delimiter right? Well... There are commas on some of the records which is causing lines to break up and drop to the next line of the output page. How do I fix this? Thanks, TRU (in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Checkbox in Form from DRW - 8/30/2006 22:41:13 quote: There are commas on some of the records So in your text values there are commas? Hmmm, see why I use the ID's instead? If you must use the text values, I can only suggest replacing the commas in the actual value itself with a string of characters that you can identify easily. I frequently use "QQQQ" for this since it is extremely rare that I would encounter that in a text item. We need to do something like this 'cause we cannot change the delimiter that separates these values; it will always be a comma. So we can use the 'replace' function in these values to substitute for commas. Don't do it to the displayed text 'cause we want to see the commas there. Something like this for each option: <input type="checkbox" name="cStandards" value="<%=Replace(FP_FieldVal(fp_rs,"sDescription"),",","QQQQ")%>"> and do just the opposite just before we UPDATE the database or use it somewhere else: UPDATE myTable SET sDescription = '" & Replace(myArrayOrRequestedCheckboxvalue,"QQQQ",",") ... something like that would put the commas back. That help any? PS. Once you hget past this, you should begin to see the power in recursive arrays and such when dealing with lists of items; it can be rather handy and powerful once you get the hang of it. I'm glad you're hanging in there. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to truwebs)


truwebs Posts: 80 Joined: 7/10/2006 Status: offline	RE: Checkbox in Form from DRW - 8/30/2006 23:04:18 Hmmm... this one I will need to chew on for awhile. (in reply to rdouglass)


truwebs Posts: 80 Joined: 7/10/2006 Status: offline	RE: Checkbox in Form from DRW - 8/31/2006 21:10:11 quote: your text values there are commas? Hmmm, see why I use the ID's instead? If you must use the text values, I can only suggest replacing the commas in the actual value itself with a string of characters that you can identify easily. I frequently use "QQQQ" for this since it is extremely rare that I would encounter that in a text item. We need to do something like this 'cause we cannot change the delimiter that separates these values; it will always be a comma. I think I might tackle the ID avenue after I get this method running in some working order. Before I try the IDs I think I might have to restructure my database. After some thought, I think I just might goe through the DB and replace all the commas with another character for now. Right now this will be for my own use. If later I get it to where I would like to share with others, then I will make some adjustments. Regarding the pushing results to a DB. After making checks and submitting to a page to display, how to I get into a DB? Should the submit to page be another form with the data being inserted into form elements for review befor final submission? Should it be submitted autmatically with the display process? Excuse my ignorance on how to accomplish this as I have been dependent on the DRW and manage my way through prewritten ASP fairly well. Thanks for everything so far. This has been a great learning experience. TRU (in reply to truwebs)


truwebs Posts: 80 Joined: 7/10/2006 Status: offline	RE: Checkbox in Form from DRW -