---
title: "Invalid SQL statement"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/12435-invalid-sql-statement"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Skarre"
published: "2001-11-03T05:52:00.000Z"
updated: "2001-11-03T16:20:00.000Z"
replies: 3
views: 195
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/12435-invalid-sql-statement"
---

# Invalid SQL statement

## #1 — Skarre, 2001-11-03T05:52Z

Felet:

> Error Type:
> Microsoft JET Database Engine (0x80040E14)
> Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'

Koden:

```
strSQL = "UPDATE Medlemmar SET Postadress = '" & strPostadress & "', Postnr&Ort = '" & strPostnrort &_
							"', Email = '" & strEmail & "', Anvnamn = '" & strAnvnamn & "', Lösen = '" & strLosen &_
							"' WHERE Anvnamn = '" & Session("anvnamn") & "' AND Lösen = '" & Session("losen") & "'"
		objConn.Execute("strSQL")
```

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

## #2 — icaaq, 2001-11-03T06:52Z

hur ser den ut när du skriver ut den med Response.Write :q

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

## #3 — @nders, 2001-11-03T08:54Z

Ta bort citationstecknen runt strSQL i din execute:

```
objConn.Execute(strSQL)
```

Mvh,

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

## #4 — Skarre, 2001-11-03T16:20Z

Fan vad puckat!!! :r Tack @nders! :)

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/12435-invalid-sql-statement