[thelist] stuck in a loop (classic asp/mssql)

[Brian Cummiskey]

Ken Schaefer wrote:

>Why are you opening two connections?
>  
>
good question.  I didn't even notice that...

>Surely:
>	comm.ActiveConnection = connstr1
>should be:
>	Set comm.ActiveConnection = oConn
>?
>
>  
>
I'll have to play with this at the office tomorrow.  It works in its 
current state though.  I'll see what i come up with tomorrow.

Thanks