120分求一句SQL

[feixuejian881]

另的一帖还有100分。一级动菜单运行正常，但查询不正常。
级动菜单代码如下：
<script LANGUAGE="javascript">
<!--
var onecount;
onecount=0;

subcat = new Array();
subcat[0] = new Array("攻击","01","001");
subcat[1] = new Array("防御","01","002");
subcat[2] = new Array("觅食","01","003");
subcat[3] = new Array("贮食","01","004");
subcat[4] = new Array("繁殖","01","005");
subcat[5] = new Array("社群","01","006");
subcat[6] = new Array("通信","01","007");
subcat[7] = new Array("节律","01","008");
subcat[8] = new Array("本能","01","009");
subcat[9] = new Array("巴浦洛夫","02","010");
subcat[10] = new Array("珍妮特","02","011");
subcat[11] = new Array("hj","02","012");
onecount=12;

function changelocation(locationid)
{
document.myform.smalllocation.length = 0;

var locationid=locationid;
var i;
document.myform.smalllocation.options[0] = new Option('==所有==','');
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]);
}
}

}

//-->
</script>
<form name="myform" action="seach.asp" method="post">
<p>
<select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)">
<option value="01">文字</option>
<option value="01">图片</option>
<option value="01">音像</option>
<option value="02">科学家
<option>
</select>
类
<select name="smalllocation">
<option value="" selected>=所有=</option>
</select>
</p>
<p> 　　
<input type="submit" name="Submit" value="搜索">
<input type="reset" name="Submit2" value="取消">
</p>
</form>
<script LANGUAGE="javascript">
<!--
changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value);
//-->
</script> </p> </tr>
我是这样查的：
<%set objconn=server.createobject("adodb.connection")
objconn.open "dsn=ADB;database=sour;uid=;pwd=;"
set objrs=server.createobject("adodb.recordset")
sql="select word,URL From sour where leibie='"&request.form("bigcolation")&"'"
objrs.Open sql,objconn,3,2
%>
另有一seach.asp经运行无误，只是一个取数据和格式的东东。

[Bullforg]

有没有报错
把SQL输出出来看看

[Cooly]

<script LANGUAGE="javascript">
<!--
var onecount;
onecount=0;

subcat = new Array();
subcat[0] = new Array("攻击","01","001");
subcat[1] = new Array("防御","01","002");
subcat[2] = new Array("觅食","01","003");
subcat[3] = new Array("贮食","01","004");
subcat[4] = new Array("繁殖","01","005");
subcat[5] = new Array("社群","01","006");
subcat[6] = new Array("通信","01","007");
subcat[7] = new Array("节律","01","008");
subcat[8] = new Array("本能","01","009");
subcat[9] = new Array("巴浦洛夫","02","010");
subcat[10] = new Array("珍妮特","02","011");
subcat[11] = new Array("hj","02","012");
onecount=12;

function changelocation(locationid)
{
document.myform.smalllocation.length = 0;

var locationid=locationid;
var i;
document.myform.smalllocation.options[0] = new Option('==所有==','');
//我添加的
document.myform.QueryKey.value=document.myform.biglocation.Text;

for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.smalllocation.options[document.myform.smalllocation.length] = new Option(subcat[i][0], subcat[i][2]);
}
}

}

//-->
</script>
<form name="myform" action="seach.asp" method="post">
<p>
<select name="biglocation" onChange="changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value)">
<option value="01">文字</option>
<option value="01">图片</option>
<option value="01">音像</option>
<option value="02">科学家
<option>
</select>
类
<select name="smalllocation">
<option value="" selected>=所有=</option>
</select>
</p>
<p> 　　
<input type="submit" name="Submit" value="搜索">
<input type="reset" name="Submit2" value="取消">
</p>

<!--我添加的-->
<input type="hidden" name="QueryKey">

</form>
<script LANGUAGE="javascript">
<!--
changelocation(document.myform.biglocation.options[document.myform.biglocation.selectedIndex].value);
//-->
</script> </p> </tr>

<%set objconn=server.createobject("adodb.connection")
objconn.open "dsn=ADB;database=sour;uid=;pwd=;"
set objrs=server.createobject("adodb.recordset")
'我修改的
sql="select word,URL From sour where leibie='"&request.form("QueryKey")&"'"
objrs.Open sql,objconn,3,2
%>

[hansun]

如果类别(leibie)是"文字","图片".....
那应该上面
<option value="01">文字</option>
<option value="01">图片</option>
<option value="01">音像</option>
<option value="02">科学家

就用错了，因为request.form("bigcolation") 肯定是得到bigcolation选择框的value 值的，所以得到的值就是 "01"或"02",所以当然就查不出来啦！
你应该在数据表里leibie用“01”、“02”来表示不同的类别。

[Cooly]

类别(leibie)是01，02 .....
还是 "文字","图片"..... ?

[feixuejian881]

是"文字","图片".....

[feixuejian881]

to cooly:谢谢你！可是按你写的做了，为什么查出来是0个记录呢?

[Cooly]

to feixuejian881:
你用
Response.write sql
Response.End
显示一下SQL字符串的内容，看看T-SQL语句是否正确，如果SQL语句无误，你再考虑创建一个Query来测试一下这条语句，看看返回结果集是否正确。

[Cooly]

其实你的问题不是SQL语句的语法错误，而是像 hansun(小虫) 所说的问题。

[Bullforg]

K~~为什么同样的回答我只得1分COOLY就得14分，不公平：（