<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>11</TITLE>
<%dim conn
set conn=server.CreateObject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source="&server.mappath("bshujif.mdb")
sqlstr="select * from sort"
set rs=conn.execute(sqlstr)
set rs1=server.CreateObject("adodb.recordset")
sqlstr1 = "select * from nsort order by sort_id desc"
set rs1 = conn.execute(sqlstr1)
%>
<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
CountLinkAction = 0
do while not rs1.eof
%>
subcat[<%=CountLinkAction%>] = new Array("<%= trim(rs1("nsort_name"))%>","<%= trim(rs1("sort_id"))%>");
<%
CountLinkAction = CountLinkAction + 1
rs1.movenext
loop
rs1.close
set rs1=nothing
%>
onecount=<%=CountLinkAction%>;
function changelocation(locationid)
{
document.form1.nsort.length = 0;
var locationid=locationid;
var i;
document.form1.nsort.options[0] = new Option('选择小类','');
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.form1.nsort.options[document.form1.nsort.length] = new Option(subcat[i][0], subcat[i][0]);
}
}