我的这些代码有错吗 帮帮我 很郁闷
<% Option Explicit %>
<html>
<head>
<title>输入结果</title>
</head>
<body>
<%
If Trim(Request("title"))="" Or Trim(Request("part"))="" Or Trim(Request("user"))="" Or Trim(Request("receive"))=""Then
Response.Write "对不起,可能您的有些字段没有输入"
Response.Write "<p><a href='addform.asp'>返回,重新填写</a>"
Else
Dim title,part,user,receive,date,message
title=Request("title")
part=Request("part")
user=Request("user")
receive=Request("receive")
date=Request("date")
message=Request("message")
'下面将数据填入数据库中
Dim strSql,sqla,sqlb
sqla = "Insert Into gongwen(,title,part,user,receive,date"
sqlb = "Values('" & title & "','" & part & "','" & user& "','" & receive & "','" & date & "'"
If message<>"" Then
sqla = sqla & ",message"
sqlb = sqlb & ",'" & message & "'"
End If
strSql = sqla & ") " & sqlb & ")"
Dim db
Set db=Server.CreateObject("ADODB.Connection")
db.Open "dsn=strCon"
db.Execute(strSql) '执行添加操作
'下面判断插入过程有无错误,并给出相应信息
If db.Errors.Count>0 Then
Response.Write "保存过程中发生错误,必须重新填写"
Response.Write "<p><a href='addform.htm'>返回,重新填写</a>"
Else
Response.Write "<h2 align='center'>您的公文已入档</h2>"
Response.Write "<p>公文主题:" & title
Response.Write "<p>发文部门:" & part
Response.Write "<p>发文人:" & user
Response.Write "<p>收文人:" & receive
Response.Write "<p>date:" & date
Response.Write "<p>简介:" & message
Response.Write "<p><a href='addform.asp'>返回,继续添加</a>"
End If
End If
%>
</body>
</html>
为什么总是出现这种错误
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/webb/gongwen/add.asp, 第 34 行