---
title: "Insert fel!"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/61070-insert-fel"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "crisse6"
published: "2002-12-04T00:26:43.000Z"
updated: "2002-12-04T14:01:17.000Z"
replies: 2
views: 145
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/61070-insert-fel"
---

# Insert fel!

## #1 — crisse6, 2002-12-04T00:26Z

Hej!

Fattar inte varfor denna kod fungerar? Den vill ha en ')' pa slutet (utan ' runt)

```
sql = "Insert into t_threads (f_title, f_dte, f_user, f_latest, f_by, f_answers, f_text, forumID) " & _
" VALUES ('" & Replace(request.form("title"), "'", "''" & _
"',#" & Datum &"#, '" & session("usr") & "', #" &_
Datum &"#, '" & session("usr") &"', '0', '" & replace(request.form("text") "'", "''",& "', "& forum &")"
```

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

## #2 — icaaq, 2002-12-04T05:15Z

```
[red]sql = "Insert into t_threads (f_title, f_dte, f_user, f_latest, f_by, f_answers, f_text, forumID) " & _
" VALUES ('" & Replace(request.form("title"), "'", "''") & _
"',#" & Datum &"#, '" & session("usr") & "', #" &_
Datum &"#, '" & session("usr") &"', '0', '" & replace(request.form("text"), "'", "''")& "', "& forum &")"[/red]
```

Du måste avsluta dina Replace() med en )

Läs mer på <http://www.devguru.com/Technologies/vbscript/quickref/replace.html>

mvh icaaq

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

## #3 — crisse6, 2002-12-04T14:01Z

ok, tack!

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/61070-insert-fel