---
title: "Exception occurred."
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/70495-exception-occurred"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "DiDjo"
published: "2003-03-08T21:13:08.000Z"
updated: "2003-03-09T12:32:44.000Z"
replies: 2
views: 160
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/70495-exception-occurred"
---

# Exception occurred.

## #1 — DiDjo, 2003-03-08T21:13Z

Hej jag får detta fel:

```
error '80020009' 
Exception occurred. 

/!egna/profil.asp, line 165
```

Här är koden:

```
if request.querystring("vem")&""<>"" then
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("databas.mdb")
Set rs = Server.CreateObject("ADODB.Recordset")
Addera = "SELECT * FROM anv where anv='"&request.querystring("anv")&"'"
rs.Open Addera, Connect, 3, 3 

165-->if rs("anv")<>session("anv") then
rs("besok")=rs("besok")+1
rs.update
end if
else
```

Vet inte varför det blir fel där...

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

## #2 — DiDjo, 2003-03-08T21:20Z

slarv fel

```
Addera = "SELECT * FROM anv where anv='"&request.querystring[b]("anv")[/b]&"'"
```

skulle vara ("vem")

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

## #3 — OveRRidE, 2003-03-09T12:32Z

O så tar vi och gör de vanliga prestandaförbättringarna i webStudio-koden. ;)

```
if request.querystring("vem")&""<>"" then
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("databas.mdb")
SQL = "UPDATE [anv] SET besok = besok + 1 WHERE anv = '" & request.querystring("vem") & "'"
Connect.execute(SQL),,128

if rs("anv")<>session("anv") then
rs("besok")=rs("besok")+1
rs.update
end if
else
...
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/70495-exception-occurred