UC知道sission在SQL中的用法？？？
来源：百度知道 编辑：UC知道 时间：2024/06/04 17:49:42
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("data.mdb")
sql = "SELECT Chengji.xuehao, Xuesheng.xinming, kecheng.kechengming, Jiaoshi.Xingming, Chengji.chengji, Chengji.xiufen FROM Xuesheng INNER JOIN ((Jiaoshi INNER JOIN kecheng ON Jiaoshi.id = kecheng.renkejiaosi) INNER JOIN Chengji ON kecheng.kechenghao = Chengji.kechenghao) ON Xuesheng.xuehao = Chengji.xuehao WHERE (Chengji.xuehao)="session("name")
set rs = server.createobject("ADODB.Recordset")
rs.open sql,conn,1,1
%>
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("data.mdb")
sql = "SELECT Chengji.xuehao, Xuesheng.xinming, kecheng.kechengming, Jiaoshi.Xingming, Chengji.chengji, Chengji.xiufen FROM Xuesheng INNER JOIN ((Jiaoshi INNER JOIN kecheng ON Jiaoshi.id = kecheng.renkejiaosi) INNER JOIN Chengji ON kecheng.kechenghao = Chengji.kechenghao) ON Xuesheng.xuehao = Chengji.xuehao WHERE (Chengji.xuehao)="session("name")
set rs = server.createobject("ADODB.Recordset")
rs.open sql,conn,1,1
%>
sql = "SELECT Chengji.xuehao, Xuesheng.xinming, kecheng.kechengming, Jiaoshi.Xingming, Chengji.chengji, Chengji.xiufen FROM Xuesheng INNER JOIN ((Jiaoshi INNER JOIN kecheng ON Jiaoshi.id = kecheng.renkejiaosi) INNER JOIN Chengji ON kecheng.kechenghao = Chengji.kechenghao) ON Xuesheng.xuehao = Chengji.xuehao WHERE (Chengji.xuehao)='"&session("name")&"'"
session跟SQL没有关系!