Kan det lade sig gøre ?
Der hvor der står SRC='random/ vil jeg meget gerne have værdien af response.write rs("folder") ind i stedet ....kan dette lade sig gøre
<%
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=localhost;DATABASE=afd19;UID=sa;PWD=password;"
SQL = "SELECT * FROM q_view_random_seasonpix_by_dates"
Set rs = Conn.Execute(SQL)
response.write rs("folder")
RANDOMIZE
Response.write("<IMG border=0 name=""random"" SRC='random/" & INT((10)*RND()) & ".jpg'>")%>
<SCRIPT LANGUAGE="javaScript">
function randomPicture() {
rnd = Math.round(Math.random()*10)
sub1 = document.all.random.src.replace('.jpg','');
sub2 = sub1.substr(sub1.length-2,2);
oldPicture = sub2.replace('/','');
while(rnd == oldPicture) {
rnd = Math.round(Math.random()*10)
}
document.all.random.src = 'random/' + rnd + '.jpg';
window.setTimeout("randomPicture()",5000);
}
</SCRIPT>
<SCRIPT LANGUAGE="javaScript">
randomPicture();
</SCRIPT>
