your almost there, you us ethe columnlist to get the column names, and then evaluate them to get the data. e.g <cfoutput query="yourquery"> <cfloop list="#queryname.columnlist#" index="column"> #evaluate(column)#<br> </cfloop> </cfoutput> someone will pipe up and tell you not to use evaluate very shortly, but i don't care :-) Russ Michaels Macromedia/Allaire Certified ColdFusion Developer Satachi Internet Development
Phone: 0870 787 3610 Tech Support: 0906 9607800 FAX: 0709 2212 636 <http://www.satachi.com/> http://www.satachi.com email general: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] email support: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Join our ColdFusion Developer discussion lists. Send an e-mail to <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] -----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] Web: www.uhcw.nhs.uk
