Forum OpenACS Q&A: Response to Multiple Selection...while loops

Collapse
Posted by Michael A. Cleverly on
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.