主题:类型不匹配?
类型不匹配?,不懂了,我都在数据库里改成文本格式了,
代码:
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq=E:\webroot\product\mdb\cp.mdb"
'name=request.form("name")
lb=request.form("lb")
pp=request.form("pp")
xl=request.form("xl")
pm=request.form("pm")
jg=request.form("jg")
gg=request.form("gg")
js=request.form("js")
djs=1
'exec="insert into guestbook(name,tel,message)values('"+name+"',"+tel+",'"+message+"')"
exec="insert into pro(lb,pp,xl,pm,jg,gg,js,djs)values('"+lb+"','"+pp+"','"+xl+"','"+pm+"','"+jg+"','"+gg+"','"+js+"','"+djs+"')"
conn.execute exec
%>
成功录入记录!
<%
conn.close
set conn=nothing
%>
错误信息
错误类型:
Microsoft VBScript 运行时错误 (0x800A000D)
类型不匹配: '[string: "insert into pro(lb,p"]'
/product/luru.asp, 第 14 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
网页:
POST 74 ??? /product/luru.asp
POST Data:
lb=sasds&pp=sssa&xl=aq&pm=qqqw&jg=323&gg=gttr&js=ttrrt&Submit=%CC%E1%BD%BB
代码:
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq=E:\webroot\product\mdb\cp.mdb"
'name=request.form("name")
lb=request.form("lb")
pp=request.form("pp")
xl=request.form("xl")
pm=request.form("pm")
jg=request.form("jg")
gg=request.form("gg")
js=request.form("js")
djs=1
'exec="insert into guestbook(name,tel,message)values('"+name+"',"+tel+",'"+message+"')"
exec="insert into pro(lb,pp,xl,pm,jg,gg,js,djs)values('"+lb+"','"+pp+"','"+xl+"','"+pm+"','"+jg+"','"+gg+"','"+js+"','"+djs+"')"
conn.execute exec
%>
成功录入记录!
<%
conn.close
set conn=nothing
%>
错误信息
错误类型:
Microsoft VBScript 运行时错误 (0x800A000D)
类型不匹配: '[string: "insert into pro(lb,p"]'
/product/luru.asp, 第 14 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
网页:
POST 74 ??? /product/luru.asp
POST Data:
lb=sasds&pp=sssa&xl=aq&pm=qqqw&jg=323&gg=gttr&js=ttrrt&Submit=%CC%E1%BD%BB