@Dave, Andy: Thank you very much for the reply! Andy, thanks for the reminder on localizing the query variable. I read-up on it and found more details on http://www.daemon.com.au/go/services/training/tips-andamp-tricks/using-varia bles-in-coldfusion-mx-functions
Localizing the query var actually addressed some minor issues I was having earlier. Cool! > > Okay... > > Dave's right then. The code contained within those included functions only > runs when the function is called. That said, you need to make sure you var > scope the queries inside each function or you could have memory issues on > the page. > > <cfset var myQuery = ''> > <cfquery name="myQuery " ...> > SELECT id > FROM myTable > </cfquery> > > That prevents that query from living on in memory after the function > returns > it. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
