<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:clearspace="http://www.jivesoftware.com/xmlns/jive/rss" version="2.0">
  <channel>
    <title>Adobe Community : All Content - All Communities</title>
    <link>https://forums.adobe.com/</link>
    <description>All Content in Adobe Community</description>
    <language>en</language>
    <pubDate>Mon, 28 Jul 2014 22:23:24 GMT</pubDate>
    <generator>Jive Engage 7.0.0.1  (http://jivesoftware.com/products/)</generator>
    <dc:date>2014-07-28T22:23:24Z</dc:date>
    <dc:language>en</dc:language>
    <item>
      <title>Problem with Application Scope</title>
      <link>https://forums.adobe.com/thread/1533888</link>
      <description>&lt;!-- [DocumentBodyStart:72befd24-9526-407e-841a-00e1862ce66a] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p style="color: #222222; font-family: arial, sans-serif;"&gt;We use&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt; dynamic text on our websites.&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The dynamic text available in different languages is stored in structures in the Application scope.&amp;nbsp; Each resource bundle has its own variable to store its variables.&amp;nbsp; They can be called using the following format: &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;#Application.StructName[Session.&lt;strong&gt;locale&lt;/strong&gt;].Variable#&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The first part is the name of the structure variable. With brackets, the variable for the locale is passed in, specifying which part of the structure to use. The last part is the specific variable within the resource bundle to use. &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;If we add new variables in the Application Scope will not be immediately seen.&amp;nbsp; &lt;br/&gt; &lt;br/&gt;The application scope can easily be refreshed by calling any page in the website and adding &amp;#8220;refresh&amp;rdquo; as a variable in the URL.&amp;nbsp; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;This is the Application.cfc function to refresh the application scope:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cffunction name="onRequestStart"&amp;gt; &lt;br/&gt;&amp;lt;cfargument name="requestname" required=true /&amp;gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;!--- restart application scope ---&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfif structKeyExists(url,"refresh")&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfset applicationStop()&amp;gt;&amp;nbsp;&amp;nbsp; &lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfif&amp;gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br/&gt;&amp;lt;/cffunction&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;We have a problem on one of our site. &lt;/p&gt;&lt;p&gt;When we call any page with 'refresh' url the site goes down, it says 'Locale is undefined in Session...', ONLY for one of our sites. It does not happen with other sites.&lt;/p&gt;&lt;p style="color: #222222; font-family: arial, sans-serif;"&gt;&lt;span style="font-family: arial, sans-serif;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="color: #222222; font-family: arial, sans-serif;"&gt;&lt;span style="font-family: arial, sans-serif;"&gt;That is driving us crazy.&lt;/span&gt;&lt;/p&gt;&lt;p style="color: #222222; font-family: arial, sans-serif;"&gt;&lt;span style="font-family: arial, sans-serif;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #222222; font-family: arial, sans-serif;"&gt;Is there some cold fusion specialist that can sense in which direction to move to try to resolve the problem?&lt;/span&gt;&lt;/p&gt;&lt;p style="color: #222222; font-family: arial, sans-serif;"&gt;&lt;span style="font-family: arial, sans-serif;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="color: #222222; font-family: arial, sans-serif;"&gt;&lt;span style="font-family: arial, sans-serif;"&gt;Thank you for your help.&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-family: arial, sans-serif;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:72befd24-9526-407e-841a-00e1862ce66a] --&gt;&lt;img src='/beacon?t=1415919113763' /&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">application</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">session</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=1">scope</category>
      <pubDate>Mon, 28 Jul 2014 22:23:24 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1533888</guid>
      <dc:date>2014-07-28T22:23:24Z</dc:date>
      <clearspace:dateToText>3 months 4 days ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Help with a Index on sql server</title>
      <link>https://forums.adobe.com/thread/916586</link>
      <description>&lt;!-- [DocumentBodyStart:02e51a51-fb97-408d-b8fc-a5e60541784f] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a table named AVAILABILITY&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;ID - IDHOTEL - IDROOM - DATE_FROM - DATE_TO&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;for each room a hotel insert a period (from - to) when the room in booked&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Considering this query&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;select id, date_from, date_to from AVAILABILITY &lt;/p&gt;&lt;p&gt;where IDHOTEL = #idhotel# &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; and IDROOM = #idroom# &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; and DATE_TO &amp;gt;= #dateadd("d",-1,now())# &lt;/p&gt;&lt;p&gt;order by DATE_FROM&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Could you suggest me a index to create on the table ?&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:02e51a51-fb97-408d-b8fc-a5e60541784f] --&gt;</description>
      <pubDate>Sat, 22 Oct 2011 14:26:04 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/916586</guid>
      <dc:date>2011-10-22T14:26:04Z</dc:date>
      <clearspace:dateToText>3 years 3 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>5</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Same Application Variables name in different websites on the same server.</title>
      <link>https://forums.adobe.com/thread/893634</link>
      <description>&lt;!-- [DocumentBodyStart:ee19f45d-4319-4419-8dcb-cff7745cee59] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I have two websites in the same server that use both their own Application.&lt;strong&gt;cfm&lt;/strong&gt; file.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;In each Application.cfm file is defined the application variable &lt;span&gt;Application.DB&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;In website1 the Application.DB = DB1&lt;/p&gt;&lt;p&gt;In website2 the Application.DB = DB2&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Since I'm studying Application.&lt;strong&gt;CFC &lt;/strong&gt;solution, and I did read that application variables with same name have as scope the entire server ... I'm a bit worried. This happen also with Application.&lt;strong&gt;CFM&lt;/strong&gt; ?&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:ee19f45d-4319-4419-8dcb-cff7745cee59] --&gt;</description>
      <pubDate>Sun, 21 Aug 2011 15:23:20 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/893634</guid>
      <dc:date>2011-08-21T15:23:20Z</dc:date>
      <clearspace:dateToText>3 years 3 months ago</clearspace:dateToText>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
  </channel>
</rss>

