---
title: "fel?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/38592-fel"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "jns"
published: "2002-02-27T19:59:29.000Z"
updated: "2002-02-27T20:28:00.000Z"
replies: 1
views: 174
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/38592-fel"
---

# fel?

## #1 — jns, 2002-02-27T19:59Z

```
ADODB.Recordset error '800a0bb9' 

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. 

/kalasmannen/guider.asp, line 81
```

detta felmeddelnade får jag på denna kod:

```
<%
sortera = request.querystring("sort")
subject = request.querystring("sub")

set mincon =Server.CreateObject("ADODB.Connection")
set rs = server.createobject("ADODB.Recordset")
mincon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\kalasmannen\db\db_guider.mdb")

if subject = hardware then
if sortera = "" then
SQL = "SELECT * from hardware order by ID desc"
end if

if sortera = "titel" then
SQL = "SELECT * from hardware order by titel asc"
end if

if sortera = "forfattare" then
SQL = "SELECT * from hardware order by av asc"
end if

if sortera = "datum" then
SQL = "SELECT * from hardware order by datum asc"
end if
end if

if subject = software then
if sortera = "" then
SQL = "SELECT * from software order by ID desc"
end if

if sortera = "titel" then
SQL = "SELECT * from software order by titel asc"
end if

if sortera = "forfattare" then
SQL = "SELECT * from software order by av asc"
end if

if sortera = "datum" then
SQL = "SELECT * from software order by datum asc"
end if
end if

if subject = other then
if sortera = "" then
SQL = "SELECT * from other order by ID desc"
end if

if sortera = "titel" then
SQL = "SELECT * from other order by titel asc"
end if

if sortera = "forfattare" then
SQL = "SELECT * from other order by av asc"
end if

if sortera = "datum" then
SQL = "SELECT * from other order by datum asc"
end if
end if

rs.Open SQL, mincon

color = 0
%>
```

men vad är felet?
rad 81 är alltså

```
rs.Open SQL, mincon
```

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

## #2 — LarsG, 2002-02-27T20:28Z

```
if subject = "hardware" then
```

och likadant på de andra rader där du jämför subject. Det som händer är att variabeln SQL aldrig tilldelas något värde.

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

---

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