I don't think that this is possible by number alone. Columns are akin to keys in a structure. Rows are like an array.
You could possibly loop over the column list and try to access your columns that way. But beware that the column list will not be returned in the same order that you specified in your cfquery call and they will be returned in all uppercase. Jeff -------- Original Message -------- > From: "Steve Milburn" <[EMAIL PROTECTED]> > Sent: Wednesday, November 02, 2005 11:59 AM > To: CF-Talk <[email protected]> > Subject: Query column index number > > Hi folks. > > > > How can I refer to a column in my query by it's position in the query, or an > index number, rather than the name of the column? For example > > > > <cfquery name="qry" datasource="test"> > > #qry.column[1]# > > </cfquery> > > > > Or something similar to this. > > > > Thanks in advance. > > > > > --- > --- > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222944 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
