more than 1 parameter with cmd.execute (ADO) to stored procedure ?

Thread View: comp.databases.ms-sqlserver

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Rudy Truyens Thu, 09 Apr 1998 00:00

#151

Author: Rudy Truyens
Date: Thu, 09 Apr 1998 00:00

12 lines
1435 bytes

I succeeded to pass a parameter to my stored procedure, but I can't figure
out how to pass more than one...
cmd.commandtext = "sp_test"
set rs=cmd.execute (,parm1)
this works, but what if I make a stored procedure that accepts two
parameters (datetime) and I want to pass two dates to it ...?
set rs=cmd.execute (,parm1,parm2) does not work.

I use VB5, ADO and SQL6.5

Please mail to Truyensr.VDK@glo.be

Re: more than 1 parameter with cmd.execute (ADO) to stored procedure ?

#152

Author: Fouad E. Arib
Date: Thu, 09 Apr 1998 00:00

7 lines
1249 bytes

Try passing the parameters as follows:

cmd.commandtext = "sp_test"
set rs=cmd.execute (,Array(parm1,parm2,parm3))

Ed Arib

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads