Use bracket notation: <cfset col = 1> <cfoutput>#foo[col][1]#</cfoutput>
======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Brian Fox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 18, 2002 10:31 AM > To: CF-Talk > Subject: Using array syntax with a query > > > Hi - > > I could really use some help getting at a query result in > round about ways. > > Someone suggested to me that I could use array syntax to do > this. Something > along the line of: > <cfquery name="foo" ...></cfquery> > <cfoutput query="foo"> > #foo[1]# > </cfoutput> > > This doesn't work (just an example of what I'm hoping CF > supports if the > syntax is right). Is there any way to this? That is, > address the data in > foo without using any of the contents of columnlist? > > What's causing the problem is a DB2 stored procedure that is returning > numbers for the column names. i.e. the column list is 1,2,3,4. The > variable foo.1 is illegal in ColdFusion. It appears I can invoke the > procedure just fine, I just can't get at any of the returned data! > > Thanks, > Brian > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
