Kan någon se varför det blir 2 tomma bildramar när jag visar 8 bilder med detta script, när jag visar 6 så fylls alla
<%
Dim oConn ,strSQL ,bilder ,i, j ,Count ,post ,antalBilder ,Found
Set oConn = server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= " & server.MapPath("/db/Inloggning.mdb") & ";"
strSQL = "SELECT picture, username, visaBild" & vbCrLf & _
"FROM tblUsers" & vbCrLf & _
"WHERE not picture='nopic.jpg' and visaBild=true"
Set rs = oConn.Execute(strSQL)
If rs.EOF Then
Response.Write "Det finns inga bilder..."
Else
Response.Write "<table width=""95%""><tr><td align=""left"">"
bilder = rs.GetRows()
antalBilder = UBound(bilder, 2) + 1
Count = 8
If Count > antalBilder Then
Count = antalBilder
End If
ReDim Shown(Count)
Randomize
For i = 1 To Count
Do
Found = False
post = Int(Rnd * antalBilder)
For j = 1 To i - 1
If Shown(j) = post Then
Found = True
Exit For
End If
Next
Loop While Found
Shown(i) = post
Response.Write "<img border=""1"" height=""100"" width=""80"" src=""/images/users/" & bilder(0, post) & """ alt=""" & bilder(1, post) & """> "
Next
Response.Write "</td></tr></table>"
End If
rs.Close
Set rs = Nothing
%>