Not sure why it would help, but depending on the database; would querying the control tables help? In SQLserver for example, you can query sysobjects/syscolumns?
-----Original Message----- From: Osullivan Karl (RKB) Senior Analyst/Programmer [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 15:53 To: CF - Development Group Subject: [ cf-dev ] CFQUERY - outputting a table without knowing the fields in it UHCWT Logo Hi All. Can anyone help me with this problem? I'm being passed a SQL table name and a unique_id via a URL, which is the table I need to query. I return all fields (SELECT *) in the table (whose structure I do not know), where the EntryId (which is always a field in the table) equals the unique_id. I then want to display the data, along with the field names from the table. However, the CFQUERY.columnlist shows all the fields in alphabetical order. Is there another way to get the field names and data displayed (eg loading it into a structure or something?) Thanks Karl O'Sullivan Senior Analyst/Programmer Computer & Network Services UHCW NHS Trust Clifford Bridge Road COVENTRY CV2 2DX Contact: Tel (internal): 28952 Tel (external): +44 (0) 24 7696 8952 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web: www.uhcw.nhs.uk <http://www.uhcw.nhs.uk> DISCLAIMER: This e-mail is confidential and may also be legally privileged. If you are not the intended recipient, use of the information contained in this e-mail (including disclosure, copying or distribution) is prohibited and may be unlawful. Please inform the sender and delete the message immediately from your system. This e-mail is attributed to the sender and may not necessarily reflect the views of the Patsystems Group and no member of the Patsystems Group accepts any liability for any action taken in reliance on the contents of this e-mail (other than where it has a legal or regulatory obligation to do so) or for the consequences of any computer viruses which may have been transmitted by this e-mail. The Patsystems Group comprises Patsystems plc and its subsidiary group of companies.
