[ cf-dev ] CFQUERY - outputting a table without knowing the fields in it

[Osullivan Karl (RKB) Senior Analyst/Programmer]

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] Web: www.uhcw.nhs.uk