为什么他报标准表达式中数据类型不匹配这个错?!!

来源:百度知道 编辑:UC知道 时间:2024/06/16 01:39:36
<!--#include file="../conn.asp"-->
<%
id=request("id")
xm=trim(request.Form("xm"))
sex=trim(request.Form("sex"))
government=trim(request.Form("government"))
nl=trim(request.Form("nl"))
sg=trim(request.Form("sg"))
mz=trim(request.Form("mz"))
tz=trim(request.Form("tz"))
csnyr=trim(request.Form("csnyr"))
post=trim(request.Form("post"))
telephone=trim(request.Form("telephone"))
movetelephone=trim(request.Form("movetelephone"))
email=trim(request.Form("email"))
address=trim(request.Form("address"))
bkzy=trim(request.Form("bkzy"))
knowledge=trim(request.Form("knowledge"))
bysj=trim(request.Form("bysj"))
byxx=trim(request.Form("byxx"))
xstc=trim(request.Form(&qu

'数据库中表的资料类型,在SQL语句中,表达错误.不妨这样一试.
<%
id=request.QueryString("id")
set rs=server.createobject("adodb.recordset")
Sql = "select * from dianzi where id="&id
rs.open sql,conn,3,3
rs("xm")=xm
rs("sex")=sex
...
rs("remark")=remark
rs.update
response.write"<script>alert('更新成功!');window.location='select.asp'</script>"
%>