hurry,help me!!!(beg you)

[asgates]

代码为：
<!--#include file= "..\dataopen.asp"-->
<%
thisweek= request.form("thisweek")
nextweek= request.form("nextweek")
sql1=(request.form("name")) & "','" &(request.form("dep")) &"','" & thisweek &"','" & nextweek
sql2="insert into plan(name,dep,thisweek,nextweek) values('" & sql1 &"')"
response.write sql2
conn.Execute(sql2)
conn.close
%>

其中dataopen.asp为：

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.open "filedsn=C:\Program Files\Common Files\ODBC\Data Sources\jzqbdata.dsn"
%>


错误为：
insert into plan(name,dep,thisweek,nextweek) values('lh','lhh','bb','bb')
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'plan'.

/工作计划管理/confirm.asp, 行8

[victor_jolin]

Execute函数会返回一个Recordset对象

[asgates]

请问错在何处？

[asgates]

上面大哥，我试过了，不是这个！
who can help me??????

[25475360]

好像语法没有错呀,检查一下链接或打开方式吧

[asgates]

都查了！
who help me????
i am crazy!!!!!!

[efax]

你的字段thisweek,nextweek是什么类型的，这里面肯定是字段有问题
如果thisweek,nextweek是datetime，则应写为;
<%
thisweek= cdate(trim(request.form("thisweek")))
nextweek= cdate(trim(request.form("nextweek")))
sql1=(request.form("name")) & "','" &(request.form("dep")) &"','" & thisweek &"','" & nextweek
sql2="insert into plan(name,dep,thisweek,nextweek) values('" & sql1 &"')"
response.write sql2
conn.Execute(sql2)
conn.close
%>

[asgates]

name dep thisweek nextweek time
type is :
varchar varchar text text datetime

[asgates]

name dep thisweek nextweek time
type is :
varchar varchar text text datetime

[asgates]

who help me?

[baggio785]

这么写试试
sql2="insert into plan(name,dep,thisweek,nextweek) values('" & name &"','" & dep &"','" & thisweek &"','" & nextweek &"')"

[asgates]

我好了！！
只是改改表名和字段名！不可诗意！！！