strSQL = "INSERT INTO Comment (Comment, Name, Email, CommentID) VALUES ('" & strComment & "','" & strName & "','" & strEmail & "', " & strID & ")"
Connect.Execute strSQL
Frågan#1
varför får jag felmedelandet:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/dev/comment/show.asp, line 18
när jag kör denna kod :
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "comment"
strSQL = "INSERT INTO Comment ('Comment', 'Name', 'Email', CommentID) VALUES ('strComment', 'strName', 'strEmail', strID)"
Connect.Execute (strSQL)