<%
set conn=server.createobject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("/mdb/db.mdb")
kd=request.form("kuaidi")
qs=request.form("qianshou")
nx=request.form("neixing")
dh=request.form("danhao")
tel=request.form("dianhua")
cl=request.form("chuli")
sj=request.form("sj")
bz=request.form("beizhu")
exec="insert into oa(kuaidi,qianshou,neixing,danhao,dianhua,chuli,time,beizhu) values('"& kd & "','" & qs & "','" & nx & "','" & dh & "','" & tel & "','" & cl & "','" & sj & "','" & bz & "')"
conn.execute exec
conn.close
set conn=nothing
qianshou=request.form("qianshou")
response.write qianshou
response.write "记录添加成功!"
%>
exec="insert into oa(kuaidi,qianshou,neixing,danhao,dianhua,chuli,time,beizhu)values('"+kd+"','"+qs+"','"+nx+"','"+dh+"','"+tel+"','"+cl+"','"+sj+"','"+bz+"')"
asp vb是用&连接字符串和变量吧
('"&kd&"','"
我认为如果你用VB写程序的话,在字符连接时不适合使用+,在VB中+就是数学运算中的加,而&才时连字符,这个在C族语言中,+既能表示数学中的加法,还可以做为字符串的连字符的!
不知道你是不是也这样认为呢?