<!-- #include file="databaskopplingar.asp" -->
<%
SQL = "Select * from medlemmar WHERE ID = '" & Session("cmid") & "'"
Set RecSet = Connect.execute(SQL)
%>
<%
ID = Session("cmid")
lalala = "- befinner sig i forumet"
Connect.Execute("UPDATE medlemmar Set whereareyou='" & lalala & "' Where ID=" & ID )
%>
<%
if RecSet("mainadmin") = "1" then %><%
IF Session("admin")="Yes" then
Response.Write ("<font color=""#FFFFFF""><a href=""main.asp?page=94&do=logout"" class=""menylink"">Logga ut</font></a>")
else
Response.Write ("<font color=""#FFFFFF""><a href=""main.asp?page=94&log=in"" class=""menylink"">Admin</font></a>")
End if
%><% end if %>
<td><!-- #include file="includes/db.asp" --><%
Set RS = ObjConn.Execute("Select * from forum_kat order by kat")
IF RS.Eof then
Response.Write("Inga kategorier att visa.")
else
%>
<!-- #include file="includes/color.asp" --><%
Set Count = ObjConn.Execute("Select count(*) from forum where kat='"&SafeSQL(RS("kat"))&"'" & " and svar='Nej'")
%><tr class='<%=color%>'><td width='39' height="38">
<p align="center"><img src='bilder/folder.png' alt=""></td>
<td width='316'><b><a href='main.asp?page=91&kat=<%=Server.HtmlEncode(RS("kat"))%>'><%=Server.HtmlEncode(RS("kat"))%></a></b>
<br>- <%=Server.HtmlEncode(RS("info"))%></td>
<td width="95"><%=Count(0)%> st</td>
<td width="130"> test</td></tr><%
Count.Close : Set Count = Nothing
[b]RS.Movenext
Loop[/b]
%><%
End if
RS.Close : Set RS = Nothing
%>
<!-- #include file="includes/color.asp" --><%
// Loopar om det är några och räknar hur många trådar det är i varje kategori.
Set Count = ObjConn.Execute("Select count(*) from forum where kat='"&SafeSQL(RS("kat"))&"'" & " and svar='Nej'")
do until RS.EOF
%><tr class='<%=color%>'><td width='39' height="38">
<p align="center"><img src='bilder/folder.png' alt=""></td>
<td width='316'><b><a href='main.asp?page=91&kat=<%=Server.HtmlEncode(RS("kat"))%>'><%=Server.HtmlEncode(RS("kat"))%></a></b>
<br>- <%=Server.HtmlEncode(RS("info"))%></td>
<td width="95"><%=Count(0)%> st</td>
<td width="130"> test</td></tr><%
Count.Close : Set Count = Nothing
RS.Movenext
Loop
%>
Den klagar på att den inte hittar något som heter Count.
Om du tittar i koden så ser du att du har råkat skapa Count precis innan du påbörjar din loop.
<td><!-- #include file="includes/db.asp" --><%
// SQL-satsen för att öppna kategorierna.
do until RS.EOF
Set RS = ObjConn.Execute("Select * from forum_kat order by kat")
Microsoft VBScript compilation error '800a03ea'
Syntax error
/includes/color.asp, line 2
function color
^
color.asp
<%
function color
if i = 0 then
Color = "rad1"
i = 1
else
Color = "rad2"
i = 0
end if
end function
%>