aso sql语言查询问题

来源：百度知道编辑：UC知道时间：2024/05/13 09:58:02

<%
set dbconnection=Server.CREATEOBJECT("ADODB.CONNECTION")
DBPath = Server.MapPath("../data/systemdata.mdb")
dbconnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
SQL="select * from student,choose_course where (choose_course.teachername='"+Session("teachername")+"')and (choose_course.studentid=student.studentid)"
set mystu=dbconnection.execute(SQL)
studentid=mystu("studentid")
studentname=mystu("studentname")
sex=mystu("sex")
collage=mystu("collage")
phonenumber=mystu("phonenumber")
email=mystu("email")
birthday=mystu("birthday")

%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>myclass</title>
<style type="text/css"&

改过了：

<%
set dbconnection=Server.CREATEOBJECT("ADODB.CONNECTION")
DBPath = Server.MapPath("../data/systemdata.mdb")
dbconnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
SQL="select * from student,choose_course where (choose_course.teachername='"+Session("teachername")+"')and (choose_course.studentid=student.studentid)"
set mystu=dbconnection.execute(SQL)
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>myclass</title>
<style type="text/css">

</style></head>

<body>
<table width="618" border="0" align="center"

aso sql语言查询问题 SQL语言查询问题数据库查询问题sql语言 sql查询语言的问题？ aso中如何实现sql的两个表的查询? 关于SQL查询语言的问题 SQL查询数据库语言 sql 语言中如何查询 sql 题（查询语言） vf 编程 SQL 语言查询