TRY: sub AllRecord(middleid)
set cmd=server.CreateObject("adodb.command")
cmd.ActiveConnection=conn
cmd.commandtext="sp_new_AllRecord '传入参数'"
set ttt=cmd.execute
if not ttt.eof then
response.write ttt("allid")
end if
ttt.close
set cmd=nothing
end sub
conn.close
set conn=nothing
set cmd=server.CreateObject("adodb.command")
cmd.ActiveConnection=conn
cmd.commandtext="sp_new_AllRecord '传入参数'"
set ttt=cmd.execute
if not ttt.eof then
response.write ttt("allid")
end if
ttt.close
set cmd=nothing
end sub
conn.close
set conn=nothing
cmd.commandtext="sp_new_AllRecord '001' "
至于参数怎么传,你自己查一下asp的帮助,看看comman怎么传
好像是command.parameters.add("@middleid",参数值,参数类型)
我记得不是很请楚了
set cmd=server.CreateObject("adodb.command")
cmd.ActiveConnection=conn
cmd.commandtext="sp_new_AllRecord 'middleid'"
set ttt=cmd.execute
if not ttt.eof then
response.write ttt("allid")
end if
ttt.close
set cmd=nothing
end sub
conn.close
set conn=nothing
cmd.parameters.add("@变量名字",该变量的值)如果是字符加引号