FollowMeT Quotes
Select options
What province are you in?
*
<% sqlProv = "SELECT provincia FROM tbFollowQuotes GROUP by provincia ORDER by provincia" set rsProv = dbConn.execute(sqlProv) %>
<% Do While Not rsProv.Eof %>
"><%=rsProv("provincia")%>
<% rsProv.MoveNext Loop %>
How old are you?
*
<% sqlEdad = "SELECT edad FROM tbFollowQuotes WHERE edad<>'-' GROUP by edad" set rsEdad = dbConn.execute(sqlEdad) %>
<% Do While Not rsEdad.Eof %>
"><%=rsEdad("edad")%>
<% rsEdad.MoveNext Loop %>
How old is your spouse/partner (if applicable)
<% sqlEdad = "SELECT edad FROM tbFollowQuotes GROUP by edad" set rsEdad = dbConn.execute(sqlEdad) %>
<% Do While Not rsEdad.Eof %>
"><%=rsEdad("edad")%>
<% rsEdad.MoveNext Loop %>
Please select the ages of all your children to be insured (if applicable):
1st Child:
<% sqlEdad = "SELECT edadhijos FROM tbFollowQuotes GROUP by edadhijos" set rsEdad = dbConn.execute(sqlEdad) %>
<% Do While Not rsEdad.Eof %>
"><%=rsEdad("edadhijos")%>
<% rsEdad.MoveNext Loop %>
2nd Child:
<% rsEdad.MoveFirst %>
<% Do While Not rsEdad.Eof %>
"><%=rsEdad("edadhijos")%>
<% rsEdad.MoveNext Loop %>
3rd Child:
<% rsEdad.MoveFirst %>
<% Do While Not rsEdad.Eof %>
"><%=rsEdad("edadhijos")%>
<% rsEdad.MoveNext Loop %>
4th Child:
<% rsEdad.MoveFirst %>
<% Do While Not rsEdad.Eof %>
"><%=rsEdad("edadhijos")%>
<% rsEdad.MoveNext Loop %>
5th Child:
<% rsEdad.MoveFirst %>
<% Do While Not rsEdad.Eof %>
"><%=rsEdad("edadhijos")%>
<% rsEdad.MoveNext Loop %>
6th Child:
<% rsEdad.MoveFirst %>
<% Do While Not rsEdad.Eof %>
"><%=rsEdad("edadhijos")%>
<% rsEdad.MoveNext Loop %>
<% if (Request("hfAction")="calculate") then %>
Results
Province:
<%=request.Form("province")%>
Basic
Enhanced
(no dental)
Enhanced
(dental)
Premier
<% sumBasic= 0 sumEn1 = 0 sumEn2 = 0 sumPrem = 0 %> <% sql1 = "SELECT * FROM tbFollowQuotes WHERE provincia = '" & request.Form("province") & "' and edad = '" & request.Form("edad") & "'" set rs1 = dbConn.execute(sql1) 'Response.Write(request.Form("province")&" "&request.Form("edad")) %>
You
$<%=rs1("basic")%>
$<%=rs1("enhancednd")%>
$<%=rs1("enhancedd")%>
$<%=rs1("premier")%>
<% sumBasic= Cdbl(rs1("basic")) sumEn1 = Cdbl(rs1("enhancednd")) sumEn2 = Cdbl(rs1("enhancedd")) sumPrem = Cdbl(rs1("premier")) %> <% if request.Form("edadesposa")<>"-" then sql1 = "SELECT * FROM tbFollowQuotes WHERE provincia = '" & request.Form("province") & "' and edadesposa = '" & request.Form("edadesposa") & "'" set rs1 = dbConn.execute(sql1) %>
Your spouse/partner
$<%=rs1("basic")%>
$<%=rs1("enhancednd")%>
$<%=rs1("enhancedd")%>
$<%=rs1("premier")%>
<% sumBasic= sumBasic+Cdbl(rs1("basic")) sumEn1 = sumEn1+Cdbl(rs1("enhancednd")) sumEn2 = sumEn2+Cdbl(rs1("enhancedd")) sumPrem = sumPrem+Cdbl(rs1("premier")) end if%> <% if request.Form("edadhijo1")<>"-" then sql1 = "SELECT * FROM tbFollowQuotes WHERE provincia = '" & request.Form("province") & "' and edadhijos = '" & request.Form("edadhijo1") & "'" set rs1 = dbConn.execute(sql1) %>
1st Child
$<%=rs1("basic")%>
$<%=rs1("enhancednd")%>
$<%=rs1("enhancedd")%>
$<%=rs1("premier")%>
<% sumBasic= sumBasic+Cdbl(rs1("basic")) sumEn1 = sumEn1+Cdbl(rs1("enhancednd")) sumEn2 = sumEn2+Cdbl(rs1("enhancedd")) sumPrem = sumPrem+Cdbl(rs1("premier")) end if%> <% if request.Form("edadhijo2")<>"-" then sql1 = "SELECT * FROM tbFollowQuotes WHERE provincia = '" & request.Form("province") & "' and edadhijos = '" & request.Form("edadhijo2") & "'" set rs1 = dbConn.execute(sql1) %>
2nd Child
$<%=rs1("basic")%>
$<%=rs1("enhancednd")%>
$<%=rs1("enhancedd")%>
$<%=rs1("premier")%>
<% sumBasic= sumBasic+Cdbl(rs1("basic")) sumEn1 = sumEn1+Cdbl(rs1("enhancednd")) sumEn2 = sumEn2+Cdbl(rs1("enhancedd")) sumPrem = sumPrem+Cdbl(rs1("premier")) end if%> <% if request.Form("edadhijo3")<>"-" then sql1 = "SELECT * FROM tbFollowQuotes WHERE provincia = '" & request.Form("province") & "' and edadhijos = '" & request.Form("edadhijo3") & "'" set rs1 = dbConn.execute(sql1) %>
3er Child
$<%=rs1("basic")%>
$<%=rs1("enhancednd")%>
$<%=rs1("enhancedd")%>
$<%=rs1("premier")%>
<% sumBasic= sumBasic+Cdbl(rs1("basic")) sumEn1 = sumEn1+Cdbl(rs1("enhancednd")) sumEn2 = sumEn2+Cdbl(rs1("enhancedd")) sumPrem = sumPrem+Cdbl(rs1("premier")) end if%> <% if request.Form("edadhijo4")<>"-" then sql1 = "SELECT * FROM tbFollowQuotes WHERE provincia = '" & request.Form("province") & "' and edadhijos = '" & request.Form("edadhijo4") & "'" set rs1 = dbConn.execute(sql1) %>
4th Child
$<%=rs1("basic")%>
$<%=rs1("enhancednd")%>
$<%=rs1("enhancedd")%>
$<%=rs1("premier")%>
<% sumBasic= sumBasic+Cdbl(rs1("basic")) sumEn1 = sumEn1+Cdbl(rs1("enhancednd")) sumEn2 = sumEn2+Cdbl(rs1("enhancedd")) sumPrem = sumPrem+Cdbl(rs1("premier")) end if%> <% if request.Form("edadhijo5")<>"-" then sql1 = "SELECT * FROM tbFollowQuotes WHERE provincia = '" & request.Form("province") & "' and edadhijos = '" & request.Form("edadhijo5") & "'" set rs1 = dbConn.execute(sql1) %>
5th Child
$<%=rs1("basic")%>
$<%=rs1("enhancednd")%>
$<%=rs1("enhancedd")%>
$<%=rs1("premier")%>
<% sumBasic= sumBasic+Cdbl(rs1("basic")) sumEn1 = sumEn1+Cdbl(rs1("enhancednd")) sumEn2 = sumEn2+Cdbl(rs1("enhancedd")) sumPrem = sumPrem+Cdbl(rs1("premier")) end if%> <% if request.Form("edadhijo6")<>"-" then sql1 = "SELECT * FROM tbFollowQuotes WHERE provincia = '" & request.Form("province") & "' and edadhijos = '" & request.Form("edadhijo6") & "'" set rs1 = dbConn.execute(sql1) %>
6th Child
$<%=rs1("basic")%>
$<%=rs1("enhancednd")%>
$<%=rs1("enhancedd")%>
$<%=rs1("premier")%>
<% sumBasic= sumBasic+Cdbl(rs1("basic")) sumEn1 = sumEn1+Cdbl(rs1("enhancednd")) sumEn2 = sumEn2+Cdbl(rs1("enhancedd")) sumPrem = sumPrem+Cdbl(rs1("premier")) end if%>
TOTAL
$<%=sumBasic%>
$<%=sumEn1%>
$<%=sumEn2%>
$<%=sumPrem%>
<%end if%>
Also in this Section:
Overview
|
Plan Summary
|
Comparison Chart
| Apply Now
About Us
-
Contact Info
-
Library
-
Links
-
Tell a Friend
-
Privacy Statement
