Daniel, I am using the evaluate command to determine which query to pull data from. The reason for this is there are multiple queries for different cities and I would like to cache the query. The sites for the different cities pull the data from the query based upon the city name in the application page. For example, we have a site for Austin, which uses query "austin_get_query" and a site for Dallas which uses "dallas_get_query". In the application page for each city I have a variable for cityName, therefore, I am using #evaluate(cityName & '_get_query')#. Do you recommend another way?
Thanks for the advise! Kevin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Daniel Elmore Sent: Friday, December 17, 2004 5:01 PM To: [EMAIL PROTECTED] Subject: RE: evaluate The evaluate function is processor intensive. You should avoid it whenever possible. However, in some situation it is necessary and then you should use it and not feel guilty. It takes a good understanding of CF syntax to know when it is necessary. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Fricke Sent: Friday, December 17, 2004 3:28 PM To: CFLIST Subject: evaluate Is there any reason to avoid using the evaluate command? Does it slow down processing? Thanks, kevin ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
