On 2003.03.15, Jeremy Cowgar <[EMAIL PROTECTED]> wrote: > Can I not nest ns_db select statements?
Not using the same database connection handle, since you're still in the middle of fetching an existing resultset. Write a simple helper proc that pulls the entire resultset back at once, and another proc that easily helps you iterate over the resultset stored in memory ... then you can "appear" to have nested queries or the feeling of cursors ... -- Dossy -- Dossy Shiobara mail: [EMAIL PROTECTED] Panoptic Computer Network web: http://www.panoptic.com/ "He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on." (p. 70) I. To remove yourself from this list: Send a message to "[EMAIL PROTECTED]" with the following text in the BODY of your message: signoff aolserver II. For a complete list of listserv options please visit: http://listserv.aol.com/ III. For more AOLserver information please visit: http://www.aolserver.com/
