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

Article View: comp.databases.ms-sqlserver

Article #151

Back to comp.databases.ms-sqlserver Previous Next

#151

From: 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

Technical Details

Message-ID: <01bd63e9$f944b000$b0b130ce@rudy>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f676,dbbe0726512ae021,start
X-Google-Attributes: gid10f676,public
X-Google-Thread: f816f,dbbe0726512ae021,start
X-Google-Attributes: gidf816f,public
X-Google-Thread: 104de1,dbbe0726512ae021,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: ff490,dbbe0726512ae021,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 11493c,dbbe0726512ae021,start
X-Google-Attributes: gid11493c,public
X-Google-Thread: 11301e,dbbe0726512ae021,start
X-Google-Attributes: gid11301e,public
From: "Rudy Truyens" <TruyensR.VDK@glo.be>
Subject: more than 1 parameter with cmd.execute (ADO) to stored procedure ?
Date: 1998/04/09
Message-ID: <01bd63e9$f944b000$b0b130ce@rudy>
X-Deja-AN: 342498402
Organization: Customer of Globe Internet NV
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.misc,microsoft.public.sqlserver.programming,microsoft.public.vb.enterprise,microsoft.public.vb.general.discussion