ASP高手进来帮下忙,小弟我是菜鸟
来帮我看下,老是说我的第8行语法错误,可是我检查很多次了,字段都没错,高手帮我看下
<%
set   conn=server.createobject( "adodb.connection ")
conn.open   "driver={microsoft   access   driver   (*.mdb)};dbq= "&server.mappath( "db1.mdb ")
name=request.form( "name ")
gg=request.form( "gg ")
yd=request.form( "yd ")
dh=request.form( "dh ")
a=request.form( "a ")  
dz=request.form( "dz ")  
cz=request.form( "cz ")  
dih=request.form( "dih ")
mail=request.form( "mail ")
y1b=request.form( "y1d ")  
exec= "insert   into   guestbook(name,gg,yb,dh,a,dz,cz,dih.mail,y1d)values( ' "+name+ " ', ' "+gg+ " ', "+yb+ ", ' "+dh+ " ', ' "+a+ " ', ' "+dz+ " ', "+cz+ ", "+dih+ ", ' "+mail+ " ', "+y1b+ ") "
conn.execute   exec
conn.close
set   conn=nothing
response.write   "记录添加成功! "
%>
或着加我QQ我把网页和数据库发你帮我改下   小弟我感激不尽
QQ34731992

------解决方案--------------------
还有看一下数据库里的字段类型，与程序里的核对一下，字符串的带 ' ',数字的不带 ' '