急!!!这个调用存储过程的错误在哪里啊!!请高人指点啊!!在线

 1   
 2set myconn=server.createobject("adodb.connection")   
 3set mycommand=server.createobject("adodb.command")   
 4connstr="provider=sqloledb;user id=sa;password=ser;initial catalog=vod;persist security info=true;data source=localhost"   
 5myconn.open connstr   
 6set mycommand.activeconnection=myconn   
 7mycommand.commandtype=adcmdstoredproc   
 8MyCommand.CommandText="sp_Checkrec"   
 9set param1=mycommand.createparameter("@para_hyid",advarchar,adparaminput,30)   
10mycommand.parameters.append param1   
11set param2=mycommand.createparameter("@para_reccounts",adint,adparamoutput,8)   
12mycommand.parameters.append param2---------------------!!!!出错行   
13param1.value="gaohan"   
14MyCommand.Execute   

会员gaohan共点播``` '=param2(0)

MyConn.Close

 1创建参数1成功,参数2怎么就出错呢?请指教,一定给分!!   
 2\---------------------------------------------------------------   
 3  
 4set param2=mycommand.createparameter("@para_reccounts",adint,adparamoutput,,8)   
 5试试   
 6\---------------------------------------------------------------   
 7  
 8Set myCommand = server.CreateObject("ADODB.Command")   
 9myCommand.ActiveConnection = Connection   
10myCommand.CommandType = adCmdStoredProc   
11myCommand.CommandText = ProcedureName   
12  
13myCommand.Parameters.Refresh --看看是不是少一这句   
14  
15myCommand.Parameters("@para_hyid(参数名)")="你的这个参数的值" --你试试这种方法创建看看   
16  
17\---------------------------------------------------------------   
18  
19set param2=mycommand.createparameter("@para_reccounts",adInteger,adparamoutput)   
20你可能写错了,应该是 adInteger   
21\---------------------------------------------------------------   
22  
23中间有两句没断行   
24set param1=mycommand.createparameter("@para_hyid",advarchar,adparaminput,30)   
25mycommand.parameters.append param1   
26set param2=mycommand.createparameter("@para_reccounts",adinteger,adparamoutput,4)   
27mycommand.parameters.append param2   
28param1.value="gaohan"   
29MyCommand.Execute   
30%>   
31会员gaohan共点播```
32=myCommand.parameters(1).value
33```个节目   

MyConn.Close

Published At
Categories with Web编程
Tagged with
comments powered by Disqus