ASP - Question about ADODB.Command object..

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Question about ADODB.Command object..

MSUTech

2006-12-05, 6:55 pm

Hello All,

I have 2 questions......

FIRST: if you are looping through INSERTING 500 users via a STORED
PROCEDURE, what parts of the Command Object can be INSIDE the loop and what
can be outside.... following is an example of how I did it..

Set ConnOb = Server.Createobject("ADODB.Connection")
ConnOb.Open Session("ConnectionString")
Set CmdOb = Server.Createobject("ADODB.Command")

*** LOOP ****
CmdOb.CommandText = "TheStoredProc"
CmdOb.CommandType = 4
CmdOb.Parameters.Append 'something'
CmdOb.Parameters.Append 'something else'
Set CmdOb.ActiveConnection = ConnOb
CmdOb.Execute
*** END LOOP ***

SECOND: How do I FLUSH the Parameter string after EACH loop???

thanks...

Sponsored Links