<%
'usercity = "'" & request.querystring("city") & "'"
getCityDetail = "SELECT sVotingPrecinctID, sPollPlaceAbbr, szSamBalAddress1, szSamBalAddress2, status FROM polltrack ORDER BY svotingPrecinctID"
set congetCityDetail = con.execute(getCityDetail)
response.write "
"
do while not congetCityDetail.eof
if congetCitydetail.fields("status") = "At Polling Place" then
response.write "" & congetCityDetail.fields("sVotingPrecinctID") & " | " & congetCityDetail.fields("sPollPlaceAbbr") & " | " & congetCityDetail.fields("szSamBalAddress1") & " | " & congetCityDetail.fields("szSamBalAddress2") & " | " & congetCityDetail.fields("status") & " |
" & vbcrlf
elseif congetCitydetail.fields("status") = "Left Collection Center" then
response.write "" & congetCityDetail.fields("sVotingPrecinctID") & " | " & congetCityDetail.fields("sPollPlaceAbbr") & " | " & congetCityDetail.fields("szSamBalAddress1") & " | " & congetCityDetail.fields("szSamBalAddress2") & " | " & congetCityDetail.fields("status") & " |
" & vbcrlf
elseif congetCitydetail.fields("status") = "At Registrar of Voters" then
response.write "" & congetCityDetail.fields("sVotingPrecinctID") & " | " & congetCityDetail.fields("sPollPlaceAbbr") & " | " & congetCityDetail.fields("szSamBalAddress1") & " | " & congetCityDetail.fields("szSamBalAddress2") & " | " & congetCityDetail.fields("status") & " |
" & vbcrlf
end if
conGetCityDetail.movenext
loop
%>