UC知道asp insert into搞不懂
来源：百度知道 编辑：UC知道 时间：2024/05/31 20:43:38
<%
dim citya,cityb,cityc,name,tel,add,fhao
citya=request("city1")
cityb=request("city2")
cityc=request("city3")
name=request("name")
tel=request("tel")
add=request("add")
fhao=request("hao")
if cityb = "" or citya = "" or cityc = "" or name = "" or tel = "" or add =
"" or fhao = "" then
Response.Write "<p align=center><font color=#FF0000>资料不全，请重新添加！
</font></p>"
else
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath
("hee.mdb")
exec="insert into ji(citya,cityb,cityc,name,tel,add,hao) values
('"&citya&"','"&scityb&"','"&cityc&"&#
dim citya,cityb,cityc,name,tel,add,fhao
citya=request("city1")
cityb=request("city2")
cityc=request("city3")
name=request("name")
tel=request("tel")
add=request("add")
fhao=request("hao")
if cityb = "" or citya = "" or cityc = "" or name = "" or tel = "" or add =
"" or fhao = "" then
Response.Write "<p align=center><font color=#FF0000>资料不全，请重新添加！
</font></p>"
else
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath
("hee.mdb")
exec="insert into ji(citya,cityb,cityc,name,tel,add,hao) values
('"&citya&"','"&scityb&"','"&cityc&"&#
<!--#include file="conn.asp"-->'楼主,这裏是否调用数据库连接页面呢
<%
dim citya,cityb,cityc,name,tel,add,fhao
citya=request("city1")
cityb=request("city2")
cityc=request("city3")
name=request("name")
tel=request("tel")
add=request("add")
fhao=request("hao")
if cityb="" or citya="" or cityc="" or name="" or tel="" or add ="" or fhao="" then
Response.Write "<p align=center><font color=#FF0000>资料不全，请重新添加！</font></p>"
else
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("hee.mdb")
rs.addnew'楼主试一下,用这种方法.你用的SQL语句也可以新增,但是不清楚你的数据库中的字段类型.
rs("citya")=citya
rs("cityb")=cityb
rs("cityc