webForumDet fria alternativet

Hjälp

ASP

1 svar · 152 visningar · startad av jboy_87

Medlem sedan aug. 20011 099 inlägg
Frågan#1
<%
d = datediff("n", session("start") , now() )
b = dateadd("n", d , now())
c = datediff("n", session("start"), b)
session("minonline") = c

set connect22 = server.createobject("adodb.connection")
Connect22.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect22.execute "update members set minonline = " & b & " where id = " & session("id"),,128

sql = "select * from members"
set rs = connect22.execute (sql,,128)

sql = "select * from members where id ="&session("id")
set rs = connect22.execute(sql)
kul = rs("totalminonline")
ny = kul + session("minonline")
rs.close : set rs = nothing

connect22.execute "update members set totalminonline = " & ny & " where id = " & session("id"),,128
connect22.close : set connect22 = nothing
%>

Feltyp:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][Drivrutin för ODBC Microsoft Access] Syntaxfel (operator saknas) i frågeuttrycket '2002-02-05 18:10:33'.
/test/online.asp, line 9

------------------
ASP är bäst fuck the rest!!!

Medlem sedan dec. 200012 464 inlägg
#2
connect22.execute "update members set minonline = " & c & " where id = " & session("id"),,128

------------------
essentitia preter non sans multiplicandum

265 ms totalt · 4 externa anrop · v20260731065814-full.a51de22e
126 ms — deklarationer (db)
0 ms — hämta statistik (cache)
136 ms — hämta tråd, inlägg och bilagor (db)
125 ms — ändringar (db)