Total

..........

Vad innehåller session("totalminonline")??

annars kan du alltid testa detta:

Response.Write(TypeName(minutes))

så får du se vad det är för typ på varibeln minutes!

Session("totalminonline") = now() när man loggar in

nån

Hmm.....testa att göra om minutes till en integer...

minutes = datediff("n",cdate(session("totalminonline")),now())
Set connect55 = server.createobject("adodb.connection")
Connect55.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect55.execute "update members set totalminonline = totalminonline + " & cint(trim(minutes)) & " where id = " & session("id"),,128

EDIT: fattade fel....

nix funkar inte

plussas fortfarande dubbelt :-(

nån

Jag tror du får visa lite mer kod som passar in i sammanhanget.

Mvh,

så här ser hela ut:

<%
minutes = datediff("n",cdate(session("minonline")),now())
response.write "" & minutes & "" %><%minutes = datediff("n",cdate(session("minonline")),now())
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 = " & minutes & " where id = " & session("id"),,128

minutes = datediff("n",cdate(session("minonline")),now())
if minutes > 60 then
points = 3
connect22.execute "update members set minonline = " & minutes & " , poang = " & points &" where id = " & session("id"),,128
Connect22.close
Set Connect22 = nothing
end if

minutes2 = datediff("n",cdate(session("totalminonline")),now())
Set connect55 = server.createobject("adodb.connection")
Connect55.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect55.execute "update members set totalminonline = totalminonline + 0" & minutes2 & " where id = " & session("id"),,128

%>

nån som kan hjälpa mig

först uppdaterar du minutes en gång här

<%
minutes = datediff("n",cdate(session("minonline")),now())
response.write "" & minutes & "" %><%minutes = datediff("n",cdate(session("minonline")),now())
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 = " & minutes & " where id = " & session("id"),,128
minutes = datediff("n",cdate(session("minonline")),now())
if minutes > 60 then
points = 3
connect22.execute "update members set minonline = " & minutes & " , poang = " & points &" where id = " & session("id"),,128
Connect22.close
Set Connect22 = nothing
end if

sen uppdaterar du den en gång till här

minutes2 = datediff("n",cdate(session("totalminonline")),now())
Set connect55 = server.createobject("adodb.connection")
Connect55.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect55.execute "update members set totalminonline = totalminonline + 0" & minutes2 & " where id = " & session("id"),,128

%>

inte konstigt att det blir dubbelt

mär jag tittat lite närmare så märkte jar att om man har varit där i mer än 60 minuter uppdateras minuterna 3 ggr.....

nope funkar inte

det blir sek istället!!!!

fattar inte riktigt ?????

Vad är det du inte fattar...
här lägger du in totalminutes första gången:

<%
minutes = datediff("n",cdate(session("minonline")),now())
response.write "" & minutes & "" %><%minutes = datediff("n",cdate(session("minonline")),now())
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 = " & minutes & " where id = " & session("id"),,128

sen uppdaterar du tabellen en gång till om man varit inloggad 60 minuter

minutes = datediff("n",cdate(session("minonline")),now())
if minutes > 60 then
points = 3
connect22.execute "update members set minonline = " & minutes & " , poang = " & points &" where id = " & session("id"),,128
Connect22.close
Set Connect22 = nothing
end if

och sen uppdaterar du en sista gång

minutes2 = datediff("n",cdate(session("totalminonline")),now())
Set connect55 = server.createobject("adodb.connection")
Connect55.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect55.execute "update members set totalminonline = totalminonline + 0" & minutes2 & " where id = " & session("id"),,128

%>

hmmmmmm ......varför vet jag inte

det blir ju samma sak