---
title: "problem med delete"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/83402-problem-med-delete"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "WebbisNet"
published: "2003-08-03T21:52:46.000Z"
updated: "2003-08-03T22:04:57.000Z"
replies: 1
views: 180
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/83402-problem-med-delete"
---

# problem med delete

## #1 — WebbisNet, 2003-08-03T21:52Z

Vad är det för fel med den här delete-satsen?

\<!-- #include file="../Include/inc/conn.inc" --\>

\<%	
Dim RS
Dim SQL
Dim Conn

set conn = Server.CreateObject("ADODB.Connection")

SQL = "DELETE FROM kontakt WHERE ID =" & Request.Querystring("ID") & ""

conn.Open connstr
Set RS = conn.Execute(SQL)

   RS.Delete

	RS.Close 
	conn.Close

response.redirect "mail_read.asp"
%\>

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

## #2 — LarsG, 2003-08-03T22:04Z

Du har en del onödig kod

```
<!-- #include file="../Include/inc/conn.inc" -->

<%
Dim SQL
Dim Conn

set conn = Server.CreateObject("ADODB.Connection")

SQL = "DELETE FROM kontakt WHERE ID =" & Request.Querystring("ID") 

conn.Open connstr
conn.Execute  sql
conn.Close

response.redirect "mail_read.asp"
%>
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/83402-problem-med-delete