This is what Isaac was talking about. on CFMX 7 arraySum(queryname.coluname) doesn't work. But arraySum(queryname['columnName']) does. The trick is getting a reference to the array to return from the call.
-Mark -----Original Message----- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 24, 2005 7:56 PM To: CF-Talk Subject: RE: Structures vs. "Real Structures" > -----Original Message----- > From: Rebecca Wells [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 24, 2005 6:58 PM > To: CF-Talk > Subject: RE: Structures vs. "Real Structures" > > So, if you can't just use the structname[structKey] kind of reference for > a query then how can you reference reference a query value using this > model, if at all? You can use either dot or indexed notation to access the query, just not structure functions to work with it. For example you CAN do queryname.columnname - this is exactly like doing structure.keyname. You can also do queryname["columnname"]. However you can't do StructClear(queryname). But as I said you can use most array functions on query columns (generally those that don't affect the order or the number of items in the array). Want a total of a column of numbers? Don't loop! Use ArraySum(queryname.columname). It's pretty powerful stuff when you know the limitations. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:207753 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
