---
title: "Total"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/13625-total"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "jboy_87"
published: "2002-01-05T22:31:00.000Z"
updated: "2002-01-08T00:41:00.000Z"
replies: 30
views: 422
page: 1
pages: 2
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/13625-total"
---

# Total

_Sida 1 av 2._

## #1 — jboy_87, 2002-01-05T22:31Z

varför plussas det dubbelt??:

```
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 +" & minutes & " where id = " & session("id"),,128
```

Permalänk: https://www.webforum.nu/p/13625

## #2 — jboy_87, 2002-01-06T02:12Z

..........

Permalänk: https://www.webforum.nu/p/303197

## #3 — icaaq, 2002-01-06T12:16Z

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

Permalänk: https://www.webforum.nu/p/303198

## #4 — webzonen, 2002-01-06T12:26Z

annars kan du alltid testa detta:

```
Response.Write(TypeName(minutes))
```

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

Permalänk: https://www.webforum.nu/p/303199

## #5 — jboy_87, 2002-01-06T15:03Z

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

Permalänk: https://www.webforum.nu/p/303200

## #6 — jboy_87, 2002-01-06T16:30Z

nån

Permalänk: https://www.webforum.nu/p/303201

## #7 — Harback, 2002-01-06T16:41Z

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....

Permalänk: https://www.webforum.nu/p/303202

## #8 — jboy_87, 2002-01-06T16:45Z

nix funkar inte

Permalänk: https://www.webforum.nu/p/303203

## #9 — jboy_87, 2002-01-06T16:52Z

plussas fortfarande dubbelt :-(

Permalänk: https://www.webforum.nu/p/303204

## #10 — jboy_87, 2002-01-06T21:42Z

nån

Permalänk: https://www.webforum.nu/p/303205

## #11 — @nders, 2002-01-06T21:50Z

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

Mvh,

Permalänk: https://www.webforum.nu/p/303206

## #12 — jboy_87, 2002-01-06T21:56Z

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

%>
```

Permalänk: https://www.webforum.nu/p/303207

## #13 — jboy_87, 2002-01-07T13:36Z

nån som kan hjälpa mig

Permalänk: https://www.webforum.nu/p/303208

## #14 — icaaq, 2002-01-07T15:14Z

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 :)

Permalänk: https://www.webforum.nu/p/303209

## #15 — icaaq, 2002-01-07T15:17Z

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..... :OO

Permalänk: https://www.webforum.nu/p/303210

## #16 — jboy_87, 2002-01-07T16:05Z

nope funkar inte

Permalänk: https://www.webforum.nu/p/303211

## #17 — jboy_87, 2002-01-07T16:08Z

det blir sek istället!!!!

Permalänk: https://www.webforum.nu/p/303212

## #18 — jboy_87, 2002-01-07T16:36Z

fattar inte riktigt ?????

Permalänk: https://www.webforum.nu/p/303213

## #19 — icaaq, 2002-01-07T17:07Z

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

Permalänk: https://www.webforum.nu/p/303214

## #20 — jboy_87, 2002-01-07T17:13Z

det blir ju samma sak

Permalänk: https://www.webforum.nu/p/303215

---

Tråden på webben: https://www.webforum.nu/amne/asp/13625-total  
Nästa sida: https://www.webforum.nu/amne/asp/13625-total/page2.md