Oops... You CAN do an arrayswap however! Paul
> -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 13 June 2003 14:38 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Extracting values from a returned query > > > but unsurprisingly, arrayappend(foo["col1"], "biscuits") does > work, yielding the following error: > > The method cannot be applied to a query column. > Query columns do not support methods that would alter the > structure of a query column; you must use an analogous method > on the query. > > > -----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] > -- ** 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]
