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.
-----Original Message-----
From: Mike Francisco [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 16, 2008 2:06 PM
To: CF-Talk
Subject: RE: Are cfqueries on a UDF effecient?
>
> Let me double check. Are each of those queries being run each time the
> page loads, or only when the function in which they live is called?
>
Andy, that is what I am trying to find out. Not all of the functions that
contains a query is being called. So I am not really sure how the server
treats the cfqueries before it loads the page.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:303593
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
