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

Reply via email to