---
title: "Fel på 'insert into'"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/94793-fel-på-insert-into"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "timedia"
published: "2004-01-14T15:11:05.000Z"
updated: "2004-01-14T15:17:40.000Z"
replies: 1
views: 169
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/94793-fel-på-insert-into"
---

# Fel på 'insert into'

## #1 — timedia, 2004-01-14T15:11Z

```
Error Type:
Microsoft JET Database Engine (0x80040E14)
Number of query values and destination fields are not the same.
/gamol/html/shPlaceOrder.asp, line 94
```

Vad är galet?

```
SQL = "INSERT INTO shOrders (address,postalcode,city,customer,shBasket,orderDetails,[date]) VALUES ("
	
	SQL = SQL & "'" & address & "', '" & postalcode & "', '" & city & "', " & Session("shCustomerID") & ", " & _
	"'" & shBasket & "', '" & FormatSQL( Details ) & "', '" & Now() & "','" & "')	"
```

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

## #2 — anno, 2004-01-14T15:17Z

Du har lite överflödig kod i slutet av SQL-satsen:
SQL = SQL & "'" & address & "', '" & postalcode & "', '" & city & "', " & Session("shCustomerID") & ", " & \_
	"'" & shBasket & "', '" & FormatSQL( Details ) & "', '" & Now() & "'**,'" & "'**)"

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

---

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