Hi folks,
I want to store a query results in an APPLICATION
variable. So, it will be available for all users with
making the call through ODBC every time.
for examble:
the query may be for Countries like:
<cfquery datasource="DS" name="GetCountries">
SELECT * FROM Countries
</cfquery>
then, I will use it with a loop to make HTML drop-down
menu with <SELECT>
Is there a way to do that ? please tell me if it is
important to use <CFLOCK> with the previous code.
Thanks
Hamid Hossain
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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