<!--#include virtual ="/jackets/settings.asp"-->
<!--#include file="Connections/achiever.asp" -->
<%if request.form("studentname") <> "" then

Set Conexion = Server.CreateObject("ADODB.Connection") 
Conexion.Open MM_achiever_STRING


sql="INSERT INTO customers_customize (studentname, address, city, state, zip, phone, email, school, "
sql = sql + "cctype, ccnum, ccexpire, ccverification, bodystyle, collar, trim, color, color2, chenillefirst, chenillelast, chenilleright, "
sql = sql + "chenilleleft, chenilleletter, chenilleyear, firstnametype, yeartype, activities1, activitiesbar1, "
sql = sql + "activities2, activitiesbar2, activities3, activitiesbar3, activities4, activitiesbar4, activities5, "
sql = sql + "activitiesbar5, patches1, patches1state, patches1activity, patches1wording, patches1wordingcolor, "
sql = sql + "patches2, patches2state, patches2activity, patches2wording, patches2wordingcolor, patches3, "
sql = sql + "patches3state, patches3activity, patches3wording, patches3wordingcolor, patches4, patches4state, "
sql = sql + "patches4activity, patches4wording, patches4wordingcolor, patches5, patches5state, patches5activity, "
sql = sql + "patches5wording, patches5wordingcolor, chenillecolor, chaincolor, feltcolor, size, subtotal, tax, total"
sql = sql + ") VALUES("


sql= sql+"'"+request.form("studentname")+"',"
sql= sql+"'"+request.form("address")+"',"
sql= sql+"'"+request.form("city")+"',"
sql= sql+"'"+request.form("state")+"',"
sql= sql+"'"+request.form("zip")+"',"
sql= sql+"'"+request.form("phone")+"',"
sql= sql+"'"+request.form("email")+"',"
sql= sql+"'"+request.form("school")+"',"
sql= sql+"'"+request.form("cctype")+"',"
sql= sql+"'"+request.form("ccnum")+"',"
sql= sql+"'"+request.form("ccexpire")+"',"
sql= sql+"'"+request.form("ccverification")+"',"
sql= sql+"'"+request.form("bodystyle")+"',"
sql= sql+"'"+request.form("collar")+"',"
sql= sql+"'"+request.form("trim")+"',"
sql= sql+"'"+request.form("color")+"',"
sql= sql+"'"+request.form("color2")+"',"
sql= sql+"'"+request.form("chenillefirst")+"',"
sql= sql+"'"+request.form("chenillelast")+"',"
sql= sql+"'"+request.form("chenilleright")+"',"
sql= sql+"'"+request.form("chenilleleft")+"',"
sql= sql+"'"+request.form("chenilleletter")+"',"
sql= sql+"'"+request.form("chenilleyear")+"',"
sql= sql+"'"+request.form("firstnametype")+"',"
sql= sql+"'"+request.form("yeartype")+"',"
sql= sql+"'"+request.form("activities1")+"',"
sql= sql+"'"+request.form("activitiesbar1")+"',"
sql= sql+"'"+request.form("activities2")+"',"
sql= sql+"'"+request.form("activitiesbar2")+"',"
sql= sql+"'"+request.form("activities3")+"',"
sql= sql+"'"+request.form("activitiesbar3")+"',"
sql= sql+"'"+request.form("activities4")+"',"
sql= sql+"'"+request.form("activitiesbar4")+"',"
sql= sql+"'"+request.form("activities5")+"',"
sql= sql+"'"+request.form("activitiesbar5")+"',"
sql= sql+"'"+request.form("patches1")+"',"
sql= sql+"'"+request.form("patches1state")+"',"
sql= sql+"'"+request.form("patches1activity")+"',"
sql= sql+"'"+request.form("patches1wording")+"',"
sql= sql+"'"+request.form("patches1wordingcolor")+"',"
sql= sql+"'"+request.form("patches2")+"',"
sql= sql+"'"+request.form("patches2state")+"',"
sql= sql+"'"+request.form("patches2activity")+"',"
sql= sql+"'"+request.form("patches2wording")+"',"
sql= sql+"'"+request.form("patches2wordingcolor")+"',"
sql= sql+"'"+request.form("patches3")+"',"
sql= sql+"'"+request.form("patches3state")+"',"
sql= sql+"'"+request.form("patches3activity")+"',"
sql= sql+"'"+request.form("patches3wording")+"',"
sql= sql+"'"+request.form("patches3wordingcolor")+"',"
sql= sql+"'"+request.form("patches4")+"',"
sql= sql+"'"+request.form("patches4state")+"',"
sql= sql+"'"+request.form("patches4activity")+"',"
sql= sql+"'"+request.form("patches4wording")+"',"
sql= sql+"'"+request.form("patches4wordingcolor")+"',"
sql= sql+"'"+request.form("patches5")+"',"
sql= sql+"'"+request.form("patches5state")+"',"
sql= sql+"'"+request.form("patches5activity")+"',"
sql= sql+"'"+request.form("patches5wording")+"',"
sql= sql+"'"+request.form("patches5wordingcolor")+"',"
sql= sql+"'"+request.form("chenillecolor")+"',"
sql= sql+"'"+request.form("chaincolor")+"',"
sql= sql+"'"+request.form("feltcolor")+"',"
sql= sql+"'"+request.form("size")+"',"
sql= sql+"'"+request.form("subtotal")+"',"
sql= sql+"'"+request.form("tax")+"',"
sql= sql+"'"+request.form("total")+"')"

'response.write(sql)
'response.end
Set upd=conexion.Execute (sql)
Set upd= nothing
'response.write(sql)
response.redirect(GetHTTPSURL & "finishedschool.aspx?email=" & Replace(request.form("email"),"@","%40") & "&subtotal=" & request.form("subtotal") & "&tax=" & request.form("tax") & "&total=" & request.form("total"))
end if
%>