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