<% Dim rs, states 'strDSN = "ncanale_users2" 'set oConn = Server.CreateObject("ADODB.Connection") 'oConn.open "DSN=" & strDSN states = request.QueryString("state") ' states = request.Form("state") statesO = request.QueryString("stateO") stateOID = request.QueryString("stateOID") Dim statesplit, maxcount, firststate firststate = replace(states, "'" , "") 'response.Write(firststate) %> <% server.Scripttimeout = 1200 Set ones=Server.CreateObject("ADODB.recordset") Function preciooneonone(homepublic) dim diasdeempezar, descuentoa(10), cafeprice, homeprice, hoursstudent(10) 'response.Write("color " & colorid & "
") ones.open "SELECT * From tablaadiscount", oConn i =0 do until ones.EOF descuentoa(i) = ones("descuento") i = i+1 ones.movenext loop ones.close ones.open "SELECT * From tablavariables where Variable = 'B'", oConn do until ones.EOF variableb = ones("Value") ones.movenext loop ones.close ones.open "SELECT * From tablavariables where Variable = 'C'", oConn do until ones.EOF variablec = ones("Value") ones.movenext loop ones.close ones.open "SELECT * From tablavariables where Variable = 'A'", oConn do until ones.EOF variablea = ones("Value") ones.movenext loop ones.close 'neignew = Request.Form("neignew") 'rs.open "SELECT state FROM neighborhoodonlytbl where Neighborhoods = '"& neignew &"'", oConn ' do until rs.EOF ' statenew = rs("state") ' rs.movenext ' loop ' rs.close 'capacity utilization by state statenew = firststate if ((statenew = "FaceTime") or (statenew = "Skype") or (statenew = "") or (statenew = "Online")) then ones.open "SELECT * From tablabcapacityutilization", oConn hoursusedweek = 0 hoursofferedweek = 0 do until ones.EOF hoursusedweek = ones("HoursUsedWeek") + hoursusedweek hoursofferedweek = ones("HoursOfferedWeek") + hoursofferedweek ones.movenext loop ones.close capacity = round((hoursusedweek/hoursofferedweek)*100) else ones.open "SELECT * From tablabcapacityutilization where Neighborhood ='" & statenew & "'", oConn do until ones.EOF capacity = ones("CapacityUtilization") ones.movenext loop ones.close End if ones.open "SELECT * From tablacbaseprivate where Neighborhood ='" & statenew & "'", oConn do until ones.EOF hours = ones("HoursOfferedWeek") capacityutilb = ones("CapacityUtilization") neigdefault = hours + (capacityutilb*(capacity+variableb))/100 cafedefault = neigdefault homedefault = cafedefault + (cafedefault*variablea)/100 ones.movenext loop ones.close x = 16 cafeprice = (round((cafedefault -(cafedefault*descuentoa(0))/100)*x)) homeprice = (round((homedefault -(homedefault*descuentoa(0))/100)*x)) if homepublic = "cafe" then preciooneonone = "$"& cafeprice else preciooneonone = "$"& homeprice end if End Function %> Registration for One-on-One Spanish Classes for Adults in <%=firststate%>

SpanishBlackbelt

Application

This form is secure. It should take 10 minutes to fill it. Filling this form does not represent any commitment for you to join or pay for any of our sessions. No payment will be requested until you accept our proposal to be sent in response to this form.

Please submit this form ONLY if you are requesting an instructor for Tailored One-on-One Spanish Classes for Adults.

If instead, you are applying for a different class format or you are requesting an Spanish instructor for a different age bracket, or for your organization, please click here.

<%if states = "" then%>

Please choose your regional area*:


<%if statesO <> "" then%> <% else end if%>

*If taking classes online, please select "Online" on select state drop down.

<%end if%>
<%if states <> "" then%>
<%if firststate <> "" then %>

<% response.Write("You have selected: " & firststate)%>

<%end if%>

Fields with an asterisk ( * ) are required. Other fields are optional.

CURRENT SPANISH SKILLS
(Step 1 of 4)

* (1) In each dropdown, please select the statement that best describes your current Spanish language abilities:

SESSION CHARACTERISTICS
(Step 2 of 4)

*Speed (hours per week): (?)

To check prices for one-on-one sessions, please click here.

* Emphasis: (choose all that apply) (?)



    



    


SCHEDULE PREFERENCES
(Step 3 of 4)

* I rank these variables in this order....
* Preferred neighborhoods:
If over Skype, select Distant Learning as My Top Choice









* I can have my classes at... (?)
(choose all that apply)

* I could have my classes on...(choose all that apply; minimum length of any session is 2 hours)

Mondays

Tuesdays

Wednesdays

Thursdays

Fridays

Saturdays

Sundays

STUDENT INFORMATION
(Step 4 of 4)

| |

| |
* Student's date of birth




Student's gender(optional)

<%end if%>

In case of error, please save the filled form as a PDF and send it as an attachment to apply@spanishblackbelt.com.