---
title: "Too few Parameters"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/93714-too-few-parameters"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "DiDjo"
published: "2004-01-01T00:17:55.000Z"
updated: "2004-01-01T12:30:42.000Z"
replies: 2
views: 178
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/93714-too-few-parameters"
---

# Too few Parameters

## #1 — DiDjo, 2004-01-01T00:17Z

hej! Varför får jag detta fel:

```
Microsoft OLE DB Provider for ODBC Drivers error '80040e10' 

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. 

/kommun/maklaren_kop_lagenhet.asp, line 24
```

På denna kod:

```

Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath ("aa.mdb")
Set rs2 = Server.CreateObject("ADODB.Recordset")
Addera = "SELECT * FROM lagenheter WHERE adress = '"&Request.Querystring("adress")&"' AND adressnr = "&Request.Querystring("nr")&" AND adressbok = "&Request.Querystring("bok")
rs2.Open Addera, Connect, 3, 3
```

Gott nytt!

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

## #2 — mikul, 2004-01-01T05:10Z

Testa detta:

```
Dim Sql 'as string
Dim connect, rs 'as objects

Sql = "SELECT * FROM lagenheter WHERE adress = '"&_ 
Request.Querystring("adress") &"' AND adressnr = "&_ 
Request.Querystring("nr") &" AND adressbok = "&_ 
Request.Querystring("bok") & ";"

Set Connect = server.createobject("adodb.connection")
Connect.Open "provider=microsoft.jet.oledb.4.0; data source ="& Server.Mappath("aa.mdb")

     set rs = Connect.execute(Sql)

          If rs.eof then
               '// Kod
          Else
               '// Annan kod
          End if

     rs. Close
     Set rs = Nothing

Connect.Close
Set Connect = Nothing
```

Är det så att kolumnen adressbok är av typen text och inte tal så skall sql-frågan se ut så här:

```
Sql = "SELECT * FROM lagenheter WHERE adress = '"&_ 
Request.Querystring("adress") &"' AND adressnr = "&_ 
Request.Querystring("nr") &" AND adressbok = '"&_ 
Request.Querystring("bok") & "';"
```

Kolla även så att du verkligen skickar med nått värde i "Querystingsen".

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

## #3 — DiDjo, 2004-01-01T12:30Z

/r tack!

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/93714-too-few-parameters