<% 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, Octoberbest, Rocktoberfest, smorgasbord, public opinion, syntax, satisfied" dim section section = "Mini Poll: Octoberfest of Public Opinion" %>
[ Mini Polls Homepage ]

Current Totals:

<% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT * FROM octoberfest" rs.Open sql, conn total = 0 do while rs.EOF = False rs.MoveNext total = total + 1 Loop %> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question1 FROM octoberfest WHERE Question1>''" rs.Open sql, conn total1 = 0 do while rs.EOF = False rs.MoveNext total1 = total1 + 1 Loop %> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question2 FROM octoberfest WHERE Question2>''" rs.Open sql, conn total2 = 0 do while rs.EOF = False rs.MoveNext total2 = total2 + 1 Loop %> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question3 FROM octoberfest WHERE Question3>''" rs.Open sql, conn total3 = 0 do while rs.EOF = False rs.MoveNext total3 = total3 + 1 Loop %> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question4 FROM octoberfest WHERE Question4>''" rs.Open sql, conn total4 = 0 do while rs.EOF = False rs.MoveNext total4 = total4 + 1 Loop %> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question5 FROM octoberfest WHERE Question5>''" rs.Open sql, conn total5 = 0 do while rs.EOF = False rs.MoveNext total5 = total5 + 1 Loop %> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question6 FROM octoberfest WHERE Question6>''" rs.Open sql, conn total6 = 0 do while rs.EOF = False rs.MoveNext total6 = total6 + 1 Loop %> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question7 FROM octoberfest WHERE Question7>''" rs.Open sql, conn total7 = 0 do while rs.EOF = False rs.MoveNext total7 = total7 + 1 Loop %> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question8 FROM octoberfest WHERE Question8>''" rs.Open sql, conn total8 = 0 do while rs.EOF = False rs.MoveNext total8 = total8 + 1 Loop %> <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question9 FROM octoberfest WHERE Question9>''" rs.Open sql, conn total9 = 0 do while rs.EOF = False rs.MoveNext total9 = total9 + 1 Loop %>

Best pro sports coach?


The Rams' Mike Martz (or whomever):


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question1 FROM octoberfest WHERE Question1='Martz'" 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 %>

 <% Response.Write q1ap & "%" %>

The Cardinals' Tony LaRussa:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question1 FROM octoberfest WHERE Question1='LaRussa'" 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 %>

 <% Response.Write q1bp & "%" %>

The Blues' Mike Kitchen:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question1 FROM octoberfest WHERE Question1='Kitchen'" rs.Open sql, conn q1c = 0 do while rs.EOF = False rs.MoveNext q1c = q1c + 1 q1cp = Round((q1c / total1)*100) Loop if q1cp = "" then q1cp = 0 q1cpw = q1cp * 2 %>

 <% Response.Write q1cp & "%" %>

Beats me. I hate sports:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question1 FROM octoberfest WHERE Question1='Hate'" rs.Open sql, conn q1d = 0 do while rs.EOF = False rs.MoveNext q1d = q1d + 1 q1dp = Round((q1d / total1)*100) Loop if q1dp = "" then q1dp = 0 q1dpw = q1dp * 2 %>

 <% Response.Write q1dp & "%" %>

 

Most effective local member of Congress?


US Rep. Todd Akin:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question2 FROM octoberfest WHERE Question2='Akin'" 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 %>

 <% Response.Write q2ap & "%" %>

US Sen. Kit Bond:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question2 FROM octoberfest WHERE Question2='Bond'" 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 %>

 <% Response.Write q2bp & "%" %>

US Rep. Russ Carnahan:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question2 FROM octoberfest WHERE Question2='Carnahan'" 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 %>

 <% Response.Write q2cp & "%" %>

US Rep. Lacy Clay:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question2 FROM octoberfest WHERE Question2='Clay'" rs.Open sql, conn q2d = 0 do while rs.EOF = False rs.MoveNext q2d = q2d + 1 q2dp = Round((q2d / total2)*100) Loop if q2dp = "" then q2dp = 0 q2dpw = q2dp * 2 %>

 <% Response.Write q2dp & "%" %>

US Sen. Jim Talent:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question2 FROM octoberfest WHERE Question2='Talent'" rs.Open sql, conn q2e = 0 do while rs.EOF = False rs.MoveNext q2e = q2e + 1 q2ep = Round((q2e / total2)*100) Loop if q2ep = "" then q2ep = 0 q2epw = q2ep * 2 %>

 <% Response.Write q2ep & "%" %>

 

Top item on my "self-improvement" list?


Attend the Symphony:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question3 FROM octoberfest WHERE Question3='Symphony'" 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 %>

 <% Response.Write q3ap & "%" %>

Sign up for a gym:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question3 FROM octoberfest WHERE Question3='Gym'" rs.Open sql, conn q3b = 0 do while rs.EOF = False rs.MoveNext q3b = q3b + 1 q3bp = Round((q3b / total3)*100) Loop if q3bp = "" then q3bp = 0 q3bpw = q3bp * 2 %>

 <% Response.Write q3bp & "%" %>

Visit the Art Museum:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question3 FROM octoberfest WHERE Question3='Art'" 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 %>

 <% Response.Write q3cp & "%" %>

Use public transportation:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question3 FROM octoberfest WHERE Question3='Public'" rs.Open sql, conn q3d = 0 do while rs.EOF = False rs.MoveNext q3d = q3d + 1 q3dp = Round((q3d / total3)*100) Loop if q3dp = "" then q3dp = 0 q3dpw = q3dp * 2 %>

 <% Response.Write q3dp & "%" %>

 

Most representative local food?


Frozen custard:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question4 FROM octoberfest WHERE Question4='Custard'" 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 %>

 <% Response.Write q4ap & "%" %>

Mostaccioli:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question4 FROM octoberfest WHERE Question4='Mostaccioli'" 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 %>

 <% Response.Write q4bp & "%" %>

Pork steaks:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question4 FROM octoberfest WHERE Question4='Pork'" 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 %>

 <% Response.Write q4cp & "%" %>

Toasted ravioli:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question4 FROM octoberfest WHERE Question4='Ravioli'" 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 %>

 <% Response.Write q4dp & "%" %>

 

Favorite radio band?


AM:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question5 FROM octoberfest WHERE Question5='AM'" rs.Open sql, conn q5a = 0 do while rs.EOF = False rs.MoveNext q5a = q5a + 1 q5ap = Round((q5a / total5)*100) Loop if q5ap = "" then q5ap = 0 q5apw = q5ap * 2 %>

 <% Response.Write q5ap & "%" %>

FM:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question5 FROM octoberfest WHERE Question5='FM'" 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 %>

 <% Response.Write q5bp & "%" %>

Satellite:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question5 FROM octoberfest WHERE Question5='Satellite'" 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 %>

 <% Response.Write q5cp & "%" %>

 

Item I would like to see added to Mayor Slay's wardrobe?


A pair of jeans:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question6 FROM octoberfest WHERE Question6='Jeans'" 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 %>

 <% Response.Write q6ap & "%" %>

A hat:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question6 FROM octoberfest WHERE Question6='Hat'" 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 %>

 <% Response.Write q6bp & "%" %>

A bow tie:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question6 FROM octoberfest WHERE Question6='Bowtie'" rs.Open sql, conn q6c = 0 do while rs.EOF = False rs.MoveNext q6c = q6c + 1 q6cp = Round((q6c / total6)*100) Loop if q6cp = "" then q6cp = 0 q6cpw = q6cp * 2 %>

 <% Response.Write q6cp & "%" %>

An earring:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question6 FROM octoberfest WHERE Question6='Earring'" rs.Open sql, conn q6d = 0 do while rs.EOF = False rs.MoveNext q6d = q6d + 1 q6dp = Round((q6d / total6)*100) Loop if q6dp = "" then q6dp = 0 q6dpw = q6dp * 2 %>

 <% Response.Write q6dp & "%" %>

An "I ♥ St. Louis" T-shirt:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question6 FROM octoberfest WHERE Question6='Tshirt'" rs.Open sql, conn q6e = 0 do while rs.EOF = False rs.MoveNext q6e = q6e + 1 q6ep = Round((q6e / total6)*100) Loop if q6ep = "" then q6ep = 0 q6epw = q6ep * 2 %>

 <% Response.Write q6ep & "%" %>

 

Favorite local weekly newspaper?


The Argus:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question7 FROM octoberfest WHERE Question7='Argus'" 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 %>

 <% Response.Write q7ap & "%" %>

Evening Whirl:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question7 FROM octoberfest WHERE Question7='Whirl'" 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 %>

 <% Response.Write q7bp & "%" %>

The Riverfront Times:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question7 FROM octoberfest WHERE Question7='RFT'" 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 %>

 <% Response.Write q7cp & "%" %>

The Sentinel:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question7 FROM octoberfest WHERE Question7='Sentinel'" rs.Open sql, conn q7d = 0 do while rs.EOF = False rs.MoveNext q7d = q7d + 1 q7dp = Round((q7d / total7)*100) Loop if q7dp = "" then q7dp = 0 q7dpw = q7dp * 2 %>

 <% Response.Write q7dp & "%" %>

St. Louis American:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question7 FROM octoberfest WHERE Question7='American'" rs.Open sql, conn q7e = 0 do while rs.EOF = False rs.MoveNext q7e = q7e + 1 q7ep = Round((q7e / total7)*100) Loop if q7ep = "" then q7ep = 0 q7epw = q7ep * 2 %>

 <% Response.Write q7ep & "%" %>

St. Louis Review:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question7 FROM octoberfest WHERE Question7='Review'" rs.Open sql, conn q7f = 0 do while rs.EOF = False rs.MoveNext q7f = q7f + 1 q7fp = Round((q7f / total7)*100) Loop if q7fp = "" then q7fp = 0 q7fpw = q7fp * 2 %>

 <% Response.Write q7fp & "%" %>

 

Best Forest Park amenity?


Boathouse:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question8 FROM octoberfest WHERE Question8='Boathouse'" 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 %>

 <% Response.Write q8ap & "%" %>

Jewel Box:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question8 FROM octoberfest WHERE Question8='Jewel'" 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 %>

 <% Response.Write q8bp & "%" %>

The Muny:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question8 FROM octoberfest WHERE Question8='Muny'" 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 %>

 <% Response.Write q8cp & "%" %>

Post-Dispatch Lake:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question8 FROM octoberfest WHERE Question8='Lake'" 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 %>

 <% Response.Write q8dp & "%" %>

World's Fair Pavilion:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question8 FROM octoberfest WHERE Question8='Pavilion'" 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 %>

 <% Response.Write q8ep & "%" %>

 

The Post-Dispatch's new makeover makes it most look like?


A sophisticated urban daily newspaper:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question9 FROM octoberfest WHERE Question9='urban'" 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 %>

 <% Response.Write q9ap & "%" %>

A bad high school newspaper:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question9 FROM octoberfest WHERE Question9='bad'" 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 %>

 <% Response.Write q9bp & "%" %>

Who knows. I read stltoday.com:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/101305octoberfest.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question9 FROM octoberfest WHERE Question9='who'" 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 %>

 <% Response.Write q9cp & "%" %>

 

Note: Due to rounding, results for some questions may not total 100%.


<% Response.Write total %>