---
title: "Felmeddelande"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/62375-felmeddelande"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "jwradhe"
published: "2002-12-16T19:51:08.000Z"
updated: "2002-12-16T20:09:53.000Z"
replies: 1
views: 159
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/62375-felmeddelande"
---

# Felmeddelande

## #1 — jwradhe, 2002-12-16T19:51Z

```
<%
Set Connect = Server.CreateObject("ADODB.connection")
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db/forum.mdb")

%>
<%
Set RecSet = Server.CreateObject("ADODB.recordset")
SQL = "SELECT * from forum "
RecSet.Open SQL, Connect, 3, 3

RecSet.AddNew
RecSet("rubrik") = Request.Form("rubrik")
RecSet("inlagg") = Request.Form("inlagg")
RecSet("namn") = Request.Form("user")
RecSet("kat") = Request.Form("kat")
RecSet("huv") = Request.Form("huv")
RecSet("datum") = now
RecSet("senaste") = now
RecSet.Update
set RecSet = nothing
%>

<%
Set RecSet = Server.CreateObject("ADODB.recordset")
SQL = "SELECT * from kat WHERE forum = '" & Request.Form("kat")& "'"
RecSet.Open SQL, Connect, 3, 3

RecSet("tradar") = RecSet("tradar")+1
RecSet("by") = Request.Form("user")
RecSet("senaste") = now
RecSet.Update
set RecSet = nothing
%>

<%
Set RecSet = Server.CreateObject("ADODB.recordset")
SQL = "SELECT * from users WHERE userName = '" & Session("user") & "'"
RecSet.Open SQL, Connect, 3, 3
             
RecSet("userPoints") = RecSet("userPoints") + 2
RecSet("userInlagg") = RecSet("userInlagg") + 1
RecSet.Update
RecSet.Close
%>

<%
Connect.Close
Set Connect = nothing

Response.Redirect "las_kat.asp?kat=" & Request.Form("kat")
%>
```

får felmeddelande :

```
error '80020009' 
Exception occurred. 

/jwradhe/add_trad.asp, line 41
```

rad   41 är 

```
RecSet("userPoints") = RecSet("userPoints") + 2
```

va har jag gjort fel?

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

## #2 — LarsG, 2002-12-16T20:09Z

Förmodligen är det ingen post som uppfyller villkoret

```
RecSet.Open SQL, Connect, 3, 3
if not recset.eof then
   RecSet("userPoints") = RecSet("userPoints") + 2
   RecSet("userInlagg") = RecSet("userInlagg") + 1
   RecSet.Update
else
   response.write "Ogiltigt namn " & session("user")
end if
RecSet.Close
```

Innehåller session("user") rätt värde?

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/62375-felmeddelande