---
title: "aktivitets fel .."
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/80766-aktivitets-fel"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Skatedragon"
published: "2003-06-27T22:03:19.000Z"
updated: "2003-06-27T22:26:33.000Z"
replies: 2
views: 186
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/80766-aktivitets-fel"
---

# aktivitets fel ..

## #1 — Skatedragon, 2003-06-27T22:03Z

har en grejj om man har nya gb inlägg och mess ..
men det blir error

KOD:

Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "Driver={Microsoft Access Driver (\*.mdb)}; DBQ=" & server.mappath ("db.mdb")&";pwd=\*\*\*\*\*\*\*"
Set rs = Server.CreateObject("ADODB.Recordset")
Addera = "SELECT \* FROM mess where vems = " &Session("id") &" AND last = 0"
rs.Open Addera, Connect, 3, 3 
mess=rs.recordcount 
if mess ="0" then
Response.Write "\<a href='las_mess.asp' target='main'\>\<img src='ejmail.bmp' border='0' alt='inga nya mail :('\>\</a\>"
else 
Response.Write "\<a href='las_mess.asp' target='main'\>\<img src='nyttmail2.bmp' border='0' alt='" & mess & "nya/nytt brev :)'\>\</a\>"
end if
rs.close

FELET: 

Aktivitet 
Microsoft OLE DB Provider for ODBC Drivers error '80040e07' 

\[Microsoft\]\[ODBC Microsoft Access Driver\] Data type mismatch in criteria expression. 

/server/cool/onlinevanner.asp, line 47

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

## #2 — Sebbe, 2003-06-27T22:22Z

```
Addera = "SELECT * FROM mess where vems = '" & Session("id") & "' AND last = 0"
```

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

## #3 — Skatedragon, 2003-06-27T22:26Z

japp, nu funkar det =) men om jag kommer in i gästboken nu, så läser jag det nya, sen uppdaterar jag aktivitets rutan, så blinkar det fortfarande.. varför?

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/80766-aktivitets-fel