sql kan ikke finde fejl
<% if request.Form("bog") = "bog" thenFunction fncTextChange1(strText)
strTekst = Trim(strText)
fncTextChange1 = Replace(strTekst,"""","''")
fncTextChange1 = Replace(strTekst,"'","''")
fncTextChange1 = Replace(fncTextChange1," "," ")
fncTextChange1 = Replace(fncTextChange1,">",">")
fncTextChange1 = Replace(fncTextChange1,"<","<")
fncTextChange1 = Replace(fncTextChange1,vbCrLf,"<BR>")
fncTextChange1 = Replace(fncTextChange1,"å","å")
fncTextChange1 = Replace(fncTextChange1,"æ","æ")
fncTextChange1 = Replace(fncTextChange1,"ø","ø")
fncTextChange1 = Replace(fncTextChange1,"Å","Å")
fncTextChange1 = Replace(fncTextChange1,"Æ","Æ")
fncTextChange1 = Replace(fncTextChange1,"Ø","Ø")
End Function
indhold = fncTextChange1(request.form("text"))
set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("bog.mdb")
Conn.Open DSN
Conn.Execute = "Insert into bog(text, hp, mail, navn, dato) Values('"&indhold&"','"&request.Form("hp")&"','"&request.Form("mail")&"','"&request.Form("navn")&"','"&now()&"')"
response.Redirect("gaestebog.asp")
end if
%>
