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

Article View: comp.databases.ms-sqlserver

Article #152

Back to comp.databases.ms-sqlserver Previous Next

#152

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

Technical Details

Message-ID: <6gkb81$p52@sjx-ixn10.ix.netcom.com>

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

References: <01bd63e9$f944b000$b0b130ce@rudy>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f676,dbbe0726512ae021
X-Google-Attributes: gid10f676,public
X-Google-Thread: f816f,dbbe0726512ae021
X-Google-Attributes: gidf816f,public
X-Google-Thread: ff490,dbbe0726512ae021
X-Google-Attributes: gidff490,public
X-Google-Thread: 11493c,dbbe0726512ae021
X-Google-Attributes: gid11493c,public
X-Google-Thread: 104de1,dbbe0726512ae021
X-Google-Attributes: gid104de1,public
X-Google-Thread: 11301e,dbbe0726512ae021
X-Google-Attributes: gid11301e,public
From: "Fouad E. Arib" <fearib@ix.netcom.com>
Subject: Re: more than 1 parameter with cmd.execute (ADO) to stored procedure ?
Date: 1998/04/09
Message-ID: <6gkb81$p52@sjx-ixn10.ix.netcom.com>
X-Deja-AN: 342656237
References: <01bd63e9$f944b000$b0b130ce@rudy>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: Netcom
X-NETCOM-Date: Thu Apr 09 10:38:09 PM PDT 1998
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

Reply to Parent Message