Forum OpenACS Q&A: Response to Multiple Selection...while loops
2: Response to Multiple Selection...while loops (response to 1)
Posted by Michael A. Cleverly on 10/23/00 10:46 PM
Assuming you don't break out of your while loop early (in which case you'd need to do a ns_db flush $db) then simply do another set selection [ns_db select $db "..."] and loop through it in a subsequent while loop.
You can re-use any handle as long as you've previously read back any waiting rows, or have manually flushed it.