asp set comm=server.createobject("adodb.command")
With comm
.ActiveConnection=conn
.CommandText="lc_add"
.CommandType=adCmdStoredProc
.Parameters.Append .CreateParameter("@return_value",adInteger,adParamReturnValue )
.Parameters.Append .CreateParameter("@fieldlist",advarchar,adParamInput,300,fieldlist)
.Parameters.Append .CreateParameter("@valuelist",advarchar,adParamInput,4000,valuelist)
.Parameters.Append .CreateParameter("@id",adInteger,adParamInput,5,ID)
.Execute()
End With
changehouse=comm("@return_value")
response.Write changehouse
set comm=nothing
With comm
.ActiveConnection=conn
.CommandText="lc_add"
.CommandType=adCmdStoredProc
.Parameters.Append .CreateParameter("@return_value",adInteger,adParamReturnValue )
.Parameters.Append .CreateParameter("@fieldlist",advarchar,adParamInput,300,fieldlist)
.Parameters.Append .CreateParameter("@valuelist",advarchar,adParamInput,4000,valuelist)
.Parameters.Append .CreateParameter("@id",adInteger,adParamInput,5,ID)
.Execute()
End With
changehouse=comm("@return_value")
response.Write changehouse
set comm=nothing
如果,我从存储过程中获得了值,并赋给了@test我怎么把它赋到应用程序中去?
请问大力
这样传递参数与
“conn.execute ("lc_add '参数1', '参数2'")”
相比好处在哪?
假设我用存储过程中的SELECT 查出一个值并赋给@test(如:@test=3)
然后我想把这个值传给asp 中的变量te
这一步我应该怎么做?另外,我想知道,大家都用存储过程写什么啊??