The trick to access arrays in query objects is to reference the structure part in structure format.
CF says "no" if you ask if this is an array: IsArray(QueryName['ColumnName']) but will happily tell you how long that array is. ArrayLen(QueryName['ColumnName']) All the other array functions also work well with that syntax in 4.5 through MX (all the ones I've tested that is) > 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...) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
