Hvad gør jeg forkert?
<%nr = 35
Set adminlog = Server.CreateObject ("ADODB.Recordset")
adminlog.Open "SELECT COUNT (*) AS log_antal_sider FROM log", objConn
log_sider = adminlog("log_antal_sider") / nr
adminlog.Close
Set adminlog = Server.CreateObject ("ADODB.Recordset")
adminlog.Open "SELECT * FROM log ORDER BY dato DESC", objConn
log_side = Request.QueryString("log_side")
If log_side = "" Then
log_side = 1
End If
Select Case log_side
Case 2 : adminlog.Move nr
Case 3 : adminlog.Move nr * 2
Case 4 : adminlog.Move nr * 3
Case 5 : adminlog.Move nr * 4
Case 6 : adminlog.Move nr * 5
Case 7 : adminlog.Move nr * 6
Case 8 : adminlog.Move nr * 7
Case 9 : adminlog.Move nr * 8
Case 10: adminlog.Move nr * 9
End Select
If log_antal = "" Then
log_antal = 1
End If
While NOT adminlog.EOF AND log_antal <= nr
If color = "#FFFFFF" OR color = "" Then
color = "#F6F6F6"
Else
color = "#FFFFFF"
End If
log_antal = log_antal + 1
source = Server.HtmlEncode(adminlog("log"))
%>
Fejlen jeg får
Error Type:
ADODB.Recordset.1 (0x80004005)
SQLState: 4 Native Error Code: 1064 [TCX][MyODBC]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 '(*) AS log_antal_sider FROM log' at line 1
/log.asp, line 29
hjemmesiden er www.dsu-middelfart.dk/log.asp?mode=vis
Håber der er nogle der kan hjælpe :)?
Mvh. Asger
