调用sqlserver的过程 急等 谢谢

[bephidt]

我要从asp调用存储过程pro_connectnote
有三个参数 @starttime,@endtime,@departmentname

qssj,jzsj,departmentname为三个变量

请问这样写为什么不对
set rs=conn.execute ("execute Pro_ConnectNote "&qssj&","&jzsj&","&departmentname)
非常感谢

[darkbug]

dim rs(3)

for i=0 to 2
set rs(i)=Server.CreateObject("ADODB.Recordset")
SQLcmd = "Select top " + CStr(i + 1)+ " * From MEMBER order by id"
response.write sqlcmd
rs(i).Open SQLcmd, conn,0,1
next
先声明一下rs(3)
建议写程序的时候引用变量先声明

[postfix2]

1)
set rs=conn.execute ("execute Pro_ConnectNote '"&qssj&"','"&jzsj&"','"&departmentname&"'")
2)
set cmd=server.createobject("adodb.command")
set cmd.activeconnection=conn
cmd.commandtype=4
cmd.commandtext="Pro_ConnectNote"
set tmp1=cmd.createparameter("userid",200,1,50)
cmd.parameters.append tmp1
set tmp2=cmd.createparameter("userpwd",200,1,50)
cmd.parameters.append tmp2
set tmp3=cmd.createparameter("retvalue",200,1,50)
cmd.parameters.append tmp3
cmd("userid")=qssj
cmd("userpwd")=jzsj
cmd("retvalue")=departmentname
cmd.execute

[sinusoid]

要这样写：
set rs=conn.execute ("execute Pro_ConnectNote @starttime="&qssj&",@endtime="&jzsj&",@departmentname="&departmentname)

[sinusoid]

对不起，类型要改一下：
set rs=conn.execute ("execute Pro_ConnectNote @starttime='"&qssj&"',@endtime='"&jzsj&"',@departmentname='"&departmentname&"'")

[歪歪]

回复人： sinusoid(黑眼圈) ( ) 信誉：101 2004-05-08 12:41:00 得分:0


对不起，类型要改一下：
set rs=conn.execute ("execute Pro_ConnectNote @starttime='"&qssj&"',@endtime='"&jzsj&"',@departmentname='"&departmentname&"'")


Top