> -----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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207615 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
