Hello,
I've got a query that returns two columns: Heading and Value. The Heading column contains a heading to be printed in the report (eg Consultant) and the value column contains the name of the consultant (eg Dr Smith). Each query returned contains several rows (each with headings and values), but the returned order is not the order I wish to display them on screen. Is there an easy way to search through the query to find the heading, for example, "Report_Title", and then output the value. I'm trying to do it without using lots of <CFQUERY> tags. Can I get my query into a structure / array? Would this help? Thanks. Karl 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>
