visualizzare gli elementi di un database ogni tot secondi

[tosto73]

qualcuno mi aiuta a capire cosa sbaglio in questo script misto asp e javascript? grazie a tutti.

<script language="JavaScript">
var phrases = new Array();
<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("/dbase/db.mdb") & ";pwd=123456"

strSQL = "SELECT * FROM news ORDER BY data DESC"

Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn
objRS.movefirst
intnumero=0
do while not(objRS.eof)
%>
phrases[<%=intNumero%>]='<table width=100%><tr><td><font face=verdana size=2><%=objRS("banner")%></table>'
<%
intNumero = intNumero + 1
objRS.movenext
loop

objRS.Close
Set objRs = Nothing
objConn.Close
Set objConn = Nothing
%>
</script>



<div id="displayer"></div>

<script language="JavaScript">
<!--

function SymError()
{
return true;
}

window.onerror = SymError;

var SymRealWinOpen = window.open;

function SymWinOpen(url, name, attributes)
{
return (new Object());
}

window.open = SymWinOpen;

//-->
</script>

<script type="text/javascript">
nx=0,
oD=null;
window.onload=function(){
if (document.getElementById && (oD=document.getElementById("displayer"))){
oD.innerHTML=phrases[nx++];
setInterval(function(){
oD.innerHTML=phrases[nx++];
if (nx==phrases.length) nx=0;
},1500);
}else{
alert("Errore: Impossibile referenziare l'oggetto; o mancato supporto del DOM w3c");
}
}
</script>






<script language="JavaScript">
<!--
var SymRealOnLoad;
var SymRealOnUnload;

function SymOnUnload()
{
window.open = SymWinOpen;
if(SymRealOnUnload != null)
SymRealOnUnload();
}

function SymOnLoad()
{
if(SymRealOnLoad != null)
SymRealOnLoad();
window.open = SymRealWinOpen;
SymRealOnUnload = window.onunload;
window.onunload = SymOnUnload;
}

SymRealOnLoad = window.onload;
window.onload = SymOnLoad;

//-->
</script>

[Luis33]

..e l'errore?
perchè non usi il tag code ???

[tosto73]

praticamente non visualizza nulla una pagina bianca ma nel db i dati ci sono

questo è il codice resituito dalla pagina asp ed è bianco, se qualcuno può provarlo. :master:

[CODE
<script language="JavaScript">
<!--

function SymError()
{
return true;
}

window.onerror = SymError;

var SymRealWinOpen = window.open;

function SymWinOpen(url, name, attributes)
{
return (new Object());
}

window.open = SymWinOpen;

//-->
</script>

<script language="JavaScript">
var phrases = new Array();

phrases[0]='<table width=100%><tr><td><font face=verdana size=2>prova news2</table>'

phrases[1]='<table width=100%><tr><td><font face=verdana size=2>prova news</table>'

</script>



<div id="displayer"></div>

<script language="JavaScript">
<!--

function SymError()
{
return true;
}

window.onerror = SymError;

var SymRealWinOpen = window.open;

function SymWinOpen(url, name, attributes)
{
return (new Object());
}

window.open = SymWinOpen;

//-->
</script>

<script type="text/javascript">
nx=0,
oD=null;
window.onload=function(){
if (document.getElementById && (oD=document.getElementById("displayer"))){
oD.innerHTML=phrases[nx++];
setInterval(function(){
oD.innerHTML=phrases[nx++];
if (nx==phrases.length) nx=0;
},1500);
}else{
alert("Errore: Impossibile referenziare l'oggetto; o mancato supporto del DOM w3c");
}
}
</script>






<script language="JavaScript">
<!--
var SymRealOnLoad;
var SymRealOnUnload;

function SymOnUnload()
{
window.open = SymWinOpen;
if(SymRealOnUnload != null)
SymRealOnUnload();
}

function SymOnLoad()
{
if(SymRealOnLoad != null)
SymRealOnLoad();
window.open = SymRealWinOpen;
SymRealOnUnload = window.onunload;
window.onunload = SymOnUnload;
}

SymRealOnLoad = window.onload;
window.onload = SymOnLoad;

//-->
</script>


<script language="JavaScript">
<!--
var SymRealOnLoad;
var SymRealOnUnload;

function SymOnUnload()
{
window.open = SymWinOpen;
if(SymRealOnUnload != null)
SymRealOnUnload();
}

function SymOnLoad()
{
if(SymRealOnLoad != null)
SymRealOnLoad();
window.open = SymRealWinOpen;
SymRealOnUnload = window.onunload;
window.onunload = SymOnUnload;
}

SymRealOnLoad = window.onload;
window.onload = SymOnLoad;

//-->
</script>


[/CODE]