---
title: "Hjälp"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/14217-hjälp"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "jboy_87"
published: "2002-02-05T17:09:00.000Z"
updated: "2002-02-05T17:14:00.000Z"
replies: 1
views: 169
page: 1
pages: 1
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/14217-hjälp"
---

# Hjälp

## #1 — jboy_87, 2002-02-05T17:09Z

```
<%
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

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

## #2 — LarsG, 2002-02-05T17:14Z

```
connect22.execute "update members set minonline = " & c & " where id = " & session("id"),,128
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/14217-hjälp