Ok Just wanted to check that I wasn't going mad and couldn't do it in ColdFusion!
I will have to find out how intersystems' Cache stores its system tables! Hmmmmm..... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 15:54 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFQUERY - outputting a table without knowing the fields in it you could query the systables to find out the structure of this table, store that in your struct, then output it in the order you want. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Osullivan Karl (RKB) Senior To: CF - Development Group <[EMAIL PROTECTED]> Analyst/Programmer cc: " Subject: [ cf-dev ] CFQUERY - outputting a table without knowing the <[EMAIL PROTECTED] fields in it cw.nhs.uk> 10/09/2003 15:53 Please respond to dev 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 Computer & Network Contact: Senior Services Tel (internal): 28952 Analyst/Programmer UHCW NHS Trust Tel (external): +44 (0) 24 Clifford Bridge Road 7696 8952 COVENTRY Email: CV2 2DX [EMAIL PROTECTED] Web: www.uhcw.nhs.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
