读书人

帮忙看看这代码哪里错!该如何解决

发布时间: 2012-02-20 21:18:24 作者: rapoo

帮忙看看这代码哪里错!!
<%
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 & " ' 你这样试试。成功了记得给我打分。。。哈哈。

读书人网 >ASP

热点推荐