大家帮忙看看, 以下的代码错在哪里Set conn = Server.CreateObject("ADODB.Connection")
connstr = "Provider=sqloledb; User ID=sa; Password=; Initial Catalog=frontier_defence; Data Source=192.168.10.117"
conn.open connstr
rs = Server.CreateObject("ADODB.Recordset")
rs.open("select *,(select count(*) from doc_type where parent_sort_id = dt.doc_sn) as children from doc_type dt where parent_sort_id="+NodeId,conn,1,3)if(!rs.eof){
while(!rs.eof){
ResponseXml+="<TreeNode id='"+String(rs("doc_sn"))+"'>\r\n"
ResponseXml+="<NodeText>"+String(rs("sort_name")).EncodeHTML()+"</NodeText>\r\n"
ResponseXml+="<title></title>\r\n"
ResponseXml+="<NodeUrl>"+(String(rs("sort_id"))!="null"?String(rs("sort_id")).EncodeHTML():"")+"</NodeUrl>\r\n"
ResponseXml+="<child>"+String(rs("children"))+"</child>\r\n"
ResponseXml+="<target></target>\r\n"
ResponseXml+="</TreeNode>\r\n"
rs.movenext
}
}
connstr = "Provider=sqloledb; User ID=sa; Password=; Initial Catalog=frontier_defence; Data Source=192.168.10.117"
conn.open connstr
rs = Server.CreateObject("ADODB.Recordset")
rs.open("select *,(select count(*) from doc_type where parent_sort_id = dt.doc_sn) as children from doc_type dt where parent_sort_id="+NodeId,conn,1,3)if(!rs.eof){
while(!rs.eof){
ResponseXml+="<TreeNode id='"+String(rs("doc_sn"))+"'>\r\n"
ResponseXml+="<NodeText>"+String(rs("sort_name")).EncodeHTML()+"</NodeText>\r\n"
ResponseXml+="<title></title>\r\n"
ResponseXml+="<NodeUrl>"+(String(rs("sort_id"))!="null"?String(rs("sort_id")).EncodeHTML():"")+"</NodeUrl>\r\n"
ResponseXml+="<child>"+String(rs("children"))+"</child>\r\n"
ResponseXml+="<target></target>\r\n"
ResponseXml+="</TreeNode>\r\n"
rs.movenext
}
}
解决方案 »
- 怎么通过JS获取到表单File框里的值?
- 有关js判断checkbox,注册用
- 添加了option,但是无法选中option
- js 如何调用其他语言的函数
- 如何让页面在任何浏览器中都能正常显示?
- 在jsp中,在servlet中整型转换总说是数字转换错误,这是为什么?
- 一个JAVASC的简单问题,请看!
- js最初设计是在浏览器端解释执行,后来为什么搞个node.js把他放在服务器端执行呢,这样有什么好处?
- 有点急,大家帮忙看下‘图片横向移动的’js代码,有问题。
- failed to execute 'getComputedStyle' on 'Window' : parameter 1 is not of type 'E
- form里不能响应向上或向下的键盘事件?
- 表单验证时,判断输入的值是不是以“13”开头的。
connstr = "Provider=sqloledb; User ID=sa; Password=; Initial Catalog=frontier_defence; Data Source=192.168.10.117"
conn.open connstr
rs = Server.CreateObject("ADODB.Recordset")
rs.open("select *,(select count(*) from doc_type where parent_sort_id = dt.doc_sn) as children from doc_type dt where parent_sort_id="+NodeId,conn,1,3)do while not rs.eof
ResponseXml+="<TreeNode id='"+String(rs("doc_sn"))+"'>\r\n"
ResponseXml+="<NodeText>"+String(rs("sort_name")).EncodeHTML()+"</NodeText>\r\n"
ResponseXml+="<title></title>\r\n"
ResponseXml+="<NodeUrl>"+(String(rs("sort_id"))!="null"?String(rs("sort_id")).EncodeHTML():"")+"</NodeUrl>\r\n"
ResponseXml+="<child>"+String(rs("children"))+"</child>\r\n"
ResponseXml+="<target></target>\r\n"
ResponseXml+="</TreeNode>\r\n"
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing=======================
另连数据库的字符串那里也要仔细检查
你可以单独拿出这个页面来进行调试
conn.Open ("Provider=sqloledb; User ID=sa; Password=; Initial Catalog=frontier_defence; Data Source=192.168.10.117");
rs=server.createobject("adodb.recordset");
strsql="select *,(select count(*) from doc_type where parent_sort_id = T.doc_sn) as children from doc_type T where parent_sort_id='" & NodeId & "'";
rs.Open(strsql,conn,1,3);就以上代码中有错误, 大家帮忙改该阿!
----sql2000----
var conn,rs,strsql;
conn=Server.CreateObject("ADODB.Connection");
conn.Open ("Provider=sqloledb; User ID=sa; Password=; Initial Catalog=frontier_defence; Data Source=192.168.10.117");
rs=server.createobject("adodb.recordset");
strsql="select *,(select count(*) from doc_type where parent_sort_id = T.doc_sn) as children from doc_type T where parent_sort_id='" & NodeId & "'";
rs.Open(strsql,conn,1,3);---ACCESS---
var conn,rs;
conn = Server.CreateObject("ADODB.Connection")
conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.mappath("tree.mdb")+";Persist Security Info=False")
rs = Server.CreateObject("ADODB.Recordset")
rs.open("select *,(select count(*) from deeptree where parent_sort_id = T.doc_sn and level>="+level+") as children from deeptree T where parent_sort_id="+NodeId+" and level>="+level,conn,1,3)
大小写要注意
rs=Server.CreateObject
strsql="select *,(select count from doc_type where parent_sort_id = T.doc_sn) as children from doc_type T where parent_sort_id="+NodeI+"";嘿嘿。你搞错了。