Hello all,
I am new to web programming, I am trying to learn asp, and other languages. I came across an html form and would like to create an input page I know I have to create an ado connection to my db where I want the fields that have been filled out but I am having a bit of trouble. I am not sure if is because the form has javascript into it.
My submit form is an asp page.
here is what the html looks like
and here is what part of my asp looks like
I would really appreciate help
thanks
I am new to web programming, I am trying to learn asp, and other languages. I came across an html form and would like to create an input page I know I have to create an ado connection to my db where I want the fields that have been filled out but I am having a bit of trouble. I am not sure if is because the form has javascript into it.
My submit form is an asp page.
here is what the html looks like
Code:
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>NCAA Tourney</title>
<SCRIPT LANGUAGE="javascript" >
<!-- Javascript by Jim Domeischel, modified by John Koury
function ValidTextBoxes(npicks)
{
<!-- Checking for Length=0 bypasses Netscape's 3.0 infamous "value Is Undefined" Bug
if( npicks.Player.value.length == 0 )
{
alert("\nWe're gonna need your name!");
npicks.Player.focus()
return false;
}
if (npicks.Player.value == " " )
{
alert("\nWe're gonna need your name!");
npicks.Player.focus()
return false;
}
if( npicks.from.value.length == 0 )
{
alert("\nWe're gonna need your e-mail address!");
npicks.from.focus()
return false;
}
if ((npicks.from.value == " ") ||(npicks.from.value.indexOf ('@', 0) == -1) )
{
alert("\nWe're gonna need your e-mail address!");
npicks.from.focus()
return false;
}
return true;
}
function AllGamesSelected(npicks)
{
var i;
var str;
var LoNullOp=14;
var HiNullOp=141;
for (i=LoNullOp; i <= HiNullOp; i+= 1)
{
if(npicks.elements[i].selectedIndex == 0)
{
str = "\nYou forgot to select one or more games !!! \n\n";
alert (str);
npicks.elements[i].focus()
return false;
}
}
return true;
}
function CheckPicksheet(ncaapicks)
{
if( ValidTextBoxes(ncaapicks) )
{
if(AllGamesSelected(ncaapicks))
{
ncaapicks.submit();
}
}
}
<!-- The following Javascript by John Koury
function LoadSeeds(form)
{
// Bracket 1 vs. Bracket 2 - Bracket 3 vs. Bracket 4
// --------------------------------------------------------
// BRACKET 1 - Enter Bracket Name (ie. East, West...) in HIDDEN NAME = "Region1" Below
form.B101.value = "Duke"
form.B116.value = "Southern"
form.B108.value = "Geo. Washington"
form.B109.value = "UNC- Wilm."
form.B105.value = "Syracuse"
form.B112.value = "Texas AM"
form.B104.value = "LSU"
form.B113.value = "Iona"
form.B106.value = "W. Virginia"
form.B111.value = "So. Illinois"
form.B103.value = "Iowa"
form.B114.value = "Northwestern St."
form.B107.value = "California"
form.B110.value = "NC State"
form.B102.value = "Texas"
form.B115.value = "Pennsylvania"
// BRACKET 2
form.B201.value = "Memphis"
form.B216.value = "Oral Roberts"
form.B208.value = "Arkansas"
form.B209.value = "Bucknell"
form.B205.value = "Pittsburgh"
form.B212.value = "Kent State"
form.B204.value = "Kansas"
form.B213.value = "Bradley"
form.B206.value = "Indiana"
form.B211.value = "San Diego St."
form.B203.value = "Gonzaga"
form.B214.value = "Xavier"
form.B207.value = "Marquette"
form.B210.value = "Alabama"
form.B202.value = "UCLA"
form.B215.value = "Belmont"
// BRACKET 3
form.B301.value = "Connecticut"
form.B316.value = "Albany"
form.B308.value = "Kentucky"
form.B309.value = "UAB"
form.B305.value = "Washington"
form.B312.value = "Utah State"
form.B304.value = "Illinois"
form.B313.value = "Air Force"
form.B306.value = "Michigan St."
form.B311.value = "George Mason"
form.B303.value = "N. Carolina"
form.B314.value = "Murray St."
form.B307.value = "Wichita St."
form.B310.value = "Seton Hall"
form.B302.value = "Tennessee"
form.B315.value = "Winthrop"
// BRACKET 4
form.B401.value = "Villanova"
form.B416.value = "Monmth/Hamptn"
form.B408.value = "Arizona"
form.B409.value = "Wisconsin"
form.B405.value = "Nevada"
form.B412.value = "Montana"
form.B404.value = "Boston College"
form.B413.value = "Pacific"
form.B406.value = "Oklahoma"
form.B411.value = "UW - Milwauk."
form.B403.value = "Florida"
form.B414.value = "Sou. Alabama"
form.B407.value = "Georgetown"
form.B410.value = "No. Iowa"
form.B402.value = "Ohio State"
form.B415.value = "Davidson"
form.B1R1G1.options[1] = new Option(form.B101.value)
form.B1R1G1.options[2] = new Option(form.B116.value)
form.B1R1G2.options[1] = new Option(form.B108.value)
form.B1R1G2.options[2] = new Option(form.B109.value)
form.B1R1G3.options[1] = new Option(form.B105.value)
form.B1R1G3.options[2] = new Option(form.B112.value)
form.B1R1G4.options[1] = new Option(form.B104.value)
form.B1R1G4.options[2] = new Option(form.B113.value)
form.B1R1G5.options[1] = new Option(form.B106.value)
form.B1R1G5.options[2] = new Option(form.B111.value)
form.B1R1G6.options[1] = new Option(form.B103.value)
form.B1R1G6.options[2] = new Option(form.B114.value)
form.B1R1G7.options[1] = new Option(form.B107.value)
form.B1R1G7.options[2] = new Option(form.B110.value)
form.B1R1G8.options[1] = new Option(form.B102.value)
form.B1R1G8.options[2] = new Option(form.B115.value)
form.B2R1G1.options[1] = new Option(form.B201.value)
form.B2R1G1.options[2] = new Option(form.B216.value)
form.B2R1G2.options[1] = new Option(form.B208.value)
form.B2R1G2.options[2] = new Option(form.B209.value)
form.B2R1G3.options[1] = new Option(form.B205.value)
form.B2R1G3.options[2] = new Option(form.B212.value)
form.B2R1G4.options[1] = new Option(form.B204.value)
form.B2R1G4.options[2] = new Option(form.B213.value)
form.B2R1G5.options[1] = new Option(form.B206.value)
form.B2R1G5.options[2] = new Option(form.B211.value)
form.B2R1G6.options[1] = new Option(form.B203.value)
form.B2R1G6.options[2] = new Option(form.B214.value)
form.B2R1G7.options[1] = new Option(form.B207.value)
form.B2R1G7.options[2] = new Option(form.B210.value)
form.B2R1G8.options[1] = new Option(form.B202.value)
form.B2R1G8.options[2] = new Option(form.B215.value)
form.B3R1G1.options[1] = new Option(form.B301.value)
form.B3R1G1.options[2] = new Option(form.B316.value)
form.B3R1G2.options[1] = new Option(form.B308.value)
form.B3R1G2.options[2] = new Option(form.B309.value)
form.B3R1G3.options[1] = new Option(form.B305.value)
form.B3R1G3.options[2] = new Option(form.B312.value)
form.B3R1G4.options[1] = new Option(form.B304.value)
form.B3R1G4.options[2] = new Option(form.B313.value)
form.B3R1G5.options[1] = new Option(form.B306.value)
form.B3R1G5.options[2] = new Option(form.B311.value)
form.B3R1G6.options[1] = new Option(form.B303.value)
form.B3R1G6.options[2] = new Option(form.B314.value)
form.B3R1G7.options[1] = new Option(form.B307.value)
form.B3R1G7.options[2] = new Option(form.B310.value)
form.B3R1G8.options[1] = new Option(form.B302.value)
form.B3R1G8.options[2] = new Option(form.B315.value)
form.B4R1G1.options[1] = new Option(form.B401.value)
form.B4R1G1.options[2] = new Option(form.B416.value)
form.B4R1G2.options[1] = new Option(form.B408.value)
form.B4R1G2.options[2] = new Option(form.B409.value)
form.B4R1G3.options[1] = new Option(form.B405.value)
form.B4R1G3.options[2] = new Option(form.B412.value)
form.B4R1G4.options[1] = new Option(form.B404.value)
form.B4R1G4.options[2] = new Option(form.B413.value)
form.B4R1G5.options[1] = new Option(form.B406.value)
form.B4R1G5.options[2] = new Option(form.B411.value)
form.B4R1G6.options[1] = new Option(form.B403.value)
form.B4R1G6.options[2] = new Option(form.B414.value)
form.B4R1G7.options[1] = new Option(form.B407.value)
form.B4R1G7.options[2] = new Option(form.B410.value)
form.B4R1G8.options[1] = new Option(form.B402.value)
form.B4R1G8.options[2] = new Option(form.B415.value)
}
function ChB1R1G1(form)
{
form.B1SSG1.options[1] = new Option(form.B1R1G1.options[form.B1R1G1.selectedIndex].text)
}
function ChB1R1G2(form)
{
form.B1SSG1.options[2] = new Option(form.B1R1G2.options[form.B1R1G2.selectedIndex].text)
}
function ChB1R1G3(form)
{
form.B1SSG2.options[1] = new Option(form.B1R1G3.options[form.B1R1G3.selectedIndex].text)
}
function ChB1R1G4(form)
{
form.B1SSG2.options[2] = new Option(form.B1R1G4.options[form.B1R1G4.selectedIndex].text)
}
function ChB1R1G5(form)
{
form.B1SSG3.options[1] = new Option(form.B1R1G5.options[form.B1R1G5.selectedIndex].text)
}
function ChB1R1G6(form)
{
form.B1SSG3.options[2] = new Option(form.B1R1G6.options[form.B1R1G6.selectedIndex].text)
}
function ChB1R1G7(form)
{
form.B1SSG4.options[1] = new Option(form.B1R1G7.options[form.B1R1G7.selectedIndex].text)
}
function ChB1R1G8(form)
{
form.B1SSG4.options[2] = new Option(form.B1R1G8.options[form.B1R1G8.selectedIndex].text)
}
function ChB1SSG1(form)
{
form.B1E8G1.options[1] = new Option(form.B1SSG1.options[form.B1SSG1.selectedIndex].text)
}
function ChB1SSG2(form)
{
form.B1E8G1.options[2] = new Option(form.B1SSG2.options[form.B1SSG2.selectedIndex].text)
}
function ChB1SSG3(form)
{
form.B1E8G2.options[1] = new Option(form.B1SSG3.options[form.B1SSG3.selectedIndex].text)
}
function ChB1SSG4(form)
{
form.B1E8G2.options[2] = new Option(form.B1SSG4.options[form.B1SSG4.selectedIndex].text)
}
function ChB1E8G1(form)
{
form.B1F4.options[1] = new Option(form.B1E8G1.options[form.B1E8G1.selectedIndex].text)
}
function ChB1E8G2(form)
{
form.B1F4.options[2] = new Option(form.B1E8G2.options[form.B1E8G2.selectedIndex].text)
}
function ChB2R1G1(form)
{
form.B2SSG1.options[1] = new Option(form.B2R1G1.options[form.B2R1G1.selectedIndex].text)
}
function ChB2R1G2(form)
{
form.B2SSG1.options[2] = new Option(form.B2R1G2.options[form.B2R1G2.selectedIndex].text)
}
function ChB2R1G3(form)
{
form.B2SSG2.options[1] = new Option(form.B2R1G3.options[form.B2R1G3.selectedIndex].text)
}
function ChB2R1G4(form)
{
form.B2SSG2.options[2] = new Option(form.B2R1G4.options[form.B2R1G4.selectedIndex].text)
}
function ChB2R1G5(form)
{
form.B2SSG3.options[1] = new Option(form.B2R1G5.options[form.B2R1G5.selectedIndex].text)
}
function ChB2R1G6(form)
{
form.B2SSG3.options[2] = new Option(form.B2R1G6.options[form.B2R1G6.selectedIndex].text)
}
function ChB2R1G7(form)
{
form.B2SSG4.options[1] = new Option(form.B2R1G7.options[form.B2R1G7.selectedIndex].text)
}
function ChB2R1G8(form)
{
form.B2SSG4.options[2] = new Option(form.B2R1G8.options[form.B2R1G8.selectedIndex].text)
}
function ChB2SSG1(form)
{
form.B2E8G1.options[1] = new Option(form.B2SSG1.options[form.B2SSG1.selectedIndex].text)
}
function ChB2SSG2(form)
{
form.B2E8G1.options[2] = new Option(form.B2SSG2.options[form.B2SSG2.selectedIndex].text)
}
function ChB2SSG3(form)
{
form.B2E8G2.options[1] = new Option(form.B2SSG3.options[form.B2SSG3.selectedIndex].text)
}
function ChB2SSG4(form)
{
form.B2E8G2.options[2] = new Option(form.B2SSG4.options[form.B2SSG4.selectedIndex].text)
}
function ChB2E8G1(form)
{
form.B2F4.options[1] = new Option(form.B2E8G1.options[form.B2E8G1.selectedIndex].text)
}
function ChB2E8G2(form)
{
form.B2F4.options[2] = new Option(form.B2E8G2.options[form.B2E8G2.selectedIndex].text)
}
function ChB3R1G1(form)
{
form.B3SSG1.options[1] = new Option(form.B3R1G1.options[form.B3R1G1.selectedIndex].text)
}
function ChB3R1G2(form)
{
form.B3SSG1.options[2] = new Option(form.B3R1G2.options[form.B3R1G2.selectedIndex].text)
}
function ChB3R1G3(form)
{
form.B3SSG2.options[1] = new Option(form.B3R1G3.options[form.B3R1G3.selectedIndex].text)
}
function ChB3R1G4(form)
{
form.B3SSG2.options[2] = new Option(form.B3R1G4.options[form.B3R1G4.selectedIndex].text)
}
function ChB3R1G5(form)
{
form.B3SSG3.options[1] = new Option(form.B3R1G5.options[form.B3R1G5.selectedIndex].text)
}
function ChB3R1G6(form)
{
form.B3SSG3.options[2] = new Option(form.B3R1G6.options[form.B3R1G6.selectedIndex].text)
}
function ChB3R1G7(form)
{
form.B3SSG4.options[1] = new Option(form.B3R1G7.options[form.B3R1G7.selectedIndex].text)
}
function ChB3R1G8(form)
{
form.B3SSG4.options[2] = new Option(form.B3R1G8.options[form.B3R1G8.selectedIndex].text)
}
function ChB3SSG1(form)
{
form.B3E8G1.options[1] = new Option(form.B3SSG1.options[form.B3SSG1.selectedIndex].text)
}
function ChB3SSG2(form)
{
form.B3E8G1.options[2] = new Option(form.B3SSG2.options[form.B3SSG2.selectedIndex].text)
}
function ChB3SSG3(form)
{
form.B3E8G2.options[1] = new Option(form.B3SSG3.options[form.B3SSG3.selectedIndex].text)
}
function ChB3SSG4(form)
{
form.B3E8G2.options[2] = new Option(form.B3SSG4.options[form.B3SSG4.selectedIndex].text)
}
function ChB3E8G1(form)
{
form.B3F4.options[1] = new Option(form.B3E8G1.options[form.B3E8G1.selectedIndex].text)
}
function ChB3E8G2(form)
{
form.B3F4.options[2] = new Option(form.B3E8G2.options[form.B3E8G2.selectedIndex].text)
}
function ChB4R1G1(form)
{
form.B4SSG1.options[1] = new Option(form.B4R1G1.options[form.B4R1G1.selectedIndex].text)
}
function ChB4R1G2(form)
{
form.B4SSG1.options[2] = new Option(form.B4R1G2.options[form.B4R1G2.selectedIndex].text)
}
function ChB4R1G3(form)
{
form.B4SSG2.options[1] = new Option(form.B4R1G3.options[form.B4R1G3.selectedIndex].text)
}
function ChB4R1G4(form)
{
form.B4SSG2.options[2] = new Option(form.B4R1G4.options[form.B4R1G4.selectedIndex].text)
}
function ChB4R1G5(form)
{
form.B4SSG3.options[1] = new Option(form.B4R1G5.options[form.B4R1G5.selectedIndex].text)
}
function ChB4R1G6(form)
{
form.B4SSG3.options[2] = new Option(form.B4R1G6.options[form.B4R1G6.selectedIndex].text)
}
function ChB4R1G7(form)
{
form.B4SSG4.options[1] = new Option(form.B4R1G7.options[form.B4R1G7.selectedIndex].text)
}
function ChB4R1G8(form)
{
form.B4SSG4.options[2] = new Option(form.B4R1G8.options[form.B4R1G8.selectedIndex].text)
}
function ChB4SSG1(form)
{
form.B4E8G1.options[1] = new Option(form.B4SSG1.options[form.B4SSG1.selectedIndex].text)
}
function ChB4SSG2(form)
{
form.B4E8G1.options[2] = new Option(form.B4SSG2.options[form.B4SSG2.selectedIndex].text)
}
function ChB4SSG3(form)
{
form.B4E8G2.options[1] = new Option(form.B4SSG3.options[form.B4SSG3.selectedIndex].text)
}
function ChB4SSG4(form)
{
form.B4E8G2.options[2] = new Option(form.B4SSG4.options[form.B4SSG4.selectedIndex].text)
}
function ChB4E8G1(form)
{
form.B4F4.options[1] = new Option(form.B4E8G1.options[form.B4E8G1.selectedIndex].text)
}
function ChB4E8G2(form)
{
form.B4F4.options[2] = new Option(form.B4E8G2.options[form.B4E8G2.selectedIndex].text)
}
function ChB1F4(form)
{
form.B12F.options[1] = new Option(form.B1F4.options[form.B1F4.selectedIndex].text)
}
function ChB2F4(form)
{
form.B12F.options[2] = new Option(form.B2F4.options[form.B2F4.selectedIndex].text)
}
function ChB3F4(form)
{
form.B34F.options[1] = new Option(form.B3F4.options[form.B3F4.selectedIndex].text)
}
function ChB4F4(form)
{
form.B34F.options[2] = new Option(form.B4F4.options[form.B4F4.selectedIndex].text)
}
function ChB12F(form)
{
form.Winner.options[1] = new Option(form.B12F.options[form.B12F.selectedIndex].text)
}
function ChB34F(form)
{
form.Winner.options[2] = new Option(form.B34F.options[form.B34F.selectedIndex].text)
}
function PrintRegion(n)
{
if (n==1) { document.write(ncaapicks.Region1.value)}
if (n==2) { document.write(ncaapicks.Region2.value)}
if (n==3) { document.write(ncaapicks.Region3.value)}
if (n==4) { document.write(ncaapicks.Region4.value)}
}
// --->
</SCRIPT>
</head>
<body background="woodbkgr.jpg" onLoad="LoadSeeds(document.ncaapicks)">
<p align="center"><i><b><font size="6" color="#0000FF">
March Madness 2006</font></b></i><br>
<br>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tr>
<td>
<p align="left"><b>Enter your Name and E-mail address in the boxes
below and then make your picks in the brackets below. You'll be
selecting up to the Final Four in each Bracket. Your selections
for the Finals and Tournament Champion are listed after Bracket 4.</b></p>
<p align="left"><b>After submitting your picks you will receive a
Confirmation page and will also receive an e-mail confirmation.
If you do not receive an e-mail confirmation, your picks may not have
been sent.</b></td>
</tr>
</table>
</div>
<hr>
<p>
<i><b>
<p/>
</b></i>
<FORM NAME="ncaapicks" ACTION="[URL unfurl="true"]http://www.jimsquest.net/cgi-bin/ncaawoof.cgi"[/URL] METHOD="POST">
<input type=hidden name="to" value="PoolManager@yourdomain.com">
<input type=hidden name="subject" value=" Big Dance - ">
<input type=hidden name="required_fields" Value = "">
<input type=hidden name="body_bgcolor" value="FFFFFF">
<input type=hidden name="body_text" value="000000">
<input type=hidden name="first_line" value="You have submitted the following picks:">
<input type=hidden name="body" value="Good Luck !!!">
<input type=hidden name="separator" value=",">
<input type=hidden name="Region1" value="Atlanta">
<input type=hidden name="Region2" value="Oakland">
<input type=hidden name="Region3" value="Washington DC">
<input type=hidden name="Region4" value="Minneapolis">
<center>
<TABLE BORDER=0 CELLPADDING=3>
<TR>
<TD ALIGN=RIGHT><B>Name:</B></TD>
<TD ALIGN=LEFT><INPUT TYPE="text" NAME="Player" SIZE="30" MAXLENGTH="33" tabindex="1" ></TD>
</TR>
<TR>
<TD ALIGN=RIGHT><B>E-Mail:</B></TD>
<TD ALIGN=LEFT><INPUT TYPE="text" NAME="from" SIZE="30" MAXLENGTH="33" tabindex="2" ></TD>
</TR>
</TABLE>
<hr>
</CENTER>
<div align="left">
<table border="4" cellspacing="1" width="600">
<caption>
<p><b><i><font size="5"><SCRIPT>PrintRegion(1);</SCRIPT></font></i></b></p>
</caption>
<tr>
<td width="120" align="right">
<p align="right"><input type="text" name="B101" size="15"></p>
</td>
<td width="120" rowspan="2" align="center"><select size="1" name="B1R1G1" onChange="ChB1R1G1(this.form)" tabindex="3">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center">
<p align="center"><select size="1" name="B1SSG1" onChange="ChB1SSG1(this.form)" tabindex="12">
<option selected>- - - - - - - - - - - - - -</option>
</select></p>
</td>
<td width="120" rowspan="8" align="center"><select size="1" name="B1E8G1" onChange="ChB1E8G1(this.form)" tabindex="16">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="16" align="center"><select size="1" name="B1F4" onChange="ChB1F4(this.form)" tabindex="18">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B116" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B108" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B1R1G2" onChange="ChB1R1G2(this.form)" tabindex="4">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B109" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B105" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B1R1G3" onChange="ChB1R1G3(this.form)" tabindex="5">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center">
<p align="center"><select size="1" name="B1SSG2" onChange="ChB1SSG2(this.form)" tabindex="13">
<option selected>- - - - - - - - - - - - - -</option>
</select></p>
</td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B112" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B104" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B1R1G4" onChange="ChB1R1G4(this.form)" tabindex="6">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B113" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B106" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B1R1G5" onChange="ChB1R1G5(this.form)" tabindex="7">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center"><select size="1" name="B1SSG3" onChange="ChB1SSG3(this.form)" tabindex="14">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="8" align="center"><select size="1" name="B1E8G2" onChange="ChB1E8G2(this.form)" tabindex="17">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B111" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B103" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B1R1G6" onChange="ChB1R1G6(this.form)" tabindex="8">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B114" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B107" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B1R1G7" onChange="ChB1R1G7(this.form)" tabindex="9">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center"><select size="1" name="B1SSG4" onChange="ChB1SSG4(this.form)" tabindex="15">
<option selected value="- - - - - - - - - - - - - -">- - - - - - - - -
- - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B110" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B102" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B1R1G8" onChange="ChB1R1G8(this.form)" tabindex="10">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B115" size="15"></td>
</tr>
</table>
</div>
<p><p/>
<div align="left">
<table border="4" cellspacing="1" width="600">
<caption>
<p><b><i><font size="5"><SCRIPT>PrintRegion(2);</SCRIPT></font></i></b></p>
</caption>
<tr>
<td width="120" align="right">
<p align="right"><input type="text" name="B201" size="15"></p>
</td>
<td width="120" rowspan="2" align="center"><select size="1" name="B2R1G1" onChange="ChB2R1G1(this.form)" tabindex="19">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center"><select size="1" name="B2SSG1" onChange="ChB2SSG1(this.form)" tabindex="27">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="8" align="center"><select size="1" name="B2E8G1" onChange="ChB2E8G1(this.form)" tabindex="31">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="16" align="center"><select size="1" name="B2F4" onChange="ChB2F4(this.form)" tabindex="33">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B216" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B208" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B2R1G2" onChange="ChB2R1G2(this.form)" tabindex="20">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B209" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B205" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B2R1G3" onChange="ChB2R1G3(this.form)" tabindex="21">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center"><select size="1" name="B2SSG2" onChange="ChB2SSG2(this.form)" tabindex="28">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B212" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B204" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B2R1G4" onChange="ChB2R1G4(this.form)" tabindex="22">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B213" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B206" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B2R1G5" onChange="ChB2R1G5(this.form)" tabindex="23">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center"><select size="1" name="B2SSG3" onChange="ChB2SSG3(this.form)" tabindex="29">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="8" align="center"><select size="1" name="B2E8G2" onChange="ChB2E8G2(this.form)" tabindex="32">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B211" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B203" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B2R1G6" onChange="ChB2R1G6(this.form)" tabindex="24">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B214" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B207" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B2R1G7" onChange="ChB2R1G7(this.form)" tabindex="25">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center"><select size="1" name="B2SSG4" onChange="ChB2SSG4(this.form)" tabindex="30">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B210" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B202" size="15"></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B2R1G8" onChange="ChB2R1G8(this.form)" tabindex="26">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B215" size="15"></td>
</tr>
</table>
</div>
<p></p>
<div align="right">
<table border="4" cellspacing="1" width="600">
<caption>
<p><b><i><font size="5"><SCRIPT>PrintRegion(3);</SCRIPT></font></i></b></p>
</caption>
<tr>
<td width="120" align="center" rowspan="16"><select size="1" name="B3F4" onChange="ChB3F4(this.form)" tabindex="48">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="8" align="center"><select size="1" name="B3E8G1" onChange="ChB3E8G1(this.form)" tabindex="46">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center"><select size="1" name="B3SSG1" onChange="ChB3SSG1(this.form)" tabindex="42">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B3R1G1" onChange="ChB3R1G1(this.form)" tabindex="34">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right">
<p align="right"><input type="text" name="B301" size="15"></p>
</td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B316" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="2" align="center"><select size="1" name="B3R1G2" onChange="ChB3R1G2(this.form)" tabindex="35">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right"><input type="text" name="B308" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B309" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="4" align="center"><select size="1" name="B3SSG2" onChange="ChB3SSG2(this.form)" tabindex="43">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B3R1G3" onChange="ChB3R1G3(this.form)" tabindex="36">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right"><input type="text" name="B305" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B312" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="2" align="center"><select size="1" name="B3R1G4" onChange="ChB3R1G4(this.form)" tabindex="37">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right"><input type="text" name="B304" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B313" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="8" align="center"><select size="1" name="B3E8G2" onChange="ChB3E8G2(this.form)" tabindex="47">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center"><select size="1" name="B3SSG3" onChange="ChB3SSG3(this.form)" tabindex="44">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B3R1G5" onChange="ChB3R1G5(this.form)" tabindex="38">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right"><input type="text" name="B306" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B311" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="2" align="center"><select size="1" name="B3R1G6" onChange="ChB3R1G6(this.form)" tabindex="39">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right"><input type="text" name="B303" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B314" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="4" align="center"><select size="1" name="B3SSG4" onChange="ChB3SSG4(this.form)" tabindex="45">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="2" align="center"><select size="1" name="B3R1G7" onChange="ChB3R1G7(this.form)" tabindex="40">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right"><input type="text" name="B307" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B310" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="2" align="center"><select size="1" name="B3R1G8" onChange="ChB3R1G8(this.form)" tabindex="41">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right"><input type="text" name="B302" size="15"></td>
</tr>
<tr>
<td width="120" align="right"><input type="text" name="B315" size="15"></td>
</tr>
</table>
</div>
<p></p>
<div align="right">
<table border="4" cellspacing="1" width="600" height="462">
<caption>
<p><b><i><font size="5"><SCRIPT>PrintRegion(4);</SCRIPT></font></i></b></p>
</caption>
<tr>
<td width="120" align="center" rowspan="16" height="456"><select size="1" name="B4F4" onChange="ChB4F4(this.form)" tabindex="64">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="8" align="center" height="226"><select size="1" name="B4E8G1" onChange="ChB4E8G1(this.form)" tabindex="62">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center" height="110"><select size="1" name="B4SSG1" onChange="ChB4SSG1(this.form)" tabindex="58">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="2" align="center" height="52"><select size="1" name="B4R1G1" onChange="ChB4R1G1(this.form)" tabindex="49">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right" height="23">
<p align="right"><input type="text" name="B401" size="15"></p>
</td>
</tr>
<tr>
<td width="120" align="right" height="23"><input type="text" name="B416" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="2" align="center" height="52"><select size="1" name="B4R1G2" onChange="ChB4R1G2(this.form)" tabindex="50">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right" height="23"><input type="text" name="B408" size="15"></td>
</tr>
<tr>
<td width="120" align="right" height="23"><input type="text" name="B409" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="4" align="center" height="110"><select size="1" name="B4SSG2" onChange="ChB4SSG2(this.form)" tabindex="59">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="2" align="center" height="52"><select size="1" name="B4R1G3" onChange="ChB4R1G3(this.form)" tabindex="51">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right" height="23"><input type="text" name="B405" size="15"></td>
</tr>
<tr>
<td width="120" align="right" height="23"><input type="text" name="B412" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="2" align="center" height="52"><select size="1" name="B4R1G4" onChange="ChB4R1G4(this.form)" tabindex="52">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right" height="23"><input type="text" name="B404" size="15"></td>
</tr>
<tr>
<td width="120" align="right" height="23"><input type="text" name="B413" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="8" align="center" height="224"><select size="1" name="B4E8G2" onChange="ChB4E8G2(this.form)" tabindex="63">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="4" align="center" height="110"><select size="1" name="B4SSG3" onChange="ChB4SSG3(this.form)" tabindex="60">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="2" align="center" height="52"><select size="1" name="B4R1G5" onChange="ChB4R1G5(this.form)" tabindex="53">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right" height="23"><input type="text" name="B406" size="15"></td>
</tr>
<tr>
<td width="120" align="right" height="23"><input type="text" name="B411" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="2" align="center" height="52"><select size="1" name="B4R1G6" onChange="ChB4R1G6(this.form)" tabindex="54">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right" height="23"><input type="text" name="B403" size="15"></td>
</tr>
<tr>
<td width="120" align="right" height="23"><input type="text" name="B414" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="4" align="center" height="108"><select size="1" name="B4SSG4" onChange="ChB4SSG4(this.form)" tabindex="61">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" rowspan="2" align="center" height="52"><select size="1" name="B4R1G7" onChange="ChB4R1G7(this.form)" tabindex="55">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right" height="23"><input type="text" name="B407" size="15"></td>
</tr>
<tr>
<td width="120" align="right" height="23"><input type="text" name="B410" size="15"></td>
</tr>
<tr>
<td width="120" rowspan="2" align="center" height="50"><select size="1" name="B4R1G8" onChange="ChB4R1G8(this.form)" tabindex="56">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td width="120" align="right" height="23"><input type="text" name="B402" size="15"></td>
</tr>
<tr>
<td width="120" align="right" height="21"><input type="text" name="B415" size="15"></td>
</tr>
</table>
</div>
<p> </p>
<div align="center">
<table border="4" cellpadding="0" cellspacing="0" width="652">
<caption><b><i><font size="5">Finals</font></i></b></caption>
<tr>
<td align="center" width="214"> </td>
<td align="center" width="215"> </td>
<td align="center" width="215"> </td>
</tr>
<tr>
<td align="center" width="214"><b><font color="#000000"><SCRIPT>PrintRegion(1);</SCRIPT>/<SCRIPT>PrintRegion(2);</SCRIPT> Winner</font></b></td>
<td align="center" width="215"> </td>
<td align="center" width="215"><b><font color="#000000"><SCRIPT>PrintRegion(3);</SCRIPT>/<SCRIPT>PrintRegion(4);</SCRIPT> Winner</font></b></td>
</tr>
<tr>
<td align="center" width="214"><select size="1" name="B12F" onChange="ChB12F(this.form)" tabindex="65">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td align="center" width="215"> </td>
<td align="center" width="215"><select size="1" name="B34F" onChange="ChB34F(this.form)" tabindex="66">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
</tr>
<tr>
<td align="center" width="214"> </td>
<td align="center" width="215"><b><font color="#000000" size="4">Tournament Champion</font></b></td>
<td align="center" width="215"> </td>
</tr>
<tr>
<td align="center" width="214"> </td>
<td align="center" width="215"><select size="1" name="Winner" tabindex="67">
<option selected>- - - - - - - - - - - - - -</option>
</select></td>
<td align="center" width="215"> </td>
</tr>
<tr>
<td align="center" width="214"> </td>
<td align="center" width="215"> </td>
<td align="center" width="215"> </td>
</tr>
</table>
<table border="0" cellspacing="1" width="600" bgcolor="#00FF00">
<caption>
</caption>
</table>
<p><b>If your pool uses a tie-breaker, enter the number here:</b></p>
<p align="center"><INPUT TYPE="Number" NAME="Tiebreaker" SIZE="8" MAXLENGTH="6">
<hr>
<p><b><font size="6">Please review ALL of your picks before
submitting.</font></b></p>
<p>
<INPUT TYPE="Button" VALUE="Submit Picks" OnClick="CheckPicksheet(this.form)">
</p>
</form>
<br><br>
</body>
</html>and here is what part of my asp looks like
Code:
<%
'****************************************************************************************
'** Copyright Notice
'**
'** WWeb Wiz Guide Database Tutorial
'**
'** Copyright 2001-2002 Bruce Corkhill All Rights Reserved.
'**
'** This program is free software; you can modify (at your own risk) any part of it
'** under the terms of the License that accompanies this software and use it both
'** privately and commercially.
'**
'** All copyright notices must remain in tacked in the scripts and the
'** outputted HTML.
'**
'** You may use parts of this program in your own private work, but you may NOT
'** redistribute, repackage, or sell the whole or any part of this program even
'** if it is modified or reverse engineered in whole or in part without express
'** permission from the author.
'**
'** You may not pass the whole or any part of this application off as your own work.
'**
'** All links to Web Wiz Guide and powered by logo's must remain unchanged and in place
'** and must remain visible when the pages are viewed unless permission is first granted
'** by the copyright holder.
'**
'** This program is distributed in the hope that it will be useful,
'** but WITHOUT ANY WARRANTY; without even the implied warranty of
'** MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR ANY OTHER
'** WARRANTIES WHETHER EXPRESSED OR IMPLIED.
'**
'** You should have received a copy of the License along with this program;
'** if not, write to:- Web Wiz Guide, PO Box 4982, Bournemouth, BH8 8XP, United Kingdom.
'**
'**
'** No official support is available for this program but you may post support questions at: -
'** [URL unfurl="true"]http://www.webwizguide.info/forum[/URL]
'**
'** Support questions are NOT answered by e-mail ever!
'**
'** For correspondence or non support questions contact: -
'** info@webwizguide.com
'**
'** or at: -
'**
'** Web Wiz Guide, PO Box 4982, Bournemouth, BH8 8XP, United Kingdom
'**
'****************************************************************************************
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim rsUpdateEntry 'Holds the recordset for the record to be updated
Dim strSQL 'Holds the SQL query for the database
Dim lngRecordNo 'Holds the record number to be updated
'Read in the record number to be updated
'Create an ADO connection odject
Set adoCon = Server.CreateObject("ADODB.Connection")
'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("ncaa.mdb")
'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=guestbook"
'Create an ADO recordset object
Set rsUpdateEntry = Server.CreateObject("ADODB.Recordset")
'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT games.* FROM games"
'Set the cursor type we are using so we can navigate through the recordset
rsUpdateEntry.CursorType = 2
'Set the lock type so that the record is locked by ADO when it is updated
rsUpdateEntry.LockType = 3
'Open the tblComments table using the SQL query held in the strSQL varaiable
rsUpdateEntry.Open strSQL, adoCon
'Update the record in the recordset
rsUpdateEntry.Fields("B101")= Request.Form("B101")
rsUpdateEntry.Fields("B102")= Request.Form("B102")
rsUpdateEntry.Fields("B103")= Request.Form("B103")
rsUpdateEntry.Fields("B104")= Request.Form("B104")
rsUpdateEntry.Fields("B105")= Request.Form("B105")
rsUpdateEntry.Fields("B106")= Request.Form("B106")
rsUpdateEntry.Fields("B107")= Request.Form("B107")
rsUpdateEntry.Fields("B108")= Request.Form("B108")
rsUpdateEntry.Fields("B109")= Request.Form("B109")
rsUpdateEntry.Fields("B110")= Request.Form("B110")
rsUpdateEntry.Fields("B111")= Request.Form("B111")
rsUpdateEntry.Fields("B112")= Request.Form("B112")
rsUpdateEntry.Fields("B113")= Request.Form("B113")
rsUpdateEntry.Fields("B114")= Request.Form("B114")
rsUpdateEntry.Fields("B115")= Request.Form("B115")
rsUpdateEntry.Fields("B116")= Request.Form("B116")
rsUpdateEntry.Fields("B201")= Request.Form("B201")
rsUpdateEntry.Fields("B202")= Request.Form("B202")
rsUpdateEntry.Fields("B203")= Request.Form("B203")
rsUpdateEntry.Fields("B204")= Request.Form("B204")
rsUpdateEntry.Fields("B205")= Request.Form("B205")
rsUpdateEntry.Fields("B206")= Request.Form("B206")
rsUpdateEntry.Fields("B207")= Request.Form("B207")
rsUpdateEntry.Fields("B208")= Request.Form("B208")
rsUpdateEntry.Fields("B209")= Request.Form("B209")
rsUpdateEntry.Fields("B210")= Request.Form("B210")
rsUpdateEntry.Fields("B211")= Request.Form("B211")
rsUpdateEntry.Fields("B212")= Request.Form("B212")
rsUpdateEntry.Fields("B213")= Request.Form("B213")
rsUpdateEntry.Fields("B214")= Request.Form("B214")
rsUpdateEntry.Fields("B215")= Request.Form("B215")
rsUpdateEntry.Fields("B216")= Request.Form("B216")
rsUpdateEntry.Fields("B301")= Request.Form("B301")
rsUpdateEntry.Fields("B302")= Request.Form("B302")
rsUpdateEntry.Fields("B303")= Request.Form("B303")
rsUpdateEntry.Fields("B304")= Request.Form("B304")
rsUpdateEntry.Fields("B305")= Request.Form("B305")
rsUpdateEntry.Fields("B306")= Request.Form("B306")
rsUpdateEntry.Fields("B307")= Request.Form("B307")
rsUpdateEntry.Fields("B308")= Request.Form("B308")
rsUpdateEntry.Fields("B309")= Request.Form("B309")
rsUpdateEntry.Fields("B310")= Request.Form("B310")
rsUpdateEntry.Fields("B311")= Request.Form("B311")
rsUpdateEntry.Fields("B312")= Request.Form("B312")
rsUpdateEntry.Fields("B313")= Request.Form("B313")
rsUpdateEntry.Fields("B314")= Request.Form("B314")
rsUpdateEntry.Fields("B315")= Request.Form("B315")
rsUpdateEntry.Fields("B316")= Request.Form("B316")
rsUpdateEntry.Fields("B401")= Request.Form("B401")
rsUpdateEntry.Fields("B402")= Request.Form("B402")
rsUpdateEntry.Fields("B403")= Request.Form("B403")
rsUpdateEntry.Fields("B404")= Request.Form("B404")
rsUpdateEntry.Fields("B405")= Request.Form("B405")
rsUpdateEntry.Fields("B406")= Request.Form("B406")
rsUpdateEntry.Fields("B407")= Request.Form("B407")
rsUpdateEntry.Fields("B408")= Request.Form("B408")
rsUpdateEntry.Fields("B409")= Request.Form("B409")
rsUpdateEntry.Fields("B410")= Request.Form("B410")
rsUpdateEntry.Fields("B411")= Request.Form("B411")
rsUpdateEntry.Fields("B412")= Request.Form("B412")
rsUpdateEntry.Fields("B413")= Request.Form("B413")
rsUpdateEntry.Fields("B414")= Request.Form("B414")
rsUpdateEntry.Fields("B415")= Request.Form("B415")
rsUpdateEntry.Fields("B416")= Request.Form("B416")
rsUpdateEntry.Fields("B1R1G1")= Request.Form("B1R1G1")
rsUpdateEntry.Fields("B1R1G2")= Request.Form("B1R1G2")
rsUpdateEntry.Fields("B1R1G3")= Request.Form("B1R1G3")
rsUpdateEntry.Fields("B1R1G4")= Request.Form("B1R1G4")
rsUpdateEntry.Fields("B1R1G5")= Request.Form("B1R1G5")
rsUpdateEntry.Fields("B1R1G6")= Request.Form("B1R1G6")
rsUpdateEntry.Fields("B1R1G7")= Request.Form("B1R1G7")
rsUpdateEntry.Fields("B1R1G8")= Request.Form("B1R1G8")
rsUpdateEntry.Fields("B2R1G1")= Request.Form("B2R1G1")
rsUpdateEntry.Fields("B2R1G2")= Request.Form("B2R1G2")
rsUpdateEntry.Fields("B2R1G3")= Request.Form("B2R1G3")
rsUpdateEntry.Fields("B2R1G4")= Request.Form("B2R1G4")
rsUpdateEntry.Fields("B2R1G5")= Request.Form("B2R1G5")
rsUpdateEntry.Fields("B2R1G6")= Request.Form("B2R1G6")
rsUpdateEntry.Fields("B2R1G7")= Request.Form("B2R1G7")
rsUpdateEntry.Fields("B3R1G1")= Request.Form("B3R1G1")
rsUpdateEntry.Fields("B3R1G2")= Request.Form("B3R1G2")
rsUpdateEntry.Fields("B3R1G3")= Request.Form("B3R1G3")
rsUpdateEntry.Fields("B3R1G4")= Request.Form("B3R1G4")
rsUpdateEntry.Fields("B3R1G5")= Request.Form("B3R1G5")
rsUpdateEntry.Fields("B3R1G6")= Request.Form("B3R1G6")
rsUpdateEntry.Fields("B3R1G7")= Request.Form("B3R1G7")
rsUpdateEntry.Fields("B3R1G8")= Request.Form("B3R1G8")
rsUpdateEntry.Fields("B4R1G1")= Request.Form("B4R1G1")
rsUpdateEntry.Fields("B4R1G2")= Request.Form("B4R1G2")
rsUpdateEntry.Fields("B4R1G3")= Request.Form("B4R1G3")
rsUpdateEntry.Fields("B4R1G4")= Request.Form("B4R1G4")
rsUpdateEntry.Fields("B4R1G5")= Request.Form("B4R1G5")
rsUpdateEntry.Fields("B4R1G6")= Request.Form("B4R1G6")
rsUpdateEntry.Fields("B4R1G7")= Request.Form("B4R1G7")
rsUpdateEntry.Fields("B4R1G8")= Request.Form("B4R1G8")
rsUpdateEntry.Fields("B1SSG1")= Request.Form("B1SSG1")
rsUpdateEntry.Fields("B1SSG2")= Request.Form("B1SSG2")
rsUpdateEntry.Fields("B1SSG3")= Request.Form("B1SSG3")
rsUpdateEntry.Fields("B1SSG4")= Request.Form("B1SSG4")
rsUpdateEntry.Fields("B2SSG1")= Request.Form("B2SSG1")
rsUpdateEntry.Fields("B2SSG2")= Request.Form("B2SSG2")
rsUpdateEntry.Fields("B2SSG3")= Request.Form("B2SSG3")
rsUpdateEntry.Fields("B2SSG4")= Request.Form("B2SSG4")
rsUpdateEntry.Fields("B3SSG1")= Request.Form("B3SSG1")
rsUpdateEntry.Fields("B3SSG2")= Request.Form("B3SSG2")
rsUpdateEntry.Fields("B3SSG3")= Request.Form("B3SSG3")
rsUpdateEntry.Fields("B3SSG4")= Request.Form("B3SSG4")
rsUpdateEntry.Fields("B4SSG1")= Request.Form("B4SSG1")
rsUpdateEntry.Fields("B4SSG2")= Request.Form("B4SSG2")
rsUpdateEntry.Fields("B4SSG3")= Request.Form("B4SSG3")
rsUpdateEntry.Fields("B4SSG4")= Request.Form("B4SSG4")
rsUpdateEntry.Fields("B1E8G1")= Request.Form("B1E8G1")
rsUpdateEntry.Fields("B1E8G2")= Request.Form("B1E8G2")
rsUpdateEntry.Fields("B2E8G1")= Request.Form("B2E8G1")
rsUpdateEntry.Fields("B2E8G2")= Request.Form("B2E8G2")
rsUpdateEntry.Fields("B3E8G1")= Request.Form("B3E8G1")
rsUpdateEntry.Fields("B3E8G2")= Request.Form("B3E8G2")
rsUpdateEntry.Fields("B4E8G1")= Request.Form("B4E8G1")
rsUpdateEntry.Fields("B4E8G2")= Request.Form("B4E8G2")
rsUpdateEntry.Fields("B1F4")= Request.Form("B1F4")
rsUpdateEntry.Fields("B2F4")= Request.Form("B2F4")
rsUpdateEntry.Fields("B3F4")= Request.Form("B3F4")
rsUpdateEntry.Fields("B4F4")= Request.Form("B4F4")
rsUpdateEntry.Fields("B12F")= Request.Form("B12F")
rsUpdateEntry.Fields("B34F")= Request.Form("B34F")
rsUpdateEntry.Fields("winner")= Request.Form("winner")
'Write the updated recordset to the database
rsUpdateEntry.Update
'Reset server objects
rsUpdateEntry.Close
Set rsUpdateEntry = Nothing
Set adoCon = Nothing
'Return to the update select page incase another record needs deleting
Response.Redirect "aq2"
%>I would really appreciate help
thanks