<% 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, gas caps, gas prices" dim section section = "Mini Poll: Gas Caps" %>
[ Mini Polls Homepage ]

Current Totals:

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

Thinking about how much driving you do, would you say that compared to this time a year ago you're driving more, less, or about the same?


More:


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

Less:


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

About the same:


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

 

How concerned are you that higher gas prices will seriously damage the region's economy? Are you very worried, somewhat worried, not too worried, or not worried at all?


Very worried:


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

Somewhat worried:


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

Not too worried:


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

Not worried at all:


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

 

If the price of gas in St. Louis remains at $3.00 a gallon or goes higher, do you think you'll find some way to cut back on your driving or drive about the same amount and find a way to pay for it?


Cut back on driving:


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

Find a way to pay for the gas:


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

 

Look into your crystal ball. Which situation is most likely to be the case at this time next year?


Gas prices will be higher than they are today:


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

Gas prices will be about the same as they are today:


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

Gas prices will be lower than they are today:


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

 

Which situation most closely describes your own situation?


Live in the City, work in the City:


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

Live in the County, work in the City:


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

Live in the City, work in the County:


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

Live in the County, work in the County:


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

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

 

Which vehicle type is your primary means of transportation?


Gas powered car or motorcycle:


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

Gas powered SUV or truck:


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

Hybrid vehicle:


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

Bicycle:


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

Walking:


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

 

What is the most likely strategy you're going to use to save money on gas?


Ride public transportation more often:


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

Walk or ride my bike more often:


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

Car pool with friends or co-workers:


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

Move or change jobs:


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

I'm not going to do anything different:


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

 

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


<% Response.Write total %>