ASP中二级联动问题,急在线等待。

来源:百度知道 编辑:UC知道 时间:2024/06/30 23:51:49
下面是页面源代码,帮我看一下问题出在哪里,现在一旦更改大类的话,小类就读不到数据库中的数据。由于字数限制,部分非关键代码已删除
<%dim pid
pid=request("ArticleID")%>
<script language = "JavaScript">
var onecount;
subcat = new Array();
<%
count = 0
do while not rs.eof
%>
subcat[<%=count%>] = new Array("<%= trim(rs("SmallClassName"))%>","<%= trim(rs("BigClassName"))%>","<%= trim(rs("SmallClassName"))%>");
<%
count = count + 1
rs.movenext
loop
rs.close
%>
onecount=<%=count%>;

function changelocation(locationid)
{
document.myform.SmallClassName.length = 1;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{ <

将以下代码放到<script language = "JavaScript">的前面就可以了。
<%dim pid
pid=request("ArticleID")
sql="select * from product where id="&pid
Set rs_home= Server.CreateObject("ADODB.Recordset")
rs_home.open sql,conn,1,1%>
<%
dim rs
dim sql
dim count
set rs=server.createobject("adodb.recordset")
sql = "select * from SmallClass order by SmallClassID asc"
rs.open sql,conn,1,1
%>

笨蛋,这个问题好解决,但不好直接回覆,有兴趣QQ(57659930)说话