---
title: "SQL strul"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/77598-sql-strul"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Asa"
published: "2003-05-20T21:03:03.000Z"
updated: "2003-05-22T21:43:07.000Z"
replies: 2
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/77598-sql-strul"
---

# SQL strul

## #1 — Asa, 2003-05-20T21:03Z

Har denna kodsnutt som inte funkar i mysql. Nån som kan berätta varför och ändra så den funkar?!

```
Conn.Execute("Delete From fraga_user Where userid = " & session("sex_id") & " and pollId Not In 
(Select pollId From fraga Where userId = " & session("sex_id") & " Order By pollid desc,userid limit 4)")
```

Hade förrut så här när det var med access databas:

```
Conn.Execute("Delete From fraga Where userid = " & session("sex_id") & " and pollId Not In 
(Select Top 4 pollId From fraga Where userId = " & session("sex_id") & " Order By pollid desc,userid)")
```

Felmess:

```
Microsoft OLE DB Provider for ODBC Drivers error '80040e09' 
[TCX][MyODBC]You have an error in your SQL syntax near 'Select pollId From fraga Where userId = 9 Order 
By pollid desc,userid limit 4)' at line 1 

/minsida.asp, line 303
```

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

## #2 — Asa, 2003-05-22T21:40Z

Nån som kan??!

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

## #3 — andreas_lindh, 2003-05-22T21:43Z

Vilken version av Mysql kör du?
Subqueries fungerar från och med version 4.1
<http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html>

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/77598-sql-strul