查询不出数据库中的内容
<!--#include file="conn.asp"--><!--#include file="../inc/format.asp"-->
<head>
<meta name="keywords" content= "算法与设计教学网站">
<meta name="description" content= "算法与设计教学网站">
<title>算法与设计教学网站</title>
<LINK href="image/css.css" type=text/css rel=stylesheet>
<SCRIPT LANGUAGE="VBSCRIPT">
<!--
SETTIMEOUT "CLOCK",1000
SUB CLOCK()
H=HOUR(NOW)
M=MINUTE(NOW)
S=SECOND(NOW)
NOWTIME="现在时间是"&H&"点"&M&"分"&S&"秒"
NOWT.INNERHTML=NOWTIME
SETTIMEOUT "CLOCK",1000
END SUB
-->
</SCRIPT>
</head>
<SCRIPT language=javascript>
function check()
{
var strChapter=document.form1.YourChapter.value;
if (strChapter=="")
{
alert("请选择章节!");
return false;
}
</SCRIPT>
</head>
<%
kc_name=request("kc_name")
chapter_num=request("chapter_num")
sql="select * from ktxx_kj where kc_name=kc_name"
rs.open sql,conn,1,1
%>
<body bgcolor="#CCCCCC" background="image/bg_2.gif" style="background-image: url('image/bg2.gif')">
<div align=center>
<table border="0" width="820" id="table1" cellpadding=0 cellspacing=0 height="621">
<tr>
<td width=25 background="image/LEFT_BG.gif"> </td>
<td bgcolor="#FFFFFF">
<table width="770" height="173" border="0" cellpadding="0" cellspacing="0" >
<TR>
<TD vAlign=top width=770 height=173><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.,0,29,0" width="770" height="173">
<param name="movie" value="121.swf">
<param name="quality" value="high">
<embed src="121.swf" quality="high" pluginspage="http://www. type="application/x-shockwave-flash" width="770" height="173"></embed>
</object></TD>
</TR>
</table>
<div align="center">
<table width="770" height="735" border="0" cellpadding="0" cellspacing="0">
<tr >
</tr>
<tr >
<td width="25%" height="573" bgcolor="#FFFFFF" style="background-image: url('image/xu.gif'); background-repeat: repeat-y; background-position: right top" valign=top><form action="ShowShijuan22.asp?kc_name=<%=request("kc_name")%>" method="post" name=form1 onsubmit="javaScript:return check();">
<div align="center">
<table width="770" border="0" cellspacing="1" cellpadding="5"bgcolor="#C0C0C0">
<tr >
<td width="25%" height="10" bgcolor="#FFFFFF" background="image/xx11.gif"><CENTER ID="NOWT"></ CENTER></td>
<td height="10" bgcolor="#FFFFFF" background="image/xx11.gif"><div align="center"> <b> <font color="#000000">在线测试系统</font></b></div>
<td height="20" colspan="3" bgcolor="#FFFFFF" background="image/xx11.gif"><a href="../index.asp">返回首页</a></td>
</tr>
<tr >
<td width=30% bgcolor="#FFFFFF"><font color="#009900">章节选择:</font></td>
<td bgcolor="#FFFFFF" width="35%"><font color="#009900">题 型</font></td>
<td bgcolor="#FFFFFF" width="35%"><font color="#009900">难 度</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" rowspan="4">
<table align=center cellpadding=0 cellspacing=1>
<% for i=1 to Chapter_Num %>
<tr><td bgcolor=#ffffff>
<input type=CheckBox name=YourChapter value="<%=i%>"></td><td><%=i%></td><td><%=kj_name%></td></tr>
<% Next %>
</table>
</td>
<td bgcolor="#FFFFFF">选 择</td>
<td bgcolor="#FFFFFF"> <select name="xuanze">
<option>1</option>
<option>2</option>
</select></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">填 空</td>
<td bgcolor="#FFFFFF"> <select name="tiankong">
<option>1</option>
<option>2</option>
</select> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF">问 答</td>
<td bgcolor="#FFFFFF"> <select name="wenda">
<option>1</option>
<option>2</option>
</select> </td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"> <input type="submit" value="随机抽题"> </td>
</tr>
</table>
</div>
</form>
</td>
</tr>
<tr bgcolor="#5bbd2b" >
<td bgcolor="#FFFFFF">
</td>
</tr>
<tr bgcolor="#5bbd2b" >
<td bgcolor="#FFFFFF">
<img border="0" src="../image/123.gif" width="769" height="48"></td>
</tr>
</table>
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="4%" height="20"><img src="image/but05_left.gif" width="38" height="37"></td>
<td width="92%" background="image/but05_bg.gif">
Copyright © 2006:南昌工程学院计算机科学与技术系 author:刘东晓,邓少波,黎敏</td>
<td width="4%"><img src="image/but05_right.gif" width="39" height="37"></td>
</tr>
</table>
</div>
</td>
<td width=25 background="image/RIGHT_BG.gif"> </td>
</tr>
</table>
</div>
</body>
这是源代码,请问哪里出了问题