fa > -----Original Message----- > From: Simon Horwith [mailto:[EMAIL PROTECTED] > Sent: 13 June 2003 14:24 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Extracting values from a returned query > > > actually, to be clear, recordsets are just that - recordsets. > Arry and structure functions are not able to manipulate > them. That said, you can use structure and array notation AS > IF they are a structure of arrays, as Stephen said. > > ~Simon > > Simon Horwith > CTO, Etrilogy Ltd. > Member of Team Macromedia > Macromedia Certified Instructor > Certified Advanced ColdFusion MX Developer > Certified Flash MX Developer > CFDJList - List Administrator > http://www.how2cf.com/ > > > -----Original Message----- > From: Steve Martin [mailto:[EMAIL PROTECTED] > Sent: 13 June 2003 14:20 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Extracting values from a returned query > > > Are they _actually_ arrays of structs in MX? I know they were > conceptually and that array like notation can be used to > reference recordsets, but with CF5 and below this was purely > a convenient way of accessing records out of turn and that > they weren't really arrays. > > Steve > > > > -----Original Message----- > > From: Stephen Moretti [mailto:[EMAIL PROTECTED] > > Sent: 13 June 2003 14:19 > > To: [EMAIL PROTECTED] > > Subject: Re: [ cf-dev ] Extracting values from a returned query > > > > > > 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] > > > -- > ** 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]
