asp中使用簡單的預存程序

set comm = Server.CreateObject("ADODB.COMMAND")
comm.CommandText = "keywordcount"'過程名
comm.CommandType = 4'4表示為預存程序
set comm.activeconnection=conn
comm.Parameters.Append comm.CreateParameter("tseek",advarchar,adParamInput,50,keyword)
comm.parameters.append comm.createparameter("counts",adinteger,adparamoutput,4,counts)
comm.execute()
counts=comm("counts")
'''''''''''''''''從這裡開始修改為下面的 set rs=Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3
rs.open comm