<%@LANGUAGE = JScript%> <%
var Cn = new ActiveXObject("ADODB.Connection");
var Sc = "driver={Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("sondaggio_home.mdb");
Cn.Open(Sc);
var a_Dom = Cn.Execute("SELECT domanda FROM domande WHERE id = 1");
var b_Dom = Cn.Execute("SELECT domanda FROM domande WHERE id = 2");
var c_Dom = Cn.Execute("SELECT domanda FROM domande WHERE id = 3");
var d_Dom = Cn.Execute("SELECT domanda FROM domande WHERE id = 4");
var a_Sql = Cn.Execute("SELECT COUNT(*) AS voto FROM voti WHERE voto = 'a'");
var b_Sql = Cn.Execute("SELECT COUNT(*) AS voto FROM voti WHERE voto = 'b'");
var c_Sql = Cn.Execute("SELECT COUNT(*) AS voto FROM voti WHERE voto = 'c'");
var d_Sql = Cn.Execute("SELECT COUNT(*) AS voto FROM voti WHERE voto = 'd'");
var TOT_Sql = Cn.Execute("SELECT COUNT(*) AS voto FROM voti WHERE voto = voto");
var a_Perc = Math.round((a_Sql("voto") / TOT_Sql("voto")) * 100);
var b_Perc = Math.round((b_Sql("voto") / TOT_Sql("voto")) * 100);
var c_Perc = Math.round((c_Sql("voto") / TOT_Sql("voto")) * 100);
var d_Perc = Math.round((d_Sql("voto") / TOT_Sql("voto")) * 100);
%>
Sondaggio
Testata Giornalistica registrata al Tribunale di Napoli (Reg. n° 32 del 30.3.11) - Direttore Responsabile: Francesco Paolo DE LIGUORO
Cerca nel sito
Le rubriche
Utenti online : <%= Application("collegati") %>
