Thanks Jim...was hoping there was a short hand way to grab an entire column as an array.
Stace -----Original Message----- From: Jim Davis [mailto:jim@;depressedpress.com] Sent: Thursday, November 14, 2002 12:43 AM To: CF-Talk Subject: RE: Query Column as an Array > My brain seems to have shut down on me here...isn't there a > way to reference a query column as an array? Although CF seems to treat each column as an array you can't reference one as an array directly (as in ArrayLen(Query.Colname) ). (At least this was the case - I haven't actually checked MX yet...) However you can access the data using array notation in two styles: 1) MyQuery.MyColumn[Row] This is a mixture of Array and dot notation. Where "Row" is an integer representing the row that you want. 2) MyQuery["MyColumn"][Row] This is "full" array notation. "MyColumn" is a string representing a column name and "Row" is the same as above. In both cases the values in brackets can be variables. The difference is that with a true Array using method two you would only need a number for both values. With a query it must a string however. Hope this helps, Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
