---
title: "Varför detta !?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/21715-varför-detta"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Zapotek"
published: "2001-10-28T12:17:00.000Z"
updated: "2001-10-28T12:35:00.000Z"
replies: 1
views: 129
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/databaser-sql/21715-varför-detta"
---

# Varför detta !?

## #1 — Zapotek, 2001-10-28T12:17Z

varför får jag felmedelandet:

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

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

/dev/comment/show.asp, line 18 

när jag kör denna kod :

Set Connect = Server.CreateObject("ADODB.Connection")
	Connect.Open "comment"
strSQL = "INSERT INTO Comment ('Comment', 'Name', 'Email', CommentID) VALUES ('strComment', 'strName', 'strEmail', strID)"
Connect.Execute (strSQL)

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

## #2 — LarsG, 2001-10-28T12:35Z

```
strSQL = "INSERT INTO Comment (Comment, Name, Email, CommentID) VALUES ('" & strComment & "','" & strName & "','" & strEmail & "', " & strID & ")"
Connect.Execute strSQL
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/21715-varför-detta