This topic is locked

2 Tables at once

11/10/2005 7:45:35 PM
ASPRunnerPro General questions
author

Hey! I'm playing with http://g.1asphost.com/killgorack/maps/disc...ion/default.asp and I need to open two tables at once, I'm not sure how to do this! I'm getting data out of a table within a loop and do not wish to close it before the loops finishes. I ned a little direction. I realise that this is common practice! I'm just a bit green.

Sergey Kornilov admin 11/11/2005

David,
you don't need to close a recordset before opening a new one.

Just use another variable name for new recordset object.

500381 11/11/2005

I guess that makes sence I tried it and it worked thanks... its always the simple stuffs..