<% 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" dim section section = "St. Louis Parks Mini Poll Results" %>
[ Mini Polls Homepage ]

Final Totals:

<% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT * FROM parks" 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/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question1 FROM parks 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/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question2 FROM parks 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/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question3 FROM parks 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/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question4 FROM parks 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/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question5 FROM parks 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/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question6 FROM parks 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/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question7 FROM parks WHERE Question7>''" rs.Open sql, conn total7 = 0 do while rs.EOF = False rs.MoveNext total7 = total7 + 1 Loop %>

How often do you visit the park closest to your home?


Daily, or a few times a week:


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

A few times a month:


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

A few times a month:


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

I haven't been in that park since the kids/dogs left home:


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

 

How often do you visit Forest Park?


Daily, or a few times a week:


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

A few times a month:


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

A few times a year:


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

Never:


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

Forest Park is the park closest to my home, so I have already answered this question:


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

 

How satisfied are you with the condition of the park closest to your home?


Very or somewhat satisfied:


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

Somewhat or very dissatisfied:


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

 

Which single amenity would most improve the park closest to your home?


Restrooms:


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

Playing fields:


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

BBQ pits:


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

Basketball hoops:


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

Public art:


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

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

Lights:


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

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

Trash cans:


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

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

Closed circuit security cameras:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question4 FROM parks WHERE Question4='Camera'" rs.Open sql, conn q4h = 0 do while rs.EOF = False rs.MoveNext q4h = q4h + 1 q4hp = Round((q4h / total4)*100) Loop if q4hp = "" then q4hp = 0 q4hpw = q4hp * 2 %>

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

Designated dog walking areas:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question4 FROM parks WHERE Question4='Dog'" rs.Open sql, conn q4i = 0 do while rs.EOF = False rs.MoveNext q4i = q4i + 1 q4ip = Round((q4i / total4)*100) Loop if q4ip = "" then q4ip = 0 q4ipw = q4ip * 2 %>

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

 

How safe do you feel when visiting Forest Park?


Safe:


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

Unsafe:


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

 

Do you or your children participate in organized activities in Forest Park?


I do:


 <% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/Data/051705parkpoll.mdb")) set rs = Server.CreateObject("ADODB.recordset") sql="SELECT Question6 FROM parks WHERE Question6='Me'" rs.Open sql, conn q6a = 0 do while rs.EOF = False rs.MoveNext q6a = q6a + 1 q6ap = Round((q6a / total6)*100) Loop if q5ap = "" then q6ap = 0 q6apw = q6ap * 2 %>

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

My kids do:


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

My kids and I both do:


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

Neither my kids or I do:


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

 

Do you think that St. Louis City and St. Louis County ought to operate a single regional parks department?


Yes:


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

No:


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

 


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


<% Response.Write total %>