有人能帮我看看这一段怎么改吗?我觉得关键是这一段的问题
<%
//** Power By Fason
//** Email:[email protected]
var strDBName = "database/data.mdb";
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.Mappath(strDBName)
var dbConn = Server.CreateObject("adodb.connection");
dbConn.Open(strConn);
var ResponseHTML="";
function List(key,id)
{
var dbCmd=Server.CreateObject("adodb.command");
with(dbCmd){
ActiveConnection = dbConn;
CommandType = 4;
CommandText = "sp_select";
var objRs=Execute(null,(id?id:0));
还有把
SELECT (select count(*) from xselect where xselect.parentid=x.id) AS children, *
FROM xselect AS x
WHERE parentid=[@parentid]
ORDER BY id;
这一段放到存储过程中怎么弄,谢谢了
<%
//** Power By Fason
//** Email:[email protected]
var strDBName = "database/data.mdb";
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.Mappath(strDBName)
var dbConn = Server.CreateObject("adodb.connection");
dbConn.Open(strConn);
var ResponseHTML="";
function List(key,id)
{
var dbCmd=Server.CreateObject("adodb.command");
with(dbCmd){
ActiveConnection = dbConn;
CommandType = 4;
CommandText = "sp_select";
var objRs=Execute(null,(id?id:0));
还有把
SELECT (select count(*) from xselect where xselect.parentid=x.id) AS children, *
FROM xselect AS x
WHERE parentid=[@parentid]
ORDER BY id;
这一段放到存储过程中怎么弄,谢谢了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货