Sorry if this is a double post ... posted on the houseoffusion site and it's not showing up:
--------- Man you guys are quick ... thanks for the responses. First off, I should have specified ... this is CF 5. And to answer Ray, yes that is what I meant ... I want the value that is contained in 'GetUsers.Name' for that particular record. Sometimes it might be only one record, and other times it might be within a cfoutput that is displaying many records. Maybe I should also note that I don't work on 'Enterprise Level' stuff and the tables don't contain tens of thousands of records. Usually a few thousand at most. Thanks for the help. You guys are great. Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4