日期:2014-05-17  浏览次数:20936 次

帮忙看看这代码哪里错!!
<%  
hao=request.form( "hao ")
mingcheng=request.form( "mingcheng ")
lianxiren=request.form( "lianxiren ")
dianhua=request.form( "dianhua ")
id=request.QueryString( "Uid ")
set   conn   =   server.createobject( "adodb.connection ")
connstr= "DRIVER={Microsoft   Access   Driver   (*.mdb)};   DBQ= "   &   server.mappath( "data.mdb ")
conn.Open   connstr
sqlstmt   =   "update   3   set   hao= ' "&hao& " ',mingcheng= ' "&mingcheng& " ',lianxiren= ' "&lianxiren& " ',dianhua= ' "&dianhua& " '   where   id= "&id
Set   rs   =   Server.CreateObject( "ADODB.Recordset ")
conn.execute(sqlstmt)
%>    


Microsoft   VBScript   编译器错误   (0x800A0401)
语句未结束
/合同/ClientModify-VB.asp,   line   13,   column   30
sqlstmt   =   "update   3   set   hao= ' "&hao& " ',mingcheng= ' "&mingcheng& " ',lianxiren= ' "&lianxiren& " ',dianhua= ' "&dianhua& " '   where   id= "&id  

我对一个可以调试成功的代码进行修改的,但修改后却发生错误,实在不解。

------解决方案--------------------
我记得 hao 这个变量好像有问题。。
hao= ' " & hao & " ' 你这样试试。成功了记得给我打分。。。哈哈。