<%
' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.
On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Session.LCID = 1033
Err.Clear

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
	Err.Clear

	Set fp_conn =  Server.CreateObject("ADODB.Connection")
	FP_DumpError strErrorUrl, "Cannot create connection"

	Set fp_rs = Server.CreateObject("ADODB.Recordset")
	FP_DumpError strErrorUrl, "Cannot create record set"

	fp_conn.Open Application("t-shirts_ConnectionString")
	FP_DumpError strErrorUrl, "Cannot open database"

	fp_rs.Open "Results", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
	FP_DumpError strErrorUrl, "Cannot open record set"

	fp_rs.AddNew
	FP_DumpError strErrorUrl, "Cannot add new record set to the database"
	Dim arFormFields0(24)
	Dim arFormDBFields0(24)
	Dim arFormValues0(24)

	arFormFields0(0) = "D3"
	arFormDBFields0(0) = "D3"
	arFormValues0(0) = Request("D3")
	arFormFields0(1) = "Ordering_OrderQty1"
	arFormDBFields0(1) = "Ordering_OrderQty1"
	arFormValues0(1) = Request("Ordering_OrderQty1")
	arFormFields0(2) = "Ordering_OrderDesc0"
	arFormDBFields0(2) = "Ordering_OrderDesc0"
	arFormValues0(2) = Request("Ordering_OrderDesc0")
	arFormFields0(3) = "StreetAddress"
	arFormDBFields0(3) = "StreetAddress"
	arFormValues0(3) = Request("StreetAddress")
	arFormFields0(4) = "D4"
	arFormDBFields0(4) = "D4"
	arFormValues0(4) = Request("D4")
	arFormFields0(5) = "Ordering_OrderQty2"
	arFormDBFields0(5) = "Ordering_OrderQty2"
	arFormValues0(5) = Request("Ordering_OrderQty2")
	arFormFields0(6) = "Ordering_OrderDesc1"
	arFormDBFields0(6) = "Ordering_OrderDesc1"
	arFormValues0(6) = Request("Ordering_OrderDesc1")
	arFormFields0(7) = "D5"
	arFormDBFields0(7) = "D5"
	arFormValues0(7) = Request("D5")
	arFormFields0(8) = "Ordering_OrderQty3"
	arFormDBFields0(8) = "Ordering_OrderQty3"
	arFormValues0(8) = Request("Ordering_OrderQty3")
	arFormFields0(9) = "Ordering_OrderDesc2"
	arFormDBFields0(9) = "Ordering_OrderDesc2"
	arFormValues0(9) = Request("Ordering_OrderDesc2")
	arFormFields0(10) = "Cell_Phone"
	arFormDBFields0(10) = "Cell_Phone"
	arFormValues0(10) = Request("Cell_Phone")
	arFormFields0(11) = "Address2"
	arFormDBFields0(11) = "Address2"
	arFormValues0(11) = Request("Address2")
	arFormFields0(12) = "Ordering_OrderQty4"
	arFormDBFields0(12) = "Ordering_OrderQty4"
	arFormValues0(12) = Request("Ordering_OrderQty4")
	arFormFields0(13) = "Ordering_OrderDesc3"
	arFormDBFields0(13) = "Ordering_OrderDesc3"
	arFormValues0(13) = Request("Ordering_OrderDesc3")
	arFormFields0(14) = "Ordering_OrderDesc4"
	arFormDBFields0(14) = "Ordering_OrderDesc4"
	arFormValues0(14) = Request("Ordering_OrderDesc4")
	arFormFields0(15) = "FullName"
	arFormDBFields0(15) = "FullName"
	arFormValues0(15) = Request("FullName")
	arFormFields0(16) = "Email"
	arFormDBFields0(16) = "Email"
	arFormValues0(16) = Request("Email")
	arFormFields0(17) = "City"
	arFormDBFields0(17) = "City"
	arFormValues0(17) = Request("City")
	arFormFields0(18) = "Home_Phone"
	arFormDBFields0(18) = "Home_Phone"
	arFormValues0(18) = Request("Home_Phone")
	arFormFields0(19) = "ZipCode"
	arFormDBFields0(19) = "ZipCode"
	arFormValues0(19) = Request("ZipCode")
	arFormFields0(20) = "D1"
	arFormDBFields0(20) = "D1"
	arFormValues0(20) = Request("D1")
	arFormFields0(21) = "State"
	arFormDBFields0(21) = "State"
	arFormValues0(21) = Request("State")
	arFormFields0(22) = "D2"
	arFormDBFields0(22) = "D2"
	arFormValues0(22) = Request("D2")
	arFormFields0(23) = "Ordering_OrderQty0"
	arFormDBFields0(23) = "Ordering_OrderQty0"
	arFormValues0(23) = Request("Ordering_OrderQty0")

	FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

	FP_SaveFieldToDB fp_rs, Now, "Timestamp"

	fp_rs.Update
	FP_DumpError strErrorUrl, "Cannot update the database"

	fp_rs.Close
	fp_conn.Close

	Session("FP_SavedFields")=arFormFields0
	Session("FP_SavedValues")=arFormValues0
	Session.CodePage = Session("FP_OldCodePage")
	Session.LCID = Session("FP_OldLCID")
	Response.Redirect "t-shirtconfirmation.asp"

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<HTML>
<HEAD>
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<TITLE>SSTB T-SHIRT and CAP ORDER FORM</TITLE>
</HEAD>
<BODY background="../images/snowfield.jpg">
<table border="1" width="100%" id="table1">
	<tr>
		<td rowspan="4">
		<img border="0" src="images/t-shirt.jpg" width="355" height="270"><img border="0" src="images/t-shirtlogo.jpg" width="219" height="121"></td>
		<td width="395" align="left" valign="top"><b><font size="6">Sizes: Small 
		thru 3X</font></b></td>
	</tr>
	<tr>
		<td width="395" align="left" valign="top" height="60"><b><font size="6">
		$7 per Shirt</font></b></td>
	</tr>
	<tr>
		<td width="395" align="left" valign="top"><b><font size="6">$5 per Hat</font></b></td>
	</tr>
	<tr>
		<td width="395" align="left" valign="top"><b><font size="6">$4 shipping 
		&amp; handling</font></b></td>
	</tr>
