Top 10 virker ikke.
Hej,mit ASP script vil ikke trække alle navne ud af min db. Den hiver kun 1 navn ud, hvor den gerne skulle have hevet alle 10 ud. Hvad kan det skyldes? Er min db conn. forkert?
Anyway på forhånd tak!
Her kommer kildekoden lige:
<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY BGCOLOR="#e6e6e6">
<DIV ID="overDiv" STYLE="position:absolute; visibility:hide;"></DIV>
<SCRIPT TYPE="" LANGUAGE="JavaScript">
<!--
var width = "250";
var border = "3";
var offsetx = 2;
var offsety = 2;
var fcolor = "#e6e6e6";
var backcolor = "#e6e6e6";
var textcolor = "#000000";
var capcolor = "#000000";
var closecolor = "#000000";
// -->
</SCRIPT>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("pr0n.mdb")
strSQL = "select * from pr0nstars order by id desc "
set rs = Conn.execute(strSQL)
Response.ContentType = "image/jpeg" '(or "image/gif") '(or "image/jpg")
%>
<SCRIPT LANGUAGE="JavaScript" SRC="overlib.js"></SCRIPT>
<CENTER>
<TABLE WIDTH="600" BORDER="0" CELLSPACING="0" CELLPADDING="0">
<TR><TD>
</TD></TR>
</TABLE>
<TABLE WIDTH="600" BORDER="0" CELLSPACING="0" CELLPADDING="2">
<TR>
<TD>
<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="5" height="100%">
<TR>
<TD style="border: 1 solid #000000">
<FONT FACE="Verdana" FONT SIZE="2">
<A HREF="<%=RS("URL")%>" TARGET="_blank" onMouseOver="dcc('<img border=1 src=<%=RS("fileIMG")%>>',''); return true;" onMouseOut="nd(); return true;"><%=RS("fileName")%></A>
</FONT>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</CENTER>
<%
Conn.Close
Set Conn = Nothing%>
</BODY>
</HTML>
