script news scorrevoli

[g_arpi2000f]

Buongiorno a tutti. Cercavo uno script per news che scorrono in orizzontale che prendono dati da un db. Ne esiste casomai qualcuno che abbia le news cliccabili? Grazie per la pazienza

[diegoctn]

Questo e quello che uso io:

<%
cString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("circolari.mdb") 

'set connession to database 
Set objConn=Server.CreateObject("ADODB.Connection")

'open connession to database
objConn.Open cstring

Set rs = Server.CreateObject("ADODB.Recordset")

nometabella="circolare"  

SQL = "select top 6 * From "&nometabella&" order by data desc"

'apro il rs
rs.Open sql, objConn, 3, 3 'cursore dinamico
rs.movefirst

i = 0
%>
<script language="JavaScript1.2">
//Specify the marquee's width (in pixels)
var marqueewidth=150
//Specify the marquee's height (in pixels, pertains only to NS)
var marqueeheight=40
//Specify the marquee's scroll speed (larger is faster)
var speed=4
//Specify the marquee contents
	
	var myLinks;
	myLinks = "";
</script>
<%
do until rs.eof
urg=rs("ur")
If urg="h" then
%>
<script language="JavaScript">
		
		
var marqueecontents=''+'<a hre="" target="_new"><%=rs("data")%>
<font color="red"><%=rs("oggetto")%></font></a>

'+' ';


	
	myLinks=myLinks+marqueecontents;
</script>
<% else%>
<script language="JavaScript">
		
		
var marqueecontents=''+'<a hre="" target="_new"><%=rs("data")%>
<font color="#008000#"><%=rs("oggetto")%></font></a>

'+' ';


	
	myLinks=myLinks+marqueecontents;
</script>
<%end if%>
<%
rs.movenext
loop
%>
<script language="JavaScript">

if (document.all)
document.write('<center><marquee scrollAmount='+speed+' style="width:'+marqueewidth+'" direction="up">'+myLinks+'</marquee></center>')

function regenerate(){
window.location.reload()
}
function regenerate2(){
if (document.layers){
setTimeout("window.onresize=regenerate",450)
intializemarquee()
}
}

function intializemarquee(){
document.cmarquee01.document.cmarquee02.document.write('<nobr>'+marqueecontents+'
')
document.cmarquee01.document.cmarquee02.document.close()
thelength=document.cmarquee01.document.cmarquee02.document.width
scrollit()
}

function scrollit(){
if (document.cmarquee01.document.cmarquee02.left>=thelength*(-1)){
document.cmarquee01.document.cmarquee02.left-=speed
setTimeout("scrollit()",100)
}
else{
document.cmarquee01.document.cmarquee02.left=marqueewidth
scrollit()
}
}

window.onload=regenerate2
</script>
<ilayer width=&{marqueewidth}; height=&{marqueeheight}; name="cmarquee01"> 
<layer name="cmarquee02">
</layer>
</ilayer>
<%
rs.close
set rs=nothing

'chiudo tutto
objConn.close
set objconn=nothing
%></p>

Presonalizzalo.

[g_arpi2000f]

grazie adesso ci provo