请问大侠们，这个特效如何改成从数库里提取图片，谢谢，急用

<!doctype html public "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title> New Document </title>
<meta name="Generator" content="EditPlus">
<meta name="Author" content="">
<meta name="Keywords" content="">
<meta name="Description" content="">
</head>
<body>
<SCRIPT language=JavaScript>
var imgUrl=new Array();
var adNum=0;
imgUrl[1]="http://photo.sohu.com/20041011/Img222426404.jpg";
imgUrl[2]="http://photo.sohu.com/20040928/Img222279923.jpg";
imgUrl[3]="http://photo.sohu.com/20041011/Img222426414.jpg";
imgUrl[4]="http://photo.sohu.com/20041011/Img222426450.jpg";
var imgPre=new Array();
var j=0;
for (i=1;i<=4;i++) {
if( (imgUrl[i]!="") ) {
j++;
} else {
break;
}
}
function playTran(){
if (document.all)
imgInit.filters.revealTrans.play();
}var key=0;
function nextAd(){
if(adNum<j)adNum++ ;
else adNum=1;

if( key==0 ){
key=1;
} else if (document.all){
imgInit.filters.revealTrans.Transition=20;
imgInit.filters.revealTrans.apply();
}
document.images.imgInit.src=imgUrl[adNum];
playTran();
theTimer=setTimeout("nextAd()", 1000);
}
</SCRIPT>
<table width="200" border="0" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC" height="150">
                <tr>                  
                  <td><img 
            style="BORDER-LEFT-COLOR: #000000; FILTER: revealTrans(duration=2,transition=20);BORDER-BOTTOM-COLOR: #000000; COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-RIGHT-COLOR: #000000" 
            height=150 
            src="javascript:nextAd()" 
            width=200 border=0 name=imgInit></td>
                </tr>
              </table>
</body>
</html>

解决方案 »

  1.   

    imgUrl[1]="http://photo.sohu.com/20041011/Img222426404.jpg";
    imgUrl[2]="http://photo.sohu.com/20040928/Img222279923.jpg";
    imgUrl[3]="http://photo.sohu.com/20041011/Img222426414.jpg";
    imgUrl[4]="http://photo.sohu.com/20041011/Img222426450.jpg";这里可以直接用asp 循环输入
    <%
    ……
    dim i=1;
    while rs.eof and i<1
    response.write("imgUrl["&i&"]='"&rs("link")&"'")
    rs.movenext
    i=i+1
    wend
    %>
      

  2.   

    改好了。用vbscript和javascript交换使用
    代马给大家参考
    <!doctype html public "-//W3C//DTD HTML 4.0 Transitional//EN">
    <html>
    <head>
    <title> New Document </title><meta name="Generator" content="EditPlus">
    <meta name="Author" content="">
    <meta name="Keywords" content="">
    <meta name="Description" content="">
    </head><body>
    <!--#include file='conn.asp'-->
    <%
       sql="select top 4 id,* from newspic order by id desc"
                       set rs=server.createobject("adodb.recordset")
                       rs.open sql,conn,3,3
       %>
    <body>
    <script language="JavaScript">var imgUrl=new Array();
    var imgLink=new Array();
    var adNum=0;
    </script>
    <%
    i=1
    while not rs.eof

    img="admin/pic/news/"&rs("pic1")
    url=rs("url")
     response.write("<script language='JavaScript'>")
     response.write("imgUrl["&i&"]="""&img&""";")
     response.write("imgLink["&i&"]="""&url&""";")
     response.write("</script>")
     i=i+1
     rs.movenext
    wend
    %>
    <script language="JavaScript">
    var imgPre=new Array();
    var j=0;
    for (i=1;i<=4;i++) {
    if( (imgUrl[i]!="") && (imgLink[i]!="") ) {
    j++;
    } else {
    break;
    }
    }function playTran(){
    if (document.all)
    imgInit.filters.revealTrans.play();
    }var key=0;
    function nextAd(){
    if(adNum<j)adNum++ ;
    else adNum=1;

    if( key==0 ){
    key=1;
    } else if (document.all){
    imgInit.filters.revealTrans.Transition=20;
    imgInit.filters.revealTrans.apply();
    }
    document.images.imgInit.src=imgUrl[adNum];
    playTran();
    theTimer=setTimeout("nextAd()", 2000);
    }
    function goUrl(){
    jumpUrl=imgLink[adNum];
    jumpTarget="_blank";
    if (jumpUrl != ""){
    if (jumpTarget != "") 
    window.open(jumpUrl,jumpTarget);
    else
    location.href=jumpUrl;
    }
    }
    </script>
    <table width="200" border="0" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC" height="150">
      <tr>
        <td><a href="javascript:goUrl()"><img 
                style="BORDER-LEFT-COLOR: #000000; FILTER: revealTrans(duration=2,transition=20);BORDER-BOTTOM-COLOR: #000000; COLOR: #000000; BORDER-TOP-COLOR: #000000; BORDER-RIGHT-COLOR: #000000" height="150"  src="javascript:nextAd()" width="200" border="0" name="imgInit"></a></td>
      </tr>
    </table></body>
    </html>