紧急求助!!!如何在ASP中调出这个存储过程?
存储过程代码如下:
CREATE PROCEDURE [test3]
@netno varchar (20)
AS
select netno, netkind into #tt1 from net
where netno like '%' + @netno + '%'
order by netno
select * from #tt1 order by netno
GO
在ASP中该如何调出来呢?
我在ASP中的代码如下:是这段代码没写完整还是何原因?
<%
set thisform = "test3.asp"
if request("b1") = "查询" then
session.contents("netno") = request("netno")
end if
const adInteger = 3
const adParamInput = 1
const adVarchar = 200
const adParamReturn = 4
const adDouble = 6
set comm = server.CreateObject("ADOdb.Command")
comm.ActiveConnection = conn '数据库的连接对象
comm.CommandType = 2 '执行command的类型
comm.CommandTimeout= 0
comm.Prepared = true
comm.CommandText = "test3" '存储过程的名称
comm.Parameters.Append comm.CreateParameter("@netno", adVarchar, adParamInput, 50, session.contents("netno")) '参数3,把psd值传到存储过程中。
set rs = comm.Execute
showContent
%>