Mark Boyd
MarkBoyd at McBeeAssociates.com
Wed Apr 23 09:47:15 CDT 2003
Susan - Thanks for the reply. I think I figured it out. My problem was with using the 'cmd.parameters.append...' code. I wasn't specifying the size (length) of the parameter. Although, your example seems a lot easier and straightforward. Thanks again, Mark -----Original Message----- From: Susan Harkins [mailto:harkins at iglou.com] Sent: Wednesday, April 23, 2003 10:04 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer]Pass Parameters to Sproc EXECUTE spname parameter1, parameter2 ConnectionProject.Connection.Execute spname parameter1, parameter2 ???? Susan H. I know this is probably a simple thing to do. I also know I've seen this post show up quite a few times on this list. I tried accessing the archives, but the site seems to be down. What is the proper syntax for passing 2 parameters to a stored procedure from a module? I believe I have the sproc syntax fine for receiving the parameters, but I can't seem to get the code syntax to send them. TIA, Mark Boyd Sr. Systems Analyst McBee Associates, Inc. _____ _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030423/4d5950eb/attachment.html>