reseting adodb commands? help please
 

Is there any way to reset a adodb command?

i have this code:

auxString = xmlDoc.documentElement.XML
auxLong = Len(auxString)
cmd.ActiveConnection = con
cmd.CommandText = "PLANOS_PACK.Insert_Data"
cmd.CommandType = adCmdStoredProc
Set InputParam = cmd.CreateParameter("input", adLongVarChar,
adParamInput, auxLong, auxString)
cmd.Parameters.Append InputParam
cmd.Execute

that is in a loop, it works for the first iteration, but in the second
it gives me an error, founded < when expecting string delimeter
I can do it without the cycle, but then i have a string to large and
receive errors like, "result of string concatenation is too long" or
"string literal is too long" or even "missing expression".

any help would be appreciated.

Thanks,


--
Jlorga
------------------------------------------------------------------------
Jlorga's Profile: http://www.excelforum.com/member.php...o&userid=31707
View this thread: http://www.excelforum.com/showthread...hreadid=519331