[求助]ASP里的一句INSERT INTO 语句语法错误 但小弟不知道哪错了
Dim name,neirong,no,wenzhang_id,child,hits,ip,student_name name=Request.Form("name")
neirong=Request.Form("neirong")
student_name=Request.Form("student_name")
no=1
wenzhang_id=0
child=0
hits=0
ip=Request.ServerVariables("remote_addr") '作者IP地址
Dim sql,svalues
sql="Insert Into bbs(name,no,wenzhang_id,child,hits,ip,student_name,date"
svalues = "Values('" & name & "'," & no & "," & wenzhang_id & "," &child & "," & hits & ",'" & ip & "','" & student_name & "','" & date() & "'"
If body<>"" Then
sql = sql & ",neirong"
svalues = svalues & "," & "'" & neirong & "'"
End If
sql = sql & ") " & svalues & ")"
db.Execute(sql)
------------------------------------------------
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。