在ASP中如何执行存储过程！

Question

参见：http://expert.csdn.net/Expert/TopicView1.asp?id=954758
http://expert.csdn.net/Expert/TopicView1.asp?id=957214

Answer 1

错了，不好意思，
应该是这个：http://expert.csdn.net/expert/topic/960/960666.xml?temp=.6925775

Answer 2

存储过程为
CREATE PROCEDURE yangk.tcl_xsyc_z 
@Begindate datetime,--所属周的起始日期和截止日期
@Enddate datetime,
@wplxdm varchar(10)
as
...'设置conn--> conn设置没有问题
  set conn=server.CreateObject("ADODB.Connection")
  conn.Open   "PROVIDER=SQLOLEDB;DATA SOURCE=SQL2;UID=;PWD=;DATABASE="'设置command对象
set cmd=server.createobject("adodb.command")
with cmd
     .activeconnection=conn
     .commandtext="tcl_xsyc_z" 
     .commandtype=4
'创建parameter
     .Parameters.append .createparameter("@Begindate",adDBDate,adParamInput,"2002-8-12")
     .parameters.append .createparameter("@Enddate",adDBDate,adParamInput ,"2002-8-18")
     .parameters.append .createparameter("@wplxdm",adVarWChar,adParamInput,"TV")
     .execute()
end with
为什么总是出错呀！
请高手解决一下，
急!

Answer 3

看看在存储过程中是否加上了"set nocount on/off"

Answer 4

<%conn.execute 'exec PROC_P'%>

Answer 5

<%conn.execute "exec PROC_P"%>

Answer 6

to: yangk_1980(小蝌蚪) 
给你一段我的ASP CALL SP的代码。希望对你有帮助，你的写法很简洁。
....
conn.Mode=admodereadwrite
conn.ConnectionString=constr
conn.CursorLocation=aduseclient
conn.open constr
set au_adocmd=server.CreateObject("adodb.command")
au_adocmd.CommandText="usp_addemployee"
au_adocmd.ActiveConnection=constr
au_adocmd.CommandType=adCmdStoredProc '4conn.BeginTrans
set p=au_adocmd.Parameters
p.Append au_adocmd.CreateParameter("RETURN_VALUE",3,4)
p.Append au_adocmd.CreateParameter("@lastname",200,1,12)
p.Append au_adocmd.CreateParameter("@firstname",202,1,12)
P.Append au_adocmd.CreateParameter("@titleofcourtesy",200,1,5)
P.Append au_adocmd.CreateParameter("@jobtitle",202,1,24)
p.Append au_adocmd.CreateParameter("@loginname",202,1,24)
p.Append au_adocmd.CreateParameter("@truename",202,1,24)
p.Append au_adocmd.CreateParameter("@password",202,1,30)
p.Append au_adocmd.CreateParameter("@department",202,1,24)
P.Append au_adocmd.CreateParameter("@birthday",135,1)
P.Append au_adocmd.CreateParameter("@hiredate",135,1)
p.Append au_adocmd.CreateParameter("@mailaddress",202,1,50)
P.Append au_adocmd.CreateParameter("@address",202,1,60)
P.Append au_adocmd.CreateParameter("@region",202,1,15)
P.Append au_adocmd.CreateParameter("@postalcode",200,1,12)
P.Append au_adocmd.CreateParameter("@officephone",200,1,12)
P.Append au_adocmd.CreateParameter("@extension",200,1,4)
P.Append au_adocmd.CreateParameter("@homephone",200,1,12)
P.Append au_adocmd.CreateParameter("@reportsto",3,1)
au_adocmd("@lastname")=trim(lastname)
au_adocmd("@firstname")=trim(firstname)
au_adocmd("@titleofcourtesy")=trim(titleofcourtesy)
au_adocmd("@jobtitle")=trim(jobtitle)
au_adocmd("@loginname")=trim(loginname)
au_adocmd("@truename")=trim(truename)
au_adocmd("@password")=trim(password)
au_adocmd("@department")=trim(department)
au_adocmd("@birthday")=birthday
au_adocmd("@hiredate")=hiredate
au_adocmd("@mailaddress")=trim(m_address)
au_adocmd("@address")=trim(post_address)
au_adocmd("@region")=trim(region)
au_adocmd("@postalcode")=trim(post_code)
au_adocmd("@officephone")=trim(off_phone)
au_adocmd("@extension")=trim(extension)
au_adocmd("@homephone")=trim(home_phone)
au_adocmd("@reportsto")=report_to
au_adocmd.Execute...

Answer 7

我的存储过程用了三个参数
两个时间参数declare @bdate datetime,
            declare @edate datetime,
一个字符串参数declare @str varchar(20)
那么我在ASP中掉用这三个参数并给值用
     P.Append au_adocmd.CreateParameter("@bdate",135,1)
     P.Append au_adocmd.CreateParameter("@edate",135,1)
     p.Append au_adocmd.CreateParameter("@str",202,1,20)
au_adocmd("@bdate")=cdate(bdate)
au_adocmd("@edate")=cdate(edate)
au_adocmd("@str")=trim(str)这样对吗！