var dbConn=Server.CreateObject("adodb.connection");
dbConn.Open(Application("strConn"));
//var dbCmd=Server.CreateObject("adodb.command");
//with(dbCmd){
// ActiveConnection = dbConn;
// CommandType = 4;
// CommandText = "DeptTree";
// var objRs=Execute(null,parseInt(id));
//}
var objRs=Server.CreateObject("adodb.recordset");
var sql="SELECT (select count(*) from xtree where xtree.parentid=x.id) AS children, *
FROM xtree AS x
WHERE parentid="+id+"";
objRs=dbConn.Execute(sql)
SELECT (select count(*) from xtree where xtree.parentid=x.id) AS children, *
FROM xtree AS x
WHERE parentid=[@parentid];
这句话直接写在sql存储过程好象不行的!?要声明吧.如何改写?
因为数据库我不方便修改.
SELECT (select count(*) from xtree where xtree.parentid=x.id) AS children, *
FROM xtree AS x
WHERE parentid=[@parentid];
这句话能否在程序中建立?我替换到text中去,结果无法运行.
还有,阿信的代码只要有一点错误就显示无法加载,看不到出错信息,很难调试,有没有解决方法?