Kan ikke indsætte i DB'en - igen!
Jeg bruger næsten den samme sætning som til nogen af de andres sider jeg har.... men jeg kan bare ikke få¨det til at virker!!!!KODEN:
<%@ Language=VBScript %>
<!--#INCLUDE VIRTUAL="islogin.asp"-->
<html>
<head>
<meta http-equiv="Content-Language" content="da">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Ny side 1</title>
</head>
<body>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../cgi-data/database.mdb")
Conn.Open DSN
Dim CompanyNameText
Dim CompanyNumberText
Dim CompanyDiscountText
CustomerText = Session("Customer")
CompanyNameText= Request.form("CompanyName")
CompanyNumberText= Request.form("CompanyNumber")
CompanyDiscountText= Request.form("CompanyDiscount")
strSQL = "Insert into Customer ("
strSQL = strSQL & "Number, "
strSQL = strSQL & "Name, "
strSQL = strSQL & "rabat) "
strSQL = strSQL & "values( "
strSQL = strSQL & CompanyNumberText & ", "
strSQL = strSQL & "'" & CompanyNameText & "', "
strSQL = strSQL & CompanyDiscountText & ") "
response.write strSQL
Conn.Execute(strSQL)
%>
</body>
</html>
FEJLEN:
Insert into Customer (Number, Name, rabat) values( 10, 'Test', 10)
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/Companyadding.asp, line 42
