Fejl i banner system
Hejsa...Jeg er ved at lave et banner system, men den viser bare ikke noget banner...
Er der nogle der kan se fejlen i denne kode:
------KODE START--------
<%
strSQL = "SELECT * FROM banner WHERE display < displaymax AND click < clickmax ORDER BY RAND()"
set rsbanner = BannerConn.execute(strSQL)
if rsbanner.EOF then
Response.write "Intet banner"
else
rsbanner.cachesize = 50
ID = rsbanner("ID")
gif = rsbanner("gif")
display = rsbanner("display")
name = rsbanner("name")
rsbanner.close
set rsbanner=nothing
%>
<A HREF=adredir.asp?ID=<%=ID%> target=_blank>
<IMG SRC="<%=Gif%>" BORDER=0><BR><%=name%>
</A></font>
<%
BannerConn.Close
set BannerConn=nothing
end if
%>
-------KODE SLUT--------
