Hi.
Being new to Cold Fusion, I have a few questions. I'll only pose one of them
now. It has to do with application level variables.
The situation is this: I have some tables in my database which contain lists
of legal values for some selection lists which appear on different forms in
my application. Since these are read-only tables while the system is up, I
thought they'd make good candidates for application level stuff.
So I created an application.cfm file and placed it in the same directory as
all my other .cfm files. In it I did a bunch of named <CFQUERY>s to retrieve
the legal values as part of application initialization.
Then in my regular .cfm templates I refered to something like
#Application.query_name.column_name# (where Application is literal). I got
an error message when the referring template was launched telling me that it
didn't know about my applications variable.
My question is: Am I doing this right? Is this the way to define and then
use application level variables? Is it true that these queries will be
executed only once in the application or will they be executed whenever any
template is launched (when the automatic inclusion of Application.cfm
occurs)? Do I need some <CFIF> in the Application.cfm template to make sure
they are executed only once? If so, what should the condition be? etc. etc.
etc.
Any help, advise, enlightenment will be grateful7y appreciated.
-- Tim Dempsey
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
