我要将表单中的信息插入数据库的表中，不知道出了什么问题，显示操作符丢失
高手帮忙看看吧，这是怎么回事

<%
dim sid,sno,sname,stel,semail,saddress,sbm,dateandtime
sid=request.cookies("id")
sno=request.cookies("no")
sname=request.cookies("xingming")
stel=request.cookies("tel")
semail=request.cookies("email")
saddress=request.cookies("address")
sbm=request.cookies("bm")
dateandtime=request.cookies("day")
set conn=server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source="&server.mappath("order.mdb")
cmdsql="insert into ord(prono,num,xingming,tel,email,address,bm,dateandtime)values('"&sid&"','"&sno&"','"&sname&",'"&stel&"','"&semail&"','"&saddress&"','"&sbm&"','"&dateandtime&"')"
conn.execute cmdsql
conn.close
%>


浏览器显示
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 ''&sname&,'&stel&','&semail&','&saddress&','&sbm&','2005-12-25 19:06:14')' 中。

看看哪个数据是空值

没有空值啊

dateandtime)values 这里少了个空格吗？
dateandtime) values 改成这样试试

还是不行
我做了一个购买页面，用户在表单中填入一些信息后，按“下一步”按钮，就执行
<%
dim sid,sno,sname,stel,semail,saddress,sbm,founderror,errormsg
founderror=false
errormsg=""
sid=request.form("id")
sno=request.form("no")
sname=request.form("name")
stel=request.form("tel")
semail=request.form("email")
saddress=request.form("address")
sbm=request.form("bm")
response.cookies("id")=request.form("id")
response.cookies("num")=request.form("no")
response.cookies("xingming")=request.form("name")
response.cookies("tel")=request.form("tel")
response.cookies("email")=request.form("email")
response.cookies("address")=request.form("address")
response.cookies("bm")=request.form("bm")
response.cookies("day")=now()
......
查询，显示购买物品的相关信息
%>
<form method="post" action="order1.asp">
<input type="submit" name="submit1" value="提交定单" >
<input type="button" name="button1" value="取消定单">
</form>

用户按下“提交定单”的按钮后就执行我前面发的ASP
不知道是哪有问题

斑竹呢？

<%
dim sid,sno,sname,stel,semail,saddress,sbm,dateandtime
sid=request.cookies("id")
sno=request.cookies("no")
sname=request.cookies("xingming")
stel=request.cookies("tel")
semail=request.cookies("email")
saddress=request.cookies("address")
sbm=request.cookies("bm")
dateandtime=request.cookies("day")
set conn=server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source="&server.mappath("order.mdb")
cmdsql="insert into ord(prono,num,xingming,tel,email,address,bm,dateandtime)values('"+sid+"','"+sno+"','"+sname+",'"+stel+"','"+semail+"','"+saddress+"','"+sbm+"','"+dateandtime+"')"
conn.execute cmdsql
conn.close
%>
换成加号试一下！！

看看哪项没穿过值来

sname&",'"
缺一个单引号

cmdsql="insert into ord(prono,num,xingming,tel,email,address,bm,dateandtime) values('" & sid & "','" & sno & "','" & sname & "','" & stel & "','" & semail & "','" & saddress & "','" & sbm & "','" & dateandtime & "')"

谢谢各位斑竹，问题解决了
非常感谢！