梦到和别人发现宝藏:asp-如何让一组数据同时添加到两个表里?
来源:百度文库 编辑:高考问答 时间:2024/07/08 08:13:43
例如:<!--#include file="conn.asp"-->
<%
aa=request.form("aa")
bb=request.form("bb")
exec="insert into test(aa,bb)values("+aa+",'"+bb+"')"
conn.execute exec
conn.close
set conn=nothing
response.redirect "list.asp"
%>
除了添加到test表里,我还想将数据添加到try表里,应如何实现?请各位大哥指教!!!
<%
aa=request.form("aa")
bb=request.form("bb")
exec="insert into test(aa,bb)values("+aa+",'"+bb+"')"
conn.execute exec
conn.close
set conn=nothing
response.redirect "list.asp"
%>
除了添加到test表里,我还想将数据添加到try表里,应如何实现?请各位大哥指教!!!
:<!--#include file="conn.asp"-->
<%
aa=request.form("aa")
bb=request.form("bb")
exec="insert into test(aa,bb)values("+aa+",'"+bb+"')"
conn.execute exec
exec="insert into try(aa,bb)values("+aa+",'"+bb+"')"
conn.execute exec
conn.close
set conn=nothing
response.redirect "list.asp"
%>
对头,复制一份再改一下表名
分写两个SQL语句
再加一段填加的代码不就可以了吗