囧人的幸福生活第30集:帮我看这段代码错在哪??

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/28 02:43:08
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("lanlingjdjg.mdb")
jd-name=request.form("jd-name")
jd-xingji=request.form("jd-xingji")
jd-diqu=request.form("jd-diqu")
exec="insert into a(jd-name,jd-xingji,jd-diqu)values("+jd-name+","+jd-xingji+","+jd-diqu+")"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>

<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>

出现的错误提示是
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]常见错误 不能打开注册表关键字 'Temporary (volatile) Jet DSN for process 0x1fc Thread 0xbc8 DBC 0x1245024 Jet'。
/itbbs_v3.0.0/example5.asp, 第 3 行

浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

网页:
POST 74 ??? /itbbs_v3.0.0/example5.asp

POST Data:
jd-name=%B4%F3%B8%C5%B5%D8&jd-xingji=45&jd-diqu=%D4%CD&Submit=%CC%E1%BD%BB
后来我改成了这样
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("lanlingjdjg.mdb")
name=request.from("name")
xingji=request.from("xingji")
diqu=request.from("diqu")
exec="insert into a(name,xingji,diqu)values("name","xingji","diqu")"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>

<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>

出现这个错误
错误类型:
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/itbbs_v3.0.0/example5.asp, line 7, column 45
exec="insert into a(name,xingji,diqu)values("name","xingji","diqu")"
--------------------------------------------^

浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)

网页:
POST 70 ??? /itbbs_v3.0.0/example5.asp

POST Data:
name=%D4%DA&xingji=8&diqu=%B4%F3%B3%D4%B4%F3%BA%C8&Submit=%CC%E1%BD%BB

jd-name=request("jd-name")
jd-xingji=request("jd-xingji")
jd-diqu=request("jd-diqu")

这样试试~~ 记得回帖

jd_name=request.form("jd-name")
jd_xingji=request.form("jd-xingji")
jd_diqu=request.form("jd-diqu")

把所有程序中的变量名 jd-name、jd-xingji、jd-diqu 分别改成 jd_name、jd_xingji、jd_diqu (不改变数据库字段名)。

values("+jd-name+","+jd-xingji+","+jd-diqu+")
改成:values("jd-name","jd-xingji","jd-diqu")

你原来的代码:exec="insert into a(name,xingji,diqu)values("name","xingji","diqu")"

修改为:
exec="insert into a(name,xingji,diqu) values('" & name & "','" & xingji & "','" & diqu & "')"

建议:不要用"-"号,最好用"_".