Karl, Don't forget that query recordsets are structures of arrays.
A struct for each column and an array in each column struct for the rows returned. You can reference a query like this myQuery["mycolumnname"][rownumber] regards Stephen ----- Original Message ----- From: "Osullivan Karl (RKB) Senior Analyst/Programmer" <[EMAIL PROTECTED]> To: "CF - Development Group" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 12:24 PM Subject: [ cf-dev ] Extracting values from a returned query > > > > 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> > > > > > > -- ** 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]
