db, true that... To specify, I am using a single ADO command (and connection) object(s) in a script, and more than one subroutine uses them. Since each stored procedure has a different number of arguments, I can't leave the references hanging around. Is there any benefit to creating and destroying a new ado command object each time (sharing only the connection object)?
-----Original Message----- From: Jenda Krynicky [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 7:45 AM To: [EMAIL PROTECTED] Subject: RE: Win32::ODBC vs Win32::ADO From: [EMAIL PROTECTED] To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> This should have been sent to perl-win32-database. > I had allot of trouble finding good info about this, so I finally just > tried everything... this is a quick cut and paste (i.e. may not work > without mod) of the result. Most notable was the need to remove the > parameter references before using the objects again - or else you get > invalid number of argument errors. No you do not need to. You can simply change the parameter values next time you need to call that procedure: I'm not 100% sure about the syntax since I do not use ADO from Perl but something like : $ADO_Command->Parameters->{"strGroupName"} = 'OtherGroup'; should work. Jenda =========== [EMAIL PROTECTED] == http://Jenda.Krynicky.cz ========== There is a reason for living. There must be. I've seen it somewhere. It's just that in the mess on my table ... and in my brain I can't find it. --- me _______________________________________________ Perl-Win32-Admin mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs Visit our website at http://www.ubswarburg.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments. _______________________________________________ Perl-Win32-Admin mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
