just want to mention that this is one of those classic situations where you really should be more concerned with "should I" as opposed to "can I". It is interesting behavior to be aware of, but I'd strongly advise against actually coding like this in an application.
~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 13 June 2003 14:57 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Extracting values from a returned query 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] -- ** 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]
