Error Too Many Client Tasks

[matttoby]

I am attempting to open up one recordset and then loop through this recordset and create a new recordset on each loop through.

E.G.

SET RSouter = server.createobject("adodb.recordset&quot
SQL = "SELECT * FROM xxx WHERE xxx"
RSouter.open SQL,”DSN=xxx”

DO until Rsouter.EOF

SET RSinner = server.createobject("adodb.recordset&quot
SQL = "SELECT xxx FROM xxxx WHERE id = Rsouter("id&quot
RSinner.open SQL,"DSN=xxx"

<!--Modify RSinner-->

RSinner.close

RSouter.movenext

Loop
Rsouter.close

However I am receiving an error saying Too many client tasks. Any help would be much appreciated as I have come up against this problem a number of times.

 

[chiph]

Try setting RSinner to nothing after closing it.

BTW, it would be more efficient if you were to code this into one SQL statement (if possible).

Chip H.