Tony: "i think thats what sean said, kinda :)" Well Sean said "You can't reference outer.somecol directly inside the inner loop" and I said "One can reference the outer query" so in that respect I think we rather said the opposite.
But your general gist is correct. This is just one of those places where the short cuts ColdFusion allows, in this case not worrying about specifically referencing the rows of queries, fails with more complex code structures. When this happens one does need to utilize more explicit programming concepts. Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