</table>
<HR>
<p><b><font size="6">T-SHIRT and CAP ORDER FORM</font></b></p>
<!--webbot BOT="GeneratedScript" PREVIEW=" " startspan --><script Language="JavaScript" Type="text/javascript"><!--
function FrontPage_Form1_Validator(theForm)
{

  if (theForm.FullName.value == "")
  {
    alert("Please enter a value for the \"Full Name\" field.");
    theForm.FullName.focus();
    return (false);
  }

  if (theForm.FullName.value.length < 2)
  {
    alert("Please enter at least 2 characters in the \"Full Name\" field.");
    theForm.FullName.focus();
    return (false);
  }

  if (theForm.FullName.value.length > 100)
  {
    alert("Please enter at most 100 characters in the \"Full Name\" field.");
    theForm.FullName.focus();
    return (false);
  }

  if (theForm.StreetAddress.value == "")
  {
    alert("Please enter a value for the \"Street Address\" field.");
    theForm.StreetAddress.focus();
    return (false);
  }

  if (theForm.StreetAddress.value.length < 4)
  {
    alert("Please enter at least 4 characters in the \"Street Address\" field.");
    theForm.StreetAddress.focus();
    return (false);
  }

  if (theForm.StreetAddress.value.length > 100)
  {
    alert("Please enter at most 100 characters in the \"Street Address\" field.");
    theForm.StreetAddress.focus();
    return (false);
  }

  if (theForm.City.value == "")
  {
    alert("Please enter a value for the \"City\" field.");
    theForm.City.focus();
    return (false);
  }

  if (theForm.City.value.length < 4)
  {
    alert("Please enter at least 4 characters in the \"City\" field.");
    theForm.City.focus();
    return (false);
  }

  if (theForm.City.value.length > 100)
  {
    alert("Please enter at most 100 characters in the \"City\" field.");
    theForm.City.focus();
    return (false);
  }

  if (theForm.State.value == "")
  {
    alert("Please enter a value for the \"State\" field.");
    theForm.State.focus();
    return (false);
  }

  if (theForm.State.value.length < 2)
  {
    alert("Please enter at least 2 characters in the \"State\" field.");
    theForm.State.focus();
    return (false);
  }

  if (theForm.State.value.length > 30)
  {
    alert("Please enter at most 30 characters in the \"State\" field.");
    theForm.State.focus();
    return (false);
  }

  if (theForm.ZipCode.value == "")
  {
    alert("Please enter a value for the \"Zip Code\" field.");
    theForm.ZipCode.focus();
    return (false);
  }

  if (theForm.ZipCode.value.length < 5)
  {
    alert("Please enter at least 5 characters in the \"Zip Code\" field.");
    theForm.ZipCode.focus();
    return (false);
  }

  if (theForm.ZipCode.value.length > 12)
  {
    alert("Please enter at most 12 characters in the \"Zip Code\" field.");
    theForm.ZipCode.focus();
    return (false);
  }

  if (theForm.Home_Phone.value == "")
  {
    alert("Please enter a value for the \"Home Phone\" field.");
    theForm.Home_Phone.focus();
    return (false);
  }

  if (theForm.Home_Phone.value.length < 7)
  {
    alert("Please enter at least 7 characters in the \"Home Phone\" field.");
    theForm.Home_Phone.focus();
    return (false);
  }

  if (theForm.Home_Phone.value.length > 25)
  {
    alert("Please enter at most 25 characters in the \"Home Phone\" field.");
    theForm.Home_Phone.focus();
    return (false);
  }

  if (theForm.Email.value == "")
  {
    alert("Please enter a value for the \"E-Mail\" field.");
    theForm.Email.focus();
    return (false);
  }

  if (theForm.Email.value.length < 6)
  {
    alert("Please enter at least 6 characters in the \"E-Mail\" field.");
    theForm.Email.focus();
    return (false);
  }

  if (theForm.Email.value.length > 100)
  {
    alert("Please enter at most 100 characters in the \"E-Mail\" field.");
    theForm.Email.focus();
    return (false);
  }

  if (theForm.Ordering_OrderQty0.value == "")
  {
    alert("Please enter a value for the \"How Many?\" field.");
    theForm.Ordering_OrderQty0.focus();
    return (false);
  }

  if (theForm.Ordering_OrderQty0.value.length < 1)
  {
    alert("Please enter at least 1 characters in the \"How Many?\" field.");
    theForm.Ordering_OrderQty0.focus();
    return (false);
  }

  if (theForm.Ordering_OrderQty0.value.length > 6)
  {
    alert("Please enter at most 6 characters in the \"How Many?\" field.");
    theForm.Ordering_OrderQty0.focus();
    return (false);
  }

  if (theForm.Ordering_OrderDesc0.value == "")
  {
    alert("Please enter a value for the \"What do you want to order?\" field.");
    theForm.Ordering_OrderDesc0.focus();
    return (false);
  }

  if (theForm.Ordering_OrderDesc0.value.length < 3)
  {
    alert("Please enter at least 3 characters in the \"What do you want to order?\" field.");
    theForm.Ordering_OrderDesc0.focus();
    return (false);
  }

  if (theForm.Ordering_OrderDesc0.value.length > 100)
  {
    alert("Please enter at most 100 characters in the \"What do you want to order?\" field.");
    theForm.Ordering_OrderDesc0.focus();
    return (false);
  }

  if (theForm.D1.selectedIndex < 0)
  {
    alert("Please select one of the \"What Size?\" options.");
    theForm.D1.focus();
    return (false);
  }

  if (theForm.D2.selectedIndex < 0)
  {
    alert("Please select one of the \"What Size?\" options.");
    theForm.D2.focus();
    return (false);
  }

  if (theForm.D3.selectedIndex < 0)
  {
    alert("Please select one of the \"What Size?\" options.");
    theForm.D3.focus();
    return (false);
  }

  if (theForm.D4.selectedIndex < 0)
  {
    alert("Please select one of the \"What Size?\" options.");
    theForm.D4.focus();
    return (false);
  }

  if (theForm.D5.selectedIndex < 0)
  {
    alert("Please select one of the \"What Size?\" options.");
    theForm.D5.focus();
    return (false);
  }
  return (true);
}
//--></script><!--webbot BOT="GeneratedScript" endspan --><FORM METHOD="POST" ACTION="t-shirts.asp" name="FrontPage_Form1" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" webbot-action="--WEBBOT-SELF--">
<!--WEBBOT BOT=SaveDatabase SuggestedExt="asp" S-DataConnection="t-shirts" S-RecordSource="Results" U-Database-URL="../fpdb/t-shirts.mdb" U-Confirmation-Url="t-shirtconfirmation.asp" S-Builtin-Fields="Timestamp" S-Builtin-DBFields="Timestamp" S-Form-Fields="D3 Ordering_OrderQty1 Ordering_OrderDesc0 StreetAddress D4 Ordering_OrderQty2 Ordering_OrderDesc1 D5 Ordering_OrderQty3 Ordering_OrderDesc2 Cell_Phone Address2 Ordering_OrderQty4 Ordering_OrderDesc3 Ordering_OrderDesc4 FullName Email City Home_Phone ZipCode D1 State D2 Ordering_OrderQty0" S-Form-DBFields="D3 Ordering_OrderQty1 Ordering_OrderDesc0 StreetAddress D4 Ordering_OrderQty2 Ordering_OrderDesc1 D5 Ordering_OrderQty3 Ordering_OrderDesc2 Cell_Phone Address2 Ordering_OrderQty4 Ordering_OrderDesc3 Ordering_OrderDesc4 FullName Email City Home_Phone ZipCode D1 State D2 Ordering_OrderQty0" U-ASP-Include-Url="../_fpclass/fpdbform.inc" startspan
--><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" i-checksum="34604" endspan --><UL>
<LI>
<P>
Please provide the following contact information:</P>
<TABLE>
<TR>
<TD ALIGN="right">
<EM>Name</EM></TD>
<TD>
&nbsp;<!--webbot bot="Validation" s-display-name="Full Name" b-value-required="TRUE" i-minimum-length="2" i-maximum-length="100" --><INPUT NAME="FullName" SIZE=35 maxlength="100">
</TD>
</TR>
<TR>
<TD ALIGN="right">
<EM>Street Address</EM></TD>
<TD>
&nbsp;<!--webbot bot="Validation" s-display-name="Street Address" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="100" --><INPUT NAME="StreetAddress" SIZE=35 maxlength="100">
</TD>
</TR>
<TR>
<TD ALIGN="right">
<EM>Address (cont.)</EM></TD>
<TD>
<INPUT NAME="Address2" SIZE=35>
</TD>
</TR>
<TR>
<TD ALIGN="right">
<EM>City</EM></TD>
<TD>
&nbsp;<!--webbot bot="Validation" s-display-name="City" b-value-required="TRUE" i-minimum-length="4" i-maximum-length="100" --><INPUT NAME="City" SIZE=35 maxlength="100">
</TD>
</TR>
<TR>
<TD ALIGN="right">
<EM>State/Province</EM></TD>
<TD>
&nbsp;<!--webbot bot="Validation" b-value-required="TRUE" i-minimum-length="2" i-maximum-length="30" --><INPUT NAME="State" SIZE=35 maxlength="30">
</TD>
</TR>
<TR>
<TD ALIGN="right">
<EM>Zip/Postal Code</EM></TD>
<TD>
&nbsp;<!--webbot bot="Validation" s-display-name="Zip Code" b-value-required="TRUE" i-minimum-length="5" i-maximum-length="12" --><INPUT NAME="ZipCode" SIZE=12 MAXLENGTH=12>
</TD>
</TR>
<TR>
<TD ALIGN="right">
<EM>Cell Phone</EM></TD>
<TD>
<INPUT NAME="Cell_Phone" SIZE=25 MAXLENGTH=25>
</TD>
</TR>
<TR>
<TD ALIGN="right">
<EM>Home Phone</EM></TD>
<TD>
&nbsp;<!--webbot bot="Validation" s-display-name="Home Phone" b-value-required="TRUE" i-minimum-length="7" i-maximum-length="25" --><INPUT NAME="Home_Phone" SIZE=25 MAXLENGTH=25>
</TD>
</TR>
<TR>
<TD ALIGN="right">
<EM>E-mail</EM></TD>
<TD>
&nbsp;<!--webbot bot="Validation" s-display-name="E-Mail" b-value-required="TRUE" i-minimum-length="6" i-maximum-length="100" --><INPUT NAME="Email" SIZE=25 maxlength="100">
</TD>
</TR>
</TABLE>
<LI>
<P>
Please provide the following ordering information:</P>
<TABLE>
<TR>
<TD>
<STRONG>QTY</STRONG></TD>
<TD>
<STRONG>DESCRIPTION (T-Shirt or Cap)</STRONG></TD>
<TD>
<b><font size="4">Size</font></b></TD>
</TR>
<TR><TD>
	&nbsp;<!--webbot bot="Validation" s-display-name="How Many?" b-value-required="TRUE" i-minimum-length="1" i-maximum-length="6" --><INPUT NAME="Ordering_OrderQty0" SIZE=6 MAXLENGTH=6></TD><TD>
	&nbsp;<!--webbot bot="Validation" s-display-name="What do you want to order?" b-value-required="TRUE" i-minimum-length="3" i-maximum-length="100" --><INPUT NAME="Ordering_OrderDesc0" SIZE=45 maxlength="100"></TD><TD>
	<!--webbot bot="Validation" s-display-name="What Size?" b-value-required="TRUE" -->
	<select size="1" name="D1">
	<option selected value="---------">---------</option>
	<option value="Small">Small</option>
	<option value="Medium">Medium</option>
	<option value="Large">Large</option>
	<option value="XL">XL</option>
	<option value="XXL">XXL</option>
	<option value="XXXL">XXXL</option>
	</select></TD></TR><TR><TD><INPUT TYPE=TEXT NAME="Ordering_OrderQty1" SIZE=6 MAXLENGTH=6></TD><TD><INPUT TYPE=TEXT NAME="Ordering_OrderDesc1" SIZE=45></TD><TD>
	<!--webbot bot="Validation" s-display-name="What Size?" b-value-required="TRUE" -->
	<select size="1" name="D2">
	<option selected value="---------">---------</option>
	<option value="Small">Small</option>
	<option value="Medium">Medium</option>
	<option value="Large">Large</option>
	<option value="XL">XL</option>
	<option value="XXL">XXL</option>
	<option value="XXXL">XXXL</option>
	</select></TD></TR><TR><TD><INPUT TYPE=TEXT NAME="Ordering_OrderQty2" SIZE=6 MAXLENGTH=6></TD><TD><INPUT TYPE=TEXT NAME="Ordering_OrderDesc2" SIZE=45></TD><TD>
	<!--webbot bot="Validation" s-display-name="What Size?" b-value-required="TRUE" -->
	<select size="1" name="D3">
	<option selected value="---------">---------</option>
	<option value="Small">Small</option>
	<option value="Medium">Medium</option>
	<option value="Large">Large</option>
	<option value="XL">XL</option>
	<option value="XXL">XXL</option>
	<option value="XXXL">XXXL</option>
	</select></TD></TR><TR><TD><INPUT TYPE=TEXT NAME="Ordering_OrderQty3" SIZE=6 MAXLENGTH=6></TD><TD><INPUT TYPE=TEXT NAME="Ordering_OrderDesc3" SIZE=45></TD><TD>
	<!--webbot bot="Validation" s-display-name="What Size?" b-value-required="TRUE" -->
	<select size="1" name="D4">
	<option selected value="---------">---------</option>
	<option value="Small">Small</option>
	<option value="Medium">Medium</option>
	<option value="Large">Large</option>
	<option value="XL">XL</option>
	<option value="XXL">XXL</option>
	<option value="XXXL">XXXL</option>
	</select></TD></TR><TR><TD><INPUT TYPE=TEXT NAME="Ordering_OrderQty4" SIZE=6 MAXLENGTH=6></TD><TD><INPUT TYPE=TEXT NAME="Ordering_OrderDesc4" SIZE=45></TD><TD>
	<!--webbot bot="Validation" s-display-name="What Size?" b-value-required="TRUE" -->
	<select size="1" name="D5">
	<option selected value="---------">---------</option>
	<option value="Small">Small</option>
	<option value="Medium">Medium</option>
	<option value="Large">Large</option>
	<option value="XL">XL</option>
	<option value="XXL">XXL</option>
	<option value="XXXL">XXXL</option>
	</select></TD></TR></TABLE>
</PRE>
</UL>
<INPUT TYPE=SUBMIT VALUE="Submit Form">
<INPUT TYPE=RESET VALUE="Reset Form">
</FORM>
<HR>
<H5>
Copyright � 2008 <b><font color="#ff0000">SOUTH SHORE TRAILBLAZERS, INC.</font></b>. All rights reserved. <BR>
Revised: <!--WEBBOT BOT=TimeStamp
    S-Type="EDITED"
    S-Format="%m/%d/%y" startspan
-->08/18/10<!--webbot bot="TimeStamp" i-checksum="12420" endspan --></H5></BODY></HTML>