主题:[讨论]怎么查询B表 并按照规则把数据存入A表
<%
dim id, xm
id = Trim(request("id"))
if id = "" then Response.Redirect("index.html"):response.end
sql="select * from 记录"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs.addnew
rs("学生编号")=Trim(request("id"))
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript> alert('打卡成功返回');location.replace('index.html');</script>"
response.end
%>
记录是B表
怎么查询A表ID=现在的ID的name字段信息并写入b表name字段内
dim id, xm
id = Trim(request("id"))
if id = "" then Response.Redirect("index.html"):response.end
sql="select * from 记录"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs.addnew
rs("学生编号")=Trim(request("id"))
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript> alert('打卡成功返回');location.replace('index.html');</script>"
response.end
%>
记录是B表
怎么查询A表ID=现在的ID的name字段信息并写入b表name字段内