---
title: "@ i sql-sats"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/169795-i-sql-sats"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "golgata"
published: "2008-03-11T09:29:02.000Z"
updated: "2008-03-11T10:44:34.000Z"
replies: 3
views: 436
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/169795-i-sql-sats"
---

# @ i sql-sats

## #1 — golgata, 2008-03-11T09:29Z

Varför fungerar det inte att ha @ i sqlsats

SQL = "SELECT \* FROM register WHERE epost = " & request.form("epostadress") & ""

Får följande fel.

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

\[MySQL\]\[ODBC 3.51 Driver\]\[mysqld-5.0.45-log\]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@mindoman.se' at line 1

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

## #2 — Zaiman, 2008-03-11T09:31Z

Ändra till:

```
SQL = "SELECT * FROM register WHERE epost = [B]'[/B]" & request.form("epostadress") & "[B]'[/B]"
```

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

## #3 — golgata, 2008-03-11T09:34Z

så enkelt var det.
tack

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

## #4 — spango, 2008-03-11T10:44Z

... och sen begrundar vi vad som händer om man skriver in *blackhat@mylittlepwny.lol'; drop table register; --* som e-postadress.

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/169795-i-sql-sats