<%


dim count
rs3.open"select xueyuan  from jiaoyuanclass group by xueyuan",conn,1,1
%>
<script language="JavaScript">
var onecount;
onecount=0;
subcat = new Array();
        <%
        count = 0
        do while not rs3.eof
        %>
subcat[<%=count%>] = new Array("<%= left(trim(rs3("xueyuan")),1)%>","<%= trim(rs3("xueyuan"))%>","无");
        <%
        count = count + 1
        rs3.movenext
        loop
       call rs3close()
       'call connclose()
        %>
onecount=<%=count%>;
function keydown()
 {
  document.getElementById("xue").length = 0;
  //document.getElementById(dd).length = 0;
  var xueyuan=document.ff.xueyuan.value;
  var i;
    for (i=0;i < onecount; i++)
        {
            if (subcat[i][0] == xueyuan)
            {
                //document.ff.gudingzhi.options[document.ff.gudingzhi.length] = new Option(subcat[i][1]);
                //var Data_School = new Option(subcat[i][1]);
                //var Data_School = subcat[i][1];
               //document.ff.gudingzhi.options[document.ff.gudingzhi.length] = new Option(subcat[i][1]);
               //document.getElementById("xue").innerHTML=subcat[i][1];
               document.getElementById("xue").innerHTML=subcat[i][1];
                //document.ff.gudingzhi.value=subcat[i][1];
               //document.getElementById(dd).value=subcat[i][1];
            }
            
            //else
            //{
            //    document.ff.gudingzhi.value="";  
            //}     
        }
 }
 

[ 本帖最后由 ysf0181 于 2010-7-1 17:21 编辑 ]

  没人会吗？
我是要输出到
<div id=xue></div>

一般我用VB

dim count
rs3.open"select xueyuan  from jiaoyuanclass group by xueyuan",conn,1,1
%>
<script language="JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
   count = 0
   do while not rs3.eof
 %>
     subcat[<%=count%>]=new Array("<%=left(trim(rs3("xueyuan")),1)%>","<%=trim(rs3("xueyuan"))%>","无");
 <%
    count = count + 1
    rs3.movenext
  loop
  call rs3close()
       'call connclose()
 %>
onecount=<%=count%>;
function keydown()
{
  document.getElementById("xue").length = 0;
  //document.getElementById(dd).length = 0;
  var xueyuan=document.ff.xueyuan.value;
  var i;
    for (i=0;i < onecount; i++)
        {
            if (subcat[i][0] == xueyuan)
            {
                //document.ff.gudingzhi.options[document.ff.gudingzhi.length] = new Option(subcat[i][1]);
                //var Data_School = new Option(subcat[i][1]);
                //var Data_School = subcat[i][1];
               //document.ff.gudingzhi.options[document.ff.gudingzhi.length] = new Option(subcat[i][1]);
               //document.getElementById("xue").innerHTML=subcat[i][1];
               document.getElementById("xue").innerHTML=subcat[i][1];
                //document.ff.gudingzhi.value=subcat[i][1];
               //document.getElementById(dd).value=subcat[i][1];
            }
            
            //else
            //{
            //    document.ff.gudingzhi.value="";  
            //}     
        }
}
数组的i,0存储的是学员i,1是什么？

数组的i,0存储的是学员的姓,1是学员的全名。

例如，陈天大，，相同的 i 值 ，，0---陈，，，1------陈天大

[ 本帖最后由 ysf0181 于 2010-7-2 21:30 编辑 ]

这个程序，对于输入框提示用户名，直接从数据库先下载到本地电脑，较好减少服务器负担用的。

例如，用户在输入框输入，陈 自动跳出所有 姓陈的名字，让用户很好选择。

<script language="JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
   count = 0
   do while not rs3.eof
%>
    subcat[<%=count%>]=new Array(3);
    subcat[<%=count%>][0]="<%=left(trim(rs3("xueyuan")),1)%>";
    subcat[<%=count%>][1]="<%=trim(rs3("xueyuan"))%>";
    subcat[<%=count%>][2]="无";
<%
    count = count + 1
    rs3.movenext
  loop
  call rs3close()
       'call connclose()
%>