---
title: "Gästboks fel"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/80725-gästboks-fel"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Skatedragon"
published: "2003-06-27T12:15:34.000Z"
updated: "2003-06-27T14:50:19.000Z"
replies: 2
views: 252
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/80725-gästboks-fel"
---

# Gästboks fel

## #1 — Skatedragon, 2003-06-27T12:15Z

får felet

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

\[Microsoft\]\[ODBC Microsoft Access Driver\] Syntax error in string in query expression 'id = 2' order by id desc'. 

/domandra/gastbok.asp, line 110 

kod:

\<%
      
Do until rs.EOF OR rowCount = rs.PageSize
rowCount = rowCount + 1
Set rs3= Server.CreateObject("ADODB.Recordset")
Addera = "SELECT \* FROM anv where id = " &rs("namnid") & "' order by id desc " **\<-- felet** 
rs3.Open Addera, Connect, 3, 3 
%\>

namnid är "text" i databasen..

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

## #2 — Vide, 2003-06-27T12:43Z

```
Do until rs.EOF OR rowCount = rs.PageSize
rowCount = rowCount + 1
Set rs3= Server.CreateObject("ADODB.Recordset")
Addera = "SELECT * FROM anv where id = " &rs("namnid") & " order by id desc "
rs3.Open Addera, Connect, 3, 3
```

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

## #3 — Skatedragon, 2003-06-27T14:50Z

det funkade .. shysst..

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/80725-gästboks-fel