And what about recordset being accessed like an array: ArrayToList(query['column']) ?
Fabio Terracini Synex Technologies Co. Consultant Fone/Fax: +55 (11) 3071-3363 [EMAIL PROTECTED] www.synex.com.br Rebecca Wells wrote: >>*snip*treat query columns as arrays... I know we can >>listtoarray(valuelist(query.column)), except that's more work for the >>machine _and_ it removes duplicates... with CF5 using query["column"] >>worked but with cfmx you have to use query["column"].toArray() -- >>which obviously doesn't work on CF5, so that leaves us with no good >>single solution on both versions. I actually went to the extent of >>creating a QueryColumnToArray() function to handle the variation... >> >> > >Which reminds me... I recently had a debate with someone regarding whether a >query recordset is a structure in the same sense as the Struct functions work. >The other person said that the Struct is indexed and will always be more >efficient, whereas the recordset is not. I thought that a recordset IS a >structure. Is there really a difference between these 2 types of structures? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:205271 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

