[cfaussie] Re: Query Structure

2007-07-12 Thread Barry Beattie
the thing to keep in mind is that a query is a struct of arrays where the struct keys are the columns and the rows are the arrays query.structKey[array] --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" gro

[cfaussie] Re: Query Structure

2007-07-11 Thread Steve Onnis
should have shook it a bit more:) _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of KNOTT, Brian Sent: Thursday, 12 July 2007 3:58 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Query Structure See I know that I would just not come out of my head

[cfaussie] Re: Query Structure

2007-07-11 Thread KNOTT, Brian
See I know that I would just not come out of my head. From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Blair McKenzie Sent: Thursday, 12 July 2007 3:56 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Query Structure results.field

[cfaussie] Re: Query Structure

2007-07-11 Thread phaddon
On Thu, Jul 12, 2007 at 03:52:54PM +1000, KNOTT, Brian wrote: > I'm having a slow mind afternoon > > How do I look at a particular record in a query using structure > notation. E.g. results[5].field queryName.fieldName[recordNo] Paul Haddon Technical Services Manager Formstar Print Technolog

[cfaussie] Re: Query Structure

2007-07-11 Thread Blair McKenzie
results.field[5] Blair On 7/12/07, KNOTT, Brian <[EMAIL PROTECTED]> wrote: > > I'm having a slow mind afternoon > > How do I look at a particular record in a query using structure notation. > E.g. results[5].field > > > Brian Knott > MIS Specialist > Pricing and MIS CFO Banking > Level 8 Suncorp

[cfaussie] Re: Query Structure

2007-07-11 Thread Andrew Scott
Brian, Off the top of my head, it isn't dot notation, but this Results[column][row] If I recall correctly. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. HYPERLINK "http://www.aegeon.com.au"www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From: cfaussie