I thought about that, but other than style, is there any advantage to one technique
over the other? Database connections aren't free, but neither are lists and arrays...
Thanks for all the responses!
Ian
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
mailto: [EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 09/05/01 02:38PM >>>
> I have a form that is generated from a query result set, and in each
> record, there is a select widget which is, in turn, generated from a
> query result set. I can't run the inner query until the outer query
> is exhausted, so I need 2 handles, I think!
Personally, I think I would run the first query until it's through, saving
the data in whatever format you want, a list or an array, and then go
through and do the second set of queries. But that's just me.
Another poster mentioned that you can get multiple handles from one call
of ns_db gethandle.
Rusty
------------------------------------------
Rusty Brooks : http://www.rustybrooks.org/
Spewing wisdom from every orifice
------------------------------------------
