> 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
