在线等100分 超级菜的问题

[comcoo]

<%
Dim comcoo
Dim comcoopath
Dim comcooopen
Dim comcootable
Dim comcootr
Dim comcootd
DIM comcootitle
DIM comcoonbsp
Dim tr1
DIM td2
comcootable="<table width=384 height=380 bgcolor=#EEEEEE cellpadding=0 style=border-collapse: collapse>"
comcootr="<tr><td height=19>"
comcootd="</td><tr>"
tr1="<td height=19>"
td2="</td>"
comcoonbsp="                   

;                     

;    "
comcootitle="<center><a class=comcoo3>-----------请您牢记您注册的信息-------------</a></center><br>"
set comcoo=Server.CreateObject("ADODB.Connection")
comcoo.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("COMCOObbsdata/comcoo.mdb")
'comcoo.open"Provider=Microsoft.jet.OLEDB.4.0;Data source="&comcoopath
'开始检测帐号是否注册
set comcooopen=comcoo.Execute("select*from everybody where name='"&request.form("name")&"'")
comcoo.Execute"insertinto everybody(name,Turename,y1,y2,y3,qq,img,age,clew,answer,homepage,email,phone,dizhi,message)values

('"&request.form("name")&"','"&request.form("Turename")&"',"&request.form("y1")&"',"&request.form("y2")&"',"&request.form

("y3")&"',"&request.form("qq")&"',"&request.form("img")&"',"&request.form("age")&"',"&request.form("clew")&"',"&request.form

("answer")&"',"&request.form("homepage")&"',"&request.form("email")&"',"&request.form("phone")&"',"&request.form("dizhi")

&"',"&request.form("message")&"')"
%>
为什么提示
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 无效的 SQL语句；期待 'DELETE'、'INSERT'、'PROCEDURE'、'SELECT'、或 'UPDATE'。

[comcoo]

谢谢大家··今天检查出错误··十分气愤··数据库里面 数据类型弄错拉··郁闷ing``````

[comcoo]

分数很少 每人10分吧

[nchen123]

你这个代码的写法真是糟糕透顶啊， 建议好好研究一下应该怎么写。

[Heister]

comcoo.Execute"insertinto everybody
应该是 insert into吧

[7teeth]

注意空格
select*from

[bingbingcha]

comcoo.Execute"insertinto everybody

改为
comcoo.Execute"insert into everybody

[msroom]

注意空格

[jiffer]

insert into分开写

[叮咚叮咚叮叮咚]

看着你的sql语句很缺少空格啊

问题出在insert into里面,看看各个类型是否对应一致,

[huahaoyueyuan]

我觉的自己写程序已很马虎了,你比我还晕呀,pfpf

[monkeys]

检查sql语句

[Clove]

insert into 写错了！

[vvfish119]

comcoo.Execute"insert into everybody……
是insert into 不是insertinto

[huhanshan013]

是insert into 不是insertinto

[dout]

注意insert into中间的空格

[yaotou]

楼主就是牛

[gjhgjh]

up

[x_gn]

up

[whghwujx]

呵呵
asp要求要仔细，细心！
还有空格，多了不要紧，可别少了！