Insert fel!

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 &")"

[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

ok, tack!