There's a Delete Method for the Parameters Object, works well. http://www.devguru.com/Technologies/ado/quickref/command_parameterscollectio n.html
HTH, Nick -------------------------- Nick Middleweek Web Applications Developer Tel: +44(0)1525 375 778 Mob: +44(0)774 035 5424 [EMAIL PROTECTED] :> -----Original Message----- :> 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]
