On 5/24/07, Ian Skinner <[EMAIL PROTECTED]> wrote: > One can reference the outer query but one can not do it relying on the > generic current row. One has to fully qualify the outer query with its > own current row value, or some other row value that makes sense to what > one is trying to do.
I didn't think it was worth showing that more complicated way of accessing column data since it is easier to read with an intermediate variable, IMO. Of course, if you're going to access several columns, you might not want to create several local variables so direct access by column name and current row might be more appropriate. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:279131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
