Whoa! How many object calls do you want? Did you see my reply to this mail?
David L. Penton, Microsoft MVP JCPenney Technical Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Daniel Field [mailto:[EMAIL PROTECTED]] Cheers! That will do the job nicely!! -----Original Message----- From: Scott [mailto:[EMAIL PROTECTED]] hey Daniel I have a little sub in my global file that might do the trick? sub ClearCmdParams(ACmd) do until ACmd.Parameters.Count = 0 ACmd.Parameters.Delete(ACmd.Parameters.Count-1) loop end sub cheers ----- Original Message ----- From: "Daniel Field" <[EMAIL PROTECTED]> : Hi All, : : I have a script that loops through a recordset calling a Stored Procedure : each time like: : : : Set oCmd = CreateObject("ADODB.Command") : oCmd.CommandType = &H0004 : oCmd.CommandText = "MY STORE PROCEDURE" : oCmd.ActiveConnection = myconnection : : : Do while [statement] : : oCmd.Parameters.Append : oCmd.CreateParameter("@fullXML",adLongVarChar,adParamInput,Len(fullXML)+1,fu : llXML) : : oCmd.Execute ,,adExecuteNoRecords : : Loop : : What is the best way of clearing the parameters each loop? I am currently : set the oCmd object to nothing and recreating it each loop, but I know this : is not the best way of doing it! : : Thanks, : : Dan --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
