Ummmm..... Well... isQuery would stop working and isStruct would get confused, so I'm assuming that its still a conceptual thing and not reality, so the struct and array function don't work on a query.
----- Original Message ----- From: "Steve Martin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 2:19 PM 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]
