ooh, but <cfoutput>#arraysum(foo["col1"])#</cfoutput>
works, which is a nice shortcut for me, as I used to have to use arraysum(listtoarray(valuelist(query.column))) nothing earthshattering, but its just made me happy to discover. /me goes and gets a life. > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 13 June 2003 14:35 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Extracting values from a returned query > > > well, the following works: > > <cfoutput>#arraylen(foo["col1"])#</cfoutput> > > where foo is a query. > > so does > > arraytolist(foo["col1"]) > > > -----Original Message----- > > From: Stephen Moretti [mailto:[EMAIL PROTECTED] > > Sent: 13 June 2003 14:39 > > To: [EMAIL PROTECTED] > > Subject: Re: [ cf-dev ] Extracting values from a returned query > > > > > > > > > > <cfif IsArray(data[listfirst(data.columnlist)])> > > > <cfoutput> > > > data[#listfirst(data.columnlist)#] is array<br> > > > </cfoutput> > > > </cfif> > > > > > > In CFMX tells you that "data" is a query and NOT a > > structure and that > > > data[columname] is an array. > > > > > > > So go on then... Next step... try the array functions on > > data[columnname]... ;o) > > > > I'm not saying it won't work, cos to be honest I don't know > > the answer, I > > just want you to do the work for me... ;oD > > > > > > > > -- > > ** 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]
