---
title: "hur?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/39128-hur"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "jns"
published: "2002-03-06T22:42:16.000Z"
updated: "2002-03-06T22:45:25.000Z"
replies: 1
views: 156
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/39128-hur"
---

# hur?

## #1 — jns, 2002-03-06T22:42Z

hur ska denna kod se ut:

```
<%
subject = request.querystring("sub")
id =request.querystring("id")

set mincon =Server.CreateObject("ADODB.Connection")
set rs = server.createobject("ADODB.Recordset")
mincon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\kalasmannen\db\db_guider.mdb")
SQL = "SELECT * from & subject & WHERE ID = " & id
rs.Open SQL, mincon
%>
```

för att fungera?
får nu detta fel meddelande:

```
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. 

/kalasmannen/guiden.asp, line 9
```

?

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

## #2 — solbulle, 2002-03-06T22:45Z

SQL = "SELECT \* from " & subject & " WHERE ID = " & id

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/39128-hur