<% function OpenDB(sdbname) { var connstr = "driver={sql server};server=.;UID=sa;PWD=;database="+sdbname+"" ; var conn = Server.CreateObject("ADODB.Connection"); conn.Open(connstr); return conn; } var conn =OpenDB("zuowen"); var province = Request("sel"); var arrResult = new Array(); var sql = "select class from grade where grade='"+province+"'"; var rs = Server.CreateObject("ADODB.Recordset"); rs.Open(sql,conn,1,1); while(!rs.EOF) { //遍历所有适合的数据放入arrResult数组中. arrResult[arrResult.length] = rs("class").Value; rs.MoveNext(); } //escape解决了XMLHTTP。中文处理的问题. //数组组合成字符串.由","字符串连接. Response.Write(escape(arrResult.join(","))); %> 这段连接SQL的没有问题
据说javascript的输出语句是document.write
var connstr = "driver={sql server};server=.;UID=sa;PWD=;database="+sdbname+"" ; 错的低级!!!!!
写在ASP段里,当然报错了
原来是连接SQL的没问题,为什么换成连接ACESS就出问题了.
<% @Language="JavaScript" %>
<%
function OpenDB(sdbname)
{
var connstr = "driver={sql server};server=.;UID=sa;PWD=;database="+sdbname+"" ;
var conn = Server.CreateObject("ADODB.Connection");
conn.Open(connstr);
return conn;
}
var conn =OpenDB("zuowen");
var province = Request("sel");
var arrResult = new Array();
var sql = "select class from grade where grade='"+province+"'";
var rs = Server.CreateObject("ADODB.Recordset");
rs.Open(sql,conn,1,1);
while(!rs.EOF)
{
//遍历所有适合的数据放入arrResult数组中.
arrResult[arrResult.length] = rs("class").Value;
rs.MoveNext();
}
//escape解决了XMLHTTP。中文处理的问题.
//数组组合成字符串.由","字符串连接.
Response.Write(escape(arrResult.join(",")));
%>
这段连接SQL的没有问题