----- Original Message -----
From: "Marsh, Jeffrey B" <[EMAIL PROTECTED]>
> If the data rarely changes and you are using the recordset basically as a
> lookup, go ahead and put into an application variable. Be sure to build in
a
> mechanism to refresh the application variables either manually or
> automatically. If the data does change, you want to be able refresh your
> application variables.
>
You might think that the application timeout value set in the administrator
is good enough, but you will most likely find yourself in a situation where
you need to update an application-scoped query now, now now!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
