- orkar inte läsa igenom all text :OO
- Ta bort asterixen efter "delete".
Fel nr1
<% pageSize = 10
page = request.querystring("s")
if page = "" then page = 1
sql = "select count(*) forum_trådar"
'behövs för att beräkna antal sidor
set rs = Conn.execute(SQL)
pages = (rs(0)-1)/pageSize + 1
rs.close
SQL = "SELECT * FROM forum_trådar ORDER BY klister DESC, senast DESC limit " & (page-1)*pagesize & "," & pageSize
rs.open SQL, conn
%>
<img src="img/diskutera.gif">
<br><br>
<table border="0" cellpadding="0" cellspacing="0">
<tr height="30">
<td width="2"></td>
<td width="200"><b>Rubrik:</b></td>
<td width="50"><b>Svar:</b></td>
<td width="170"><b>Senast uppdaterad:</b></td>
<td width="2"></td>
</tr>
<%
bg = "FFFFFF"
i = 1
while not rs.EOF
if bg = "FFFFFF" then
bg = "FFEDED"
else
bg = "FFFFFF"
end if
%>
<tr bgcolor="<%=bg%>" onClick="location.href='?sida=diskutera&visa=<%=rs("id")%>'" style="cursor:hand; color:red" onMouseOver="markera(<%=i%>);" onMouseOut="avmarkera(<%=i%>);">
<td bgcolor="white"><img src="img/marker_off.gif" alt="0" border="0" name="left<%=i%>"></td>
<td>
<% if rs("klister") = 1 then %>
<span style="color:C04141">Klistrad:</span>
<% end if %>
<%=server.HTMLencode(rs("rubrik"))%>
</td>
<td><%=visa_antal("forum_svar","tråd",rs("id"))%></td>
<td><%=tid(rs("senast"))%> av <%=visa_user(rs("senast_user"))%></td>
<td bgcolor="white"><img src="img/marker_off.gif" alt="0" border="0" name="right<%=i%>"></td>
</tr>
<%
i = i + 1
rs.movenext
wend
rs.close
a = 0 %>
</table>
<div style="font-size:9px">
<br>
Sidor:
<%
FOR a = 1 to Pages
IF a <> cINT( Page ) THEN
%>
<a href="?sida=diskutera&s=<%=a%>"><%=a%></a></span>
<%
ELSE
%>
<span style="font-weight:bold; color:C04141; border:1px; border-color:C04141; border-style:solid; background-color:FFEDED"> <%=a%> </span>
<%
end if
next
%></div>
...skriver enbart ut:
Sidor:
Själva sidorna fattas alltså. Jag har använt samma kod för paging på en annan sida och där fungerar det utan problem.
Fel nr2
SQL = "DELETE * FROM db_inlägg WHERE id = " & request.querystring("id")
conn.Execute(SQL)
...ger:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM db_inlägg WHERE id = 11' at line 1
/dev/del.asp, line 15
