Hi, Everyone:

Does anyone know how to loop a recordset which is within another recordset
loop? Here is my code:

-------------------------------
rs.Open datasource

set getFirst = rs.Execute ("select * from FirstTable")

Do While Not getFirst.EOF

getSecond=rs.Execute("select * from SecondTable" _
& " where SomeID= " & getFirst.Fields("FirstID"))

Do While Not getSecond.EOF
response.write getSecond.Fields("SomeField") & "<br>"
getSecond.MoveNext
Loop

getFirst.MoveNext
Loop
---------------------------

This didn't work and the error message says, "Object doesn't support this
property or method: 'EOF' "

I used a different recordset name for the second query but same thing happened.
Any idea?

Nathan Chen