[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

[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.auwww.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 From:

[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 Centre 36

[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 Technologies

[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 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