% dim title title = "MayorSlay.com - Mini Polls" dim desc desc = "Official Website of Mayor Francis Slay - Mini Polls" dim keywords keywords = "Mayor Slay, Francis Slay, St. Louis Mayor, St. Louis, Mayor Slay, City of St. Louis, Missouri, Mini Polls, MayorSlay.com" dim section section = "Mini Poll: April Fool's Day" %>
Do you like April Fool's Day tricks? | |
Yes: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question1 FROM AprilFools WHERE Question1='Yes'"
rs.Open sql, conn
q1a = 0
do while rs.EOF = False
rs.MoveNext
q1a = q1a + 1
q1ap = Round((q1a / total1)*100)
Loop
if q1ap = "" then q1ap = 0
q1apw = q1ap * 2
%>
|
No: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question1 FROM AprilFools WHERE Question1='No'"
rs.Open sql, conn
q1b = 0
do while rs.EOF = False
rs.MoveNext
q1b = q1b + 1
q1bp = Round((q1b / total1)*100)
Loop
if q1bp = "" then q1bp = 0
q1bpw = q1bp * 2
%>
|
Have you ever been the subject of an April Fool's Day trick? | |
Yes: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question2 FROM AprilFools WHERE Question2='Yes'"
rs.Open sql, conn
q2a = 0
do while rs.EOF = False
rs.MoveNext
q2a = q2a + 1
q2ap = Round((q2a / total2)*100)
Loop
if q2ap = "" then q2ap = 0
q2apw = q2ap * 2
%>
|
Yes, but only a long time ago: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question2 FROM AprilFools WHERE Question2='YesBut'"
rs.Open sql, conn
q2b = 0
do while rs.EOF = False
rs.MoveNext
q2b = q2b + 1
q2bp = Round((q2b / total2)*100)
Loop
if q2bp = "" then q2bp = 0
q2bpw = q2bp * 2
%>
|
No: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question2 FROM AprilFools WHERE Question2='No'"
rs.Open sql, conn
q2c = 0
do while rs.EOF = False
rs.MoveNext
q2c = q2c + 1
q2cp = Round((q2c / total2)*100)
Loop
if q2cp = "" then q2cp = 0
q2cpw = q2cp * 2
%>
|
Do you play April Fool's Day tricks on other people? | |
Yes: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question3 FROM AprilFools WHERE Question3='Yes'"
rs.Open sql, conn
q3a = 0
do while rs.EOF = False
rs.MoveNext
q3a = q3a + 1
q3ap = Round((q3a / total3)*100)
Loop
if q3ap = "" then q3ap = 0
q3apw = q3ap * 2
%>
|
No tricking for me: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question3 FROM AprilFools WHERE Question3='No'"
rs.Open sql, conn
q3c = 0
do while rs.EOF = False
rs.MoveNext
q3c = q3c + 1
q3cp = Round((q3c / total3)*100)
Loop
if q3cp = "" then q3cp = 0
q3cpw = q3cp * 2
%>
|
Who is the best subject for an April Fool's Day trick? | |
A teacher |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question4 FROM AprilFools WHERE Question4='Teacher'"
rs.Open sql, conn
q4a = 0
do while rs.EOF = False
rs.MoveNext
q4a = q4a + 1
q4ap = Round((q4a / Total4)*100)
Loop
if q4ap = "" then q4ap = 0
q4apw = q4ap * 2
%>
|
A brother or sister: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question4 FROM AprilFools WHERE Question4='Sibling'"
rs.Open sql, conn
q4b = 0
do while rs.EOF = False
rs.MoveNext
q4b = q4b + 1
q4bp = Round((q4b / Total4)*100)
Loop
if q4bp = "" then q4bp = 0
q4bpw = q4bp * 2
%>
|
A parent or grandparent: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question4 FROM AprilFools WHERE Question4='Parent'"
rs.Open sql, conn
q4c = 0
do while rs.EOF = False
rs.MoveNext
q4c = q4c + 1
q4cp = Round((q4c / Total4)*100)
Loop
if q4cp = "" then q4cp = 0
q4cpw = q4cp * 2
%>
|
A neighbor: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question4 FROM AprilFools WHERE Question4='Neighbor'"
rs.Open sql, conn
q4d = 0
do while rs.EOF = False
rs.MoveNext
q4d = q4d + 1
q4dp = Round((q4d / Total4)*100)
Loop
if q4dp = "" then q4dp = 0
q4dpw = q4dp * 2
%>
|
A co-worker: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question4 FROM AprilFools WHERE Question4='Worker'"
rs.Open sql, conn
q4e = 0
do while rs.EOF = False
rs.MoveNext
q4e = q4e + 1
q4ep = Round((q4e / Total4)*100)
Loop
if q4ep = "" then q4ep = 0
q4epw = q4ep * 2
%>
|
A boss: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question4 FROM AprilFools WHERE Question4='Boss'"
rs.Open sql, conn
q4f = 0
do while rs.EOF = False
rs.MoveNext
q4f = q4f + 1
q4fp = Round((q4f / Total4)*100)
Loop
if q4fp = "" then q4fp = 0
q4fpw = q4fp * 2
%>
|
An unsuspecting stranger: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question4 FROM AprilFools WHERE Question4='Stranger'"
rs.Open sql, conn
q4g = 0
do while rs.EOF = False
rs.MoveNext
q4g = q4g + 1
q4gp = Round((q4g / Total4)*100)
Loop
if q4gp = "" then q4gp = 0
q4gpw = q4gp * 2
%>
|
What is the most important rule for an April Fool's Day trick? | |
Don't really hurt anybody: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question5 FROM AprilFools WHERE Question5='Hurt'"
rs.Open sql, conn
q5a = 0
do while rs.EOF = False
rs.MoveNext
q5a = q5a + 1
q5ap = Round((q5a / total)*100)
Loop
if q5ap = "" then q5ap = 0
q5apw = q5ap * 2
%>
|
Make sure that nobody is seriously embarrassed: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question5 FROM AprilFools WHERE Question5='Embarrass'"
rs.Open sql, conn
q5b = 0
do while rs.EOF = False
rs.MoveNext
q5b = q5b + 1
q5bp = Round((q5b / total5)*100)
Loop
if q5bp = "" then q5bp = 0
q5bpw = q5bp * 2
%>
|
Make sure the trick is actually funny: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question5 FROM AprilFools WHERE Question5='Funny'"
rs.Open sql, conn
q5c = 0
do while rs.EOF = False
rs.MoveNext
q5c = q5c + 1
q5cp = Round((q5c / total5)*100)
Loop
if q5cp = "" then q5cp = 0
q5cpw = q5cp * 2
%>
|
Make sure the trick is funny to people who don't love South Park: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question5 FROM AprilFools WHERE Question5='SouthPark'"
rs.Open sql, conn
q5d = 0
do while rs.EOF = False
rs.MoveNext
q5d = q5d + 1
q5dp = Round((q5d / total5)*100)
Loop
if q5dp = "" then q5dp = 0
q5dpw = q5dp * 2
%>
|
Let someone else get blamed for it: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question5 FROM AprilFools WHERE Question5='Blame'"
rs.Open sql, conn
q5e = 0
do while rs.EOF = False
rs.MoveNext
q5e = q5e + 1
q5ep = Round((q5e / total5)*100)
Loop
if q5ep = "" then q5ep = 0
q5epw = q5ep * 2
%>
|
More than one of the choices above: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question5 FROM AprilFools WHERE Question5='More'"
rs.Open sql, conn
q5f = 0
do while rs.EOF = False
rs.MoveNext
q5f = q5f + 1
q5fp = Round((q5f / total5)*100)
Loop
if q5fp = "" then q5fp = 0
q5fpw = q5fp * 2
%>
|
Have you ever had one of your April Fool's Day tricks backfire or go wrong? | |
Yes: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question6 FROM AprilFools WHERE Question6='Yes'"
rs.Open sql, conn
q6a = 0
do while rs.EOF = False
rs.MoveNext
q6a = q6a + 1
q6ap = Round((q6a / total6)*100)
Loop
if q6ap = "" then q6ap = 0
q6apw = q6ap * 2
%>
|
No: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question6 FROM AprilFools WHERE Question6='No'"
rs.Open sql, conn
q6b = 0
do while rs.EOF = False
rs.MoveNext
q6b = q6b + 1
q6bp = Round((q6b / total6)*100)
Loop
if q6bp = "" then q6bp = 0
q6bpw = q6bp * 2
%>
|
What do you think of newspapers and other media outlets planting stories as hoaxes on April 1st? | |
It's usually good fun. I like it: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question7 FROM AprilFools WHERE Question7='Fun'"
rs.Open sql, conn
q7a = 0
do while rs.EOF = False
rs.MoveNext
q7a = q7a + 1
q7ap = Round((q7a / total7)*100)
Loop
if q7ap = "" then q7ap = 0
q7apw = q7ap * 2
%>
|
It's usually lame. I hate it: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question7 FROM AprilFools WHERE Question7='Lame'"
rs.Open sql, conn
q7b = 0
do while rs.EOF = False
rs.MoveNext
q7b = q7b + 1
q7bp = Round((q7b / total7)*100)
Loop
if q7bp = "" then q7bp = 0
q7bpw = q7bp * 2
%>
|
It's hard to tell the difference in some newspapers between a hoax story and a real one. I don't care: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question7 FROM AprilFools WHERE Question7='Hard'"
rs.Open sql, conn
q7c = 0
do while rs.EOF = False
rs.MoveNext
q7c = q7c + 1
q7cp = Round((q7c / total7)*100)
Loop
if q7cp = "" then q7cp = 0
q7cpw = q7cp * 2
%>
|
How do you rate the 1986 horror movie April Fool's Day? | |
Two thumbs up: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question8 FROM AprilFools WHERE Question8='TwoUp'"
rs.Open sql, conn
q8a = 0
do while rs.EOF = False
rs.MoveNext
q8a = q8a + 1
q8ap = Round((q8a / total8)*100)
Loop
if q8ap = "" then q8ap = 0
q8apw = q8ap * 2
%>
|
One thumb up: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question8 FROM AprilFools WHERE Question8='OneUp'"
rs.Open sql, conn
q8b = 0
do while rs.EOF = False
rs.MoveNext
q8b = q8b + 1
q8bp = Round((q8b / total8)*100)
Loop
if q8bp = "" then q8bp = 0
q8bpw = q8bp * 2
%>
|
One thumb down: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question8 FROM AprilFools WHERE Question8='OneDown'"
rs.Open sql, conn
q8c = 0
do while rs.EOF = False
rs.MoveNext
q8c = q8c + 1
q8cp = Round((q8c / total8)*100)
Loop
if q8cp = "" then q8cp = 0
q8cpw = q8cp * 2
%>
|
Two thumbs down: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question8 FROM AprilFools WHERE Question8='TwoDown'"
rs.Open sql, conn
q8d = 0
do while rs.EOF = False
rs.MoveNext
q8d = q8d + 1
q8dp = Round((q8d / total8)*100)
Loop
if q8dp = "" then q8dp = 0
q8dpw = q8dp * 2
%>
|
Stop with the thumbs. I haven't seen the movie.: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question8 FROM AprilFools WHERE Question8='NoThumbs'"
rs.Open sql, conn
q8e = 0
do while rs.EOF = False
rs.MoveNext
q8e = q8e + 1
q8ep = Round((q8e / total8)*100)
Loop
if q8ep = "" then q8ep = 0
q8epw = q8ep * 2
%>
|
It's on my Netflix list: |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question8 FROM AprilFools WHERE Question8='Netflix'"
rs.Open sql, conn
q8f = 0
do while rs.EOF = False
rs.MoveNext
q8f = q8f + 1
q8fp = Round((q8f / total8)*100)
Loop
if q8fp = "" then q8fp = 0
q8fpw = q8fp * 2
%>
|
Which of these famous April Fool's Day tricks do you like best? | |
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question9 FROM AprilFools WHERE Question9='Finch'"
rs.Open sql, conn
q9a = 0
do while rs.EOF = False
rs.MoveNext
q9a = q9a + 1
q9ap = Round((q9a / total9)*100)
Loop
if q9ap = "" then q9ap = 0
q9apw = q9ap * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question9 FROM AprilFools WHERE Question9='Gates'"
rs.Open sql, conn
q9b = 0
do while rs.EOF = False
rs.MoveNext
q9b = q9b + 1
q9bp = Round((q9b / total9)*100)
Loop
if q9bp = "" then q9bp = 0
q9bpw = q9bp * 2
%>
|
The announcement that Taco Bell had purchased the Liberty Bell (1996): |
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question9 FROM AprilFools WHERE Question9='Bell'"
rs.Open sql, conn
q9c = 0
do while rs.EOF = False
rs.MoveNext
q9c = q9c + 1
q9cp = Round((q9c / total9)*100)
Loop
if q9cp = "" then q9cp = 0
q9cpw = q9cp * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question9 FROM AprilFools WHERE Question9='Left'"
rs.Open sql, conn
q9d = 0
do while rs.EOF = False
rs.MoveNext
q9d = q9d + 1
q9dp = Round((q9d / total9)*100)
Loop
if q9dp = "" then q9dp = 0
q9dpw = q9dp * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question9 FROM AprilFools WHERE Question9='Needle'"
rs.Open sql, conn
q9e = 0
do while rs.EOF = False
rs.MoveNext
q9e = q9e + 1
q9ep = Round((q9e / total9)*100)
Loop
if q9ep = "" then q9ep = 0
q9epw = q9ep * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question9 FROM AprilFools WHERE Question9='Pets'"
rs.Open sql, conn
q9f = 0
do while rs.EOF = False
rs.MoveNext
q9f = q9f + 1
q9fp = Round((q9f / total9)*100)
Loop
if q9fp = "" then q9fp = 0
q9fpw = q9fp * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question9 FROM AprilFools WHERE Question9='Google'"
rs.Open sql, conn
q9g = 0
do while rs.EOF = False
rs.MoveNext
q9g = q9g + 1
q9gp = Round((q9g / total9)*100)
Loop
if q9gp = "" then q9gp = 0
q9gpw = q9gp * 2
%>
|
Which of these April Fool's Day tricks do you like best? | |
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question10 FROM AprilFools WHERE Question10='Remotes'"
rs.Open sql, conn
q10a = 0
do while rs.EOF = False
rs.MoveNext
q10a = q10a + 1
q10ap = Round((q10a / total10)*100)
Loop
if q10ap = "" then q10ap = 0
q10apw = q10ap * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question10 FROM AprilFools WHERE Question10='Lips'"
rs.Open sql, conn
q10b = 0
do while rs.EOF = False
rs.MoveNext
q10b = q10b + 1
q10bp = Round((q10b / total10)*100)
Loop
if q10bp = "" then q10bp = 0
q10bpw = q10bp * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question10 FROM AprilFools WHERE Question10='Copy'"
rs.Open sql, conn
q10c = 0
do while rs.EOF = False
rs.MoveNext
q10c = q10c + 1
q10cp = Round((q10c / total10)*100)
Loop
if q10cp = "" then q10cp = 0
q10cpw = q10cp * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question10 FROM AprilFools WHERE Question10='Website'"
rs.Open sql, conn
q10d = 0
do while rs.EOF = False
rs.MoveNext
q10d = q10d + 1
q10dp = Round((q10d / total10)*100)
Loop
if q10dp = "" then q10dp = 0
q10dpw = q10dp * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question10 FROM AprilFools WHERE Question10='Alarm'"
rs.Open sql, conn
q10e = 0
do while rs.EOF = False
rs.MoveNext
q10e = q10e + 1
q10ep = Round((q10e / total10)*100)
Loop
if q10ep = "" then q10ep = 0
q10epw = q10ep * 2
%>
|
|
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/20060330AprilFools.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Question10 FROM AprilFools WHERE Question10='Elevator'"
rs.Open sql, conn
q10f = 0
do while rs.EOF = False
rs.MoveNext
q10f = q10f + 1
q10fp = Round((q10f / total10)*100)
Loop
if q10fp = "" then q10fp = 0
q10fpw = q10fp * 2
%>
|
Note: Due to rounding, results for some questions may not total 100%.