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.

Reply via email to