How do you output a particular value from a query? I have stored a query as application.companynames This query currently contains 3 columns: id, name, description If I know the particular id of the company I am looking for, and application.companynames contains every company in the database, how do I output the company's name? I know this is easy to do with lists (listgetat) but how do I do it from a query that can contain multiple columns? Cheers Seth ________________________________________________________________________ This message has been checked for all known viruses, by Star Internet, delivered through the MessageLabs Virus Control Centre. For further information visit: http://www.star.net.uk/stats.asp ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.