codice:
<table >
<tr>
<%
strAccessDB = "mdb-database/utenti.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(strAccessDB)
Conn.Open strCon
Set rs = Server.CreateObject("ADODB.Recordset")
query = "SELECT * FROM listFiles"
rs.Open query,Conn,3,3
if not rs.EOF then
N = 3
Randomize
max = rs.RecordCount-1
redim arr(max)
for i=0 to max
arr(i)=i
next
for i=0 to max
casuale = Int((max)*Rnd)
temp = arr(i)
arr(i) = arr(casuale)
arr(casuale) = temp
next
for i=0 to N-1
rs.Move arr(i)
Dim images
images= rs("DestFileName")
%>
<td>[img]<%=images%>[/img]</td>
<%
rs.MoveFirst
next
end if
%>
</tr>
</table>