<?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 : Discussion List - Advanced Techniques</title>
    <link>https://forums.adobe.com/community/coldfusion/coldfusion_advanced?view=discussions</link>
    <description>Latest Forum Threads in Advanced Techniques</description>
    <language>en</language>
    <pubDate>Tue, 08 Apr 2014 14:08:12 GMT</pubDate>
    <generator>Jive Engage 7.0.0.1  (http://jivesoftware.com/products/)</generator>
    <dc:date>2014-04-08T14:08:12Z</dc:date>
    <dc:language>en</dc:language>
    <item>
      <title>cfprint and UPS labels</title>
      <link>https://forums.adobe.com/thread/1630058</link>
      <description>&lt;!-- [DocumentBodyStart:f2332e78-56e1-402c-993b-9419cf077b15] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I am trying to use CFPRINT to print UPS labels to a network printer. The starting labels (png files) are great and I can print them locally to the zebra printer and they work wonderfully. The barcodes produced by CFPRINT however are of such poor quality that the barcode scanner cannot read them.&amp;nbsp; My research shows that jpedal resizes the images to 72 dpi which is just not crisp enough for a scanner.&amp;nbsp; I read about using a jpedal setting:&amp;nbsp; org.jpedal.upscale=2 but I have no clue as to where you would utilize this.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Any suggestions using on how to fix this using Coldfusion.&amp;nbsp; Any suggestions using php or asp.net (other technologies we support internally)??&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:f2332e78-56e1-402c-993b-9419cf077b15] --&gt;&lt;img src='/beacon?t=1415919104274' /&gt;</description>
      <pubDate>Sat, 08 Nov 2014 14:21:34 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1630058</guid>
      <dc:date>2014-11-08T14:21:34Z</dc:date>
      <clearspace:dateToText>5 days 9 hours ago</clearspace:dateToText>
      <clearspace:messageCount>1</clearspace:messageCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>AJAX-Powered Related Select Boxes -</title>
      <link>https://forums.adobe.com/thread/1614478</link>
      <description>&lt;!-- [DocumentBodyStart:fe49632b-8955-4033-bdfa-6b535cbc9801] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi folks...I'm being driven crazy by this seemingly simple task.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I have 4 selectboxes, each AJAX-driven, grabbing items from a database, and then populating the next box in turn.&amp;nbsp; Once a submit button is clicked next to the set of dropdowns, the information in the boxes are sent to a processing script where session variables are set and returned.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;They all preload by default. They all properly load the next dropdown as you'd expect.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The problem is, I've found that if none of the boxes are touched and the default values are left, an error occurs when the submit button is clicked, and after dismissing the error popup, the 4th box becomes empty.&amp;nbsp; This only happens if the 4th (last) dropdown is left to its default value.&amp;nbsp; Once any other value other&amp;nbsp; than the default one is selected, everything works as expected.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The error:&lt;/p&gt;&lt;p&gt;Bind failed for select box Transact, value and/or display attributes must be specified on the cfselect tag when binding to a query.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The form:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;tr&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;td align="left"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfif isDefined("form.submit")&amp;gt;&amp;lt;cfselect name="Location"&amp;nbsp; display="Location" bind="cfc:webapps.checklist.cfc.queries.getLocations()" bindonload="true" selected="#form.Location#" /&amp;gt;&amp;lt;cfelse&amp;gt;&amp;lt;cfselect name="Location"&amp;nbsp; display="Location" bind="cfc:webapps.checklist.cfc.queries.getLocations()" bindonload="true" /&amp;gt;&amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/tr&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;tr&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;td align="left"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfif isDefined("session.itemapplication") AND session.itemapplication NEQ ""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfselect name="Application" selected="#session.itemapplication#"&amp;nbsp; display="Applicat" bind="cfc:webapps.checklist.cfc.queries.getApplications({Location})" bindonload="false" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfelse&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfselect name="Application" selected="#form.Application#"&amp;nbsp; display="Applicat" bind="cfc:webapps.checklist.cfc.queries.getApplications({Location})" bindonload="false" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/tr&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;tr&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;td align="left"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfif isDefined("session.itemcategory") AND session.itemcategory NEQ ""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfselect name="Category" selected="#session.itemcategory#"&amp;nbsp; display="Category" bind="cfc:webapps.checklist.cfc.queries.getCategories({Application})" bindonload="false" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfelse&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfselect name="Category" selected="#form.Category#"&amp;nbsp; display="Category" bind="cfc:webapps.checklist.cfc.queries.getCategories({Application})" bindonload="false" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/tr&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;tr&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;td align="left"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfif isDefined("session.transaction") AND session.transaction NEQ ""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfselect name="Transact"&amp;nbsp; required="yes" size="1" message="Please select a transaction before continuing." selected="#session.transaction#" value="Transact" display="Transact" bind="cfc:webapps.checklist.cfc.queries.getTransactions({Category})" bindonload="false" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfelse&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfselect name="Transact" required="yes" size="1" message="Please select a transaction before continuing." value="Transact" display="Transact"&amp;nbsp; selected="#form.Transact#" bind="cfc:webapps.checklist.cfc.queries.getTransactions({Category})" bindonload="false" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;td&amp;gt;&amp;lt;cfinput type="submit" name="submit" value="Show Items"&amp;gt;&amp;lt;/td&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/tr&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;a href="https://forums.adobe.com/servlet/JiveServlet/showImage/2-6855415-687160/Untitled-1.jpg"&gt;&lt;img alt="Untitled-1.jpg" class="jive-image image-1" height="156" src="https://forums.adobe.com/servlet/JiveServlet/downloadImage/2-6855415-687160/Untitled-1.jpg" style="height: 137px; width: 620px;" width="707"/&gt;&lt;/a&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;a href="https://forums.adobe.com/servlet/JiveServlet/showImage/2-6855415-687161/2.jpg"&gt;&lt;img alt="2.jpg" class="jive-image image-2" height="317" src="https://forums.adobe.com/servlet/JiveServlet/downloadImage/2-6855415-687161/2.jpg" style="height: 280px; width: 620px;" width="701"/&gt;&lt;/a&gt;&lt;/p&gt;&lt;p&gt;It seems like for whatever reason, the script has a problem with the default value loaded for that last box.&amp;nbsp; I've checked the database, nothing strange about the values loaded by default at all.&amp;nbsp; Any ideas guys??&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks in advance!&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;T&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:fe49632b-8955-4033-bdfa-6b535cbc9801] --&gt;</description>
      <pubDate>Wed, 22 Oct 2014 13:53:42 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1614478</guid>
      <dc:date>2014-10-22T13:53:42Z</dc:date>
      <clearspace:dateToText>1 week 5 days ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>How to handle Coldfusion SOAP Web Service Errors</title>
      <link>https://forums.adobe.com/thread/1611554</link>
      <description>&lt;!-- [DocumentBodyStart:747c2b84-6155-49e6-9141-8d68861f7b3f] --&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 just created simple wsdl example:&lt;/p&gt;&lt;p&gt;My Component:&lt;/p&gt;&lt;p&gt;&amp;lt;cfcomponent displayname="mytest"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cffunction name="service_login_authentication" access="remote" output="true" returntype="any" hint="Returns login"&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfargument name="login" type="string" required="yes"&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfargument name="password" type="string" required="yes"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfif #arguments.login# eq "abcdef" and #arguments.password# eq "123456"&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfxml variable="soapRes"&amp;gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&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;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;kps_response&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;message&amp;gt;OK&amp;lt;/message&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;token&amp;gt;354dfdffsdf&amp;lt;/token&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/kps_response&amp;gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfxml&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfelse&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfthrow type="MyException" message="INVALID LOGIN" errorcode="1000" /&amp;gt;&lt;br/&gt;&amp;nbsp;&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; &lt;br/&gt;&amp;nbsp; &lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfreturn soapRes &amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cffunction&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br/&gt;&amp;lt;/cfcomponent&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Its generating wsdl and no problem with response but when generating any error like username and password does not match then it's generating fault code like this:&lt;/p&gt;&lt;p&gt;&lt;span&gt;&amp;lt;soapenv:Envelope xmlns:soapenv="&lt;/span&gt;&lt;a class="jive-link-external-small" href="http://schemas.xmlsoap.org/soap/envelope/" rel="nofollow"&gt;http://schemas.xmlsoap.org/soap/envelope/&lt;/a&gt;&lt;span&gt;" xmlns:xsd="&lt;/span&gt;&lt;a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema" rel="nofollow"&gt;http://www.w3.org/2001/XMLSchema&lt;/a&gt;&lt;span&gt;" xmlns:xsi="&lt;/span&gt;&lt;a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow"&gt;http://www.w3.org/2001/XMLSchema-instance&lt;/a&gt;&lt;span&gt;"&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;soapenv:Body&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;soapenv:Fault&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;faultcode&amp;gt;soapenv:Server.userException&amp;lt;/faultcode&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;faultstring&amp;gt;coldfusion.xml.rpc.CFCInvocationException: [coldfusion.runtime.CustomException : INVALID LOGIN. ]&amp;lt;/faultstring&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;detail&amp;gt;&lt;/p&gt;&lt;p&gt;&lt;span&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;ns1:hostname xmlns:ns1="&lt;/span&gt;&lt;a class="jive-link-external-small" href="http://xml.apache.org/axis/" rel="nofollow"&gt;http://xml.apache.org/axis/&lt;/a&gt;&lt;span&gt;"&amp;gt;HOST_NAME&amp;lt;/ns1:hostname&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/detail&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/soapenv:Fault&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;/soapenv:Body&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/soapenv:Envelope&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;But I want customize Fault Code like this:&lt;/p&gt;&lt;p&gt;&lt;span&gt;&amp;lt;soapenv:Envelope xmlns:soapenv="&lt;/span&gt;&lt;a class="jive-link-external-small" href="http://schemas.xmlsoap.org/soap/envelope/" rel="nofollow"&gt;http://schemas.xmlsoap.org/soap/envelope/&lt;/a&gt;&lt;span&gt;" xmlns:xsd="&lt;/span&gt;&lt;a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema" rel="nofollow"&gt;http://www.w3.org/2001/XMLSchema&lt;/a&gt;&lt;span&gt;" xmlns:xsi="&lt;/span&gt;&lt;a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow"&gt;http://www.w3.org/2001/XMLSchema-instance&lt;/a&gt;&lt;span&gt;"&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;soapenv:Body&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;soapenv:Fault&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;faultcode&amp;gt;1000&amp;lt;/faultcode&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;faultstring&amp;gt;INVALID LOGIN&amp;lt;/faultstring&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/soapenv:Fault&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;/soapenv:Body&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/soapenv:Envelope&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Fault Code and Fault String should be customize and I don't want detail tag completely. In old ColdFusion version like ColdFusion 8 displaying detail tag with &lt;span class="pun"&gt;&amp;lt;&lt;/span&gt;&lt;span class="pln"&gt;ns1&lt;/span&gt;&lt;span class="pun"&gt;:&lt;/span&gt;&lt;span class="pln"&gt;stackTrace xmlns&lt;/span&gt;&lt;span class="pun"&gt;:&lt;/span&gt;&lt;span class="pln"&gt;ns1&lt;/span&gt;&lt;span class="pun"&gt;=&lt;/span&gt;&lt;span class="str"&gt;&lt;span&gt;"&lt;/span&gt;&lt;a class="jive-link-external-small" href="http://xml.apache.org/axis/" rel="nofollow"&gt;http://xml.apache.org/axis/&lt;/a&gt;&lt;span&gt;"&lt;/span&gt;&lt;/span&gt;&lt;span class="pun"&gt;&amp;gt;&lt;/span&gt;&lt;span class="pln"&gt; coldfusion&lt;/span&gt;&lt;span class="pun"&gt;.&lt;/span&gt;&lt;span class="pln"&gt;xml&lt;/span&gt;&lt;span class="pun"&gt;.&lt;/span&gt;&lt;span class="pln"&gt;rpc&lt;/span&gt;&lt;span class="pun"&gt;.&lt;/span&gt;&lt;span class="typ"&gt;CFCInvocationException&lt;/span&gt;&lt;span class="pun"&gt;:&lt;/span&gt;&lt;span class="pln"&gt; and so on.&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span class="pln"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;Any suggestions on how to create customize faultcode and faultstring is very helpful.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks!!&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span class="pln"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:747c2b84-6155-49e6-9141-8d68861f7b3f] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">coldfusion webservice</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">soap exception handling</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">customize fault code and fault string</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">soap exception handlingcoldfusion webservice</category>
      <pubDate>Sun, 19 Oct 2014 10:39:49 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1611554</guid>
      <dc:date>2014-10-19T10:39:49Z</dc:date>
      <clearspace:dateToText>3 weeks 2 days ago</clearspace:dateToText>
      <clearspace:messageCount>15</clearspace:messageCount>
      <clearspace:replyCount>14</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Cfspreadsheet</title>
      <link>https://forums.adobe.com/thread/1611395</link>
      <description>&lt;!-- [DocumentBodyStart:9f01dc08-89ba-4dc2-a83f-e0187beba732] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi, I have a question regarding cfspreadsheet....So I'm using cfspreadshseet to create excel spreadsheets for reporting purposes. My page allows a user to select whatever columns from the database to include in the report. So here is an example:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The spreadsheet could look like this:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;First Name-------------Last Name-------------Organization-------------Address-------------City-------------State----- --------Zip-------------Concern&lt;/p&gt;&lt;p&gt;Joe&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Smith&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Sample&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 12 main&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; denver&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; co&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 80513&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; concerns go here&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;My question is this, if Joe has more than 1 concern I get multiple rows with joe's info...is there a way I can loop the concerns and only have 1 row for joe?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Steve&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:9f01dc08-89ba-4dc2-a83f-e0187beba732] --&gt;</description>
      <pubDate>Sun, 19 Oct 2014 01:18:26 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1611395</guid>
      <dc:date>2014-10-19T01:18:26Z</dc:date>
      <clearspace:dateToText>3 weeks 5 days ago</clearspace:dateToText>
      <clearspace:messageCount>1</clearspace:messageCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Why is cfajax.js not *initially* loading in mobile platform/version?</title>
      <link>https://forums.adobe.com/thread/1597138</link>
      <description>&lt;!-- [DocumentBodyStart:8d677f25-43c0-4d75-aa51-0907e2fdba16] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;&lt;span style="color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;I am on a team developing and supporting a CF10 web application that is used on both desktop and mobile (iPad) platforms.&amp;nbsp; I have a form with 2 CFSELECTs which are bound to CFCs.&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;There are views for both the desktop and mobile version.&amp;nbsp; They are virtually identical *except* for the mobile form fields are in &amp;lt;div&amp;gt; tags instead of an HTML table.&amp;nbsp; They both use the same CFSELECT code:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="background-color: #fafafa;"&gt;&lt;code&gt;&lt;/code&gt;&lt;div&gt;&lt;code&gt;&lt;code&gt;&lt;span style="color: #000088;"&gt;&amp;lt;cfoutput&amp;gt;&lt;/span&gt;&lt;span style="color: #000000;"&gt;&lt;br/&gt; &lt;/span&gt;&lt;span style="color: #000088;"&gt;&amp;lt;cfselect&lt;/span&gt;&lt;span style="color: #000000;"&gt; &lt;/span&gt;&lt;span style="color: #660066;"&gt;name&lt;/span&gt;&lt;span style="color: #666600;"&gt;=&lt;/span&gt;&lt;span style="color: #008800;"&gt;"region"&lt;/span&gt;&lt;span style="color: #000000;"&gt; &lt;/span&gt;&lt;span style="color: #660066;"&gt;selected&lt;/span&gt;&lt;span style="color: #666600;"&gt;=&lt;/span&gt;&lt;span style="color: #008800;"&gt;"#rc.region#"&lt;/span&gt;&lt;span style="color: #000000;"&gt; &lt;/span&gt;&lt;span style="color: #660066;"&gt;bind&lt;/span&gt;&lt;span style="color: #666600;"&gt;=&lt;/span&gt;&lt;span style="color: #008800;"&gt;"cfc:applications.theApp.model.services.myApp.getRegions('#rc.DSN#',{district})"&lt;/span&gt;&lt;span style="color: #000000;"&gt; &lt;/span&gt;&lt;span style="color: #660066;"&gt;bindOnLoad&lt;/span&gt;&lt;span style="color: #666600;"&gt;=&lt;/span&gt;&lt;span style="color: #008800;"&gt;"true"&lt;/span&gt;&lt;span style="color: #000088;"&gt;&amp;gt;&lt;/span&gt;&lt;span style="color: #000000;"&gt;&lt;br/&gt; &lt;/span&gt;&lt;span style="color: #000088;"&gt;&amp;lt;/cfselect&amp;gt;&lt;/span&gt;&lt;span style="color: #000000;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;span style="color: #000088;"&gt;&amp;lt;/cfoutput&amp;gt;&lt;/span&gt;&lt;/code&gt;&lt;/code&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;/div&gt;&lt;/div&gt;&lt;p style="min-height: 8pt; padding: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;The desktop version works as expected, the region options change based on the 'district' select box option,but the mobile version will not work on initial page load.&amp;nbsp; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;Using Chrome to emulate the mobile version, I noticed in the console that cfajax.js does not load the first time the page is accessed.&amp;nbsp; The CFSELECT form fields shows no options.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;But, if I F5 refresh the page, cfajax.js does load.&amp;nbsp; The CFSELECTs appear to show no options *until* I click on them, and even then they don't quite behave correctly.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;Why doesn't cfajax.js load on the initial page access?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px; color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="color: #222222; font-family: Arial, Helvetica, sans-serif;"&gt;Any help or suggestions would be greatly appreciated!&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:8d677f25-43c0-4d75-aa51-0907e2fdba16] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">mobile</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">cfajax</category>
      <pubDate>Wed, 08 Oct 2014 13:23:50 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1597138</guid>
      <dc:date>2014-10-08T13:23:50Z</dc:date>
      <clearspace:dateToText>1 month 24 hours ago</clearspace:dateToText>
      <clearspace:messageCount>3</clearspace:messageCount>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Issue with .net integration</title>
      <link>https://forums.adobe.com/thread/1596789</link>
      <description>&lt;!-- [DocumentBodyStart:56b93be2-dd6c-4765-94c2-c0d2828da0f6] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;We installed a new CF11 server on a win2008 with iis7. the .Net ver is &lt;span style="color: #444444; font-family: Calibri, sans-serif; font-size: 16px;"&gt;v2.0.50727&lt;/span&gt;&lt;br/&gt;We have this code :&lt;/p&gt;&lt;p&gt;&amp;lt;cfobject&lt;/p&gt;&lt;p&gt;&amp;nbsp; type="dotnet"&lt;/p&gt;&lt;p&gt;&amp;nbsp; class="System.DirectoryServices.DirectoryEntry"&lt;/p&gt;&lt;p&gt;&amp;nbsp; assembly="#dllPath#"&lt;/p&gt;&lt;p&gt;&amp;nbsp; name="site"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;to allow us to contact to the IIS directory to later create a Virtual Directory on it.&lt;br/&gt;On the prev CF9/2008/iis7 /.net &lt;span style="color: #444444; font-family: Calibri, sans-serif; font-size: 16px;"&gt;v2.0.50727 &lt;/span&gt;this worked great.&lt;/p&gt;&lt;p&gt;ON the new server I get this error :&lt;br/&gt;&lt;span style="color: #000000; font-family: verdana, arial, helvetica, sans-serif; font-size: xx-small;"&gt;Ensure that the DotNet agent is running and you have provided the correct host and port information-&lt;span style="color: #000000; font-family: verdana, arial, helvetica, sans-serif; font-size: xx-small;"&gt;DotNet Side does not seem to be running.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;We made several checks to make sure that the .NET integration with CF works - and it does, We used a simple example of a "math dll" from the wed and it worked with out any issue. &lt;br/&gt;But when we try to communicate with the .Net assembly we get the error.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;ANY suggestions will be highly appreciated &lt;span aria-label="Happy" class="emoticon-inline emoticon_happy" style="height:16px;width:16px;"&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks &lt;span aria-label="Happy" class="emoticon-inline emoticon_happy" style="height:16px;width:16px;"&gt;&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:56b93be2-dd6c-4765-94c2-c0d2828da0f6] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">.net</category>
      <pubDate>Wed, 08 Oct 2014 02:59:03 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1596789</guid>
      <dc:date>2014-10-08T02:59:03Z</dc:date>
      <clearspace:dateToText>1 month 6 days ago</clearspace:dateToText>
      <clearspace:messageCount>1</clearspace:messageCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Is it possible to create and then search a collection from within a coldfusion ap?</title>
      <link>https://forums.adobe.com/thread/1592576</link>
      <description>&lt;!-- [DocumentBodyStart:9822948c-79d4-4e21-b223-0e4e4c04c28b] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Is possible to search a database to limit the number of pdf's to search -- then use the output from the search to create a collection index it and then keyword search the new collection all within one coldfusion ap?&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:9822948c-79d4-4e21-b223-0e4e4c04c28b] --&gt;</description>
      <pubDate>Fri, 03 Oct 2014 17:56:54 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1592576</guid>
      <dc:date>2014-10-03T17:56:54Z</dc:date>
      <clearspace:dateToText>1 month 2 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Problem with cfinput autosuggest and cfcomponent</title>
      <link>https://forums.adobe.com/thread/1587774</link>
      <description>&lt;!-- [DocumentBodyStart:a3a727b9-5a51-4532-89b1-01ae1b776f3f] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I am new to using cfcomponent and autosuggest.&amp;nbsp; I followed the sample given in the Adobe Help &lt;a class="jive-link-external-small" href="http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7a01.html#WSc3ff6d0ea77859461172e0811cbec22c24-720c" rel="nofollow"&gt;Adobe ColdFusion 9 * Using Ajax User Interface Components and Features&lt;/a&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;However, I am not getting the autosuggest to work at all.&amp;nbsp; This is what I did:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;1. I created a Suggestcfc.cfc under a subdirectory called "components" &lt;/p&gt;&lt;p&gt;The Suggestcfc.cfc is as follows:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfcomponent output="false"&amp;gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cffunction name="getProduct" access="remote" returntype="array" output="false"&amp;gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfargument name="suggestvalue" required="true"&amp;gt; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfset var myarray = ArrayNew(1)&amp;gt; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfquery datasource="mydatabase"&amp;nbsp; name="getlist"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; SELECT DISTINCT productname FROM products&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; WHERE productname LIKE &amp;lt;cfqueryparam value="#suggestvalue#%" cfsqltype="cf_sql_varchar"&amp;gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfquery&amp;gt; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfloop query="getlist"&amp;gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfset arrayAppend(myarray, productname)&amp;gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfloop&amp;gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfreturn myarray&amp;gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cffunction&amp;gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cffunction name="init" output="false"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfreturn this&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cffunction&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfcomponent&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;2. I have a test.cfm as:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span&gt;&amp;lt;html xmlns="&lt;/span&gt;&lt;a class="jive-link-external-small" href="http://www.w3.org/1999/xhtml" rel="nofollow"&gt;http://www.w3.org/1999/xhtml&lt;/a&gt;&lt;span&gt;"&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;head&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/head&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;body&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfset suggest = createObject("component", "components.Suggestcfc").init()&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfform&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfinput type="text" autosuggest="suggest.getProducts({cfautosuggestvalue})" name="string"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfform&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/body&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/html&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;So when I run the test.cfm it only showed a box and when I started typing, nothing is being suggested (retrieve from the products table).&amp;nbsp; What am I doing wrong here?&amp;nbsp; Any help is appreciated.&amp;nbsp; Thanks in advance.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:a3a727b9-5a51-4532-89b1-01ae1b776f3f] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">autosuggest</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">cfinput</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">cfcomponent</category>
      <pubDate>Mon, 29 Sep 2014 04:37:16 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1587774</guid>
      <dc:date>2014-09-29T04:37:16Z</dc:date>
      <clearspace:dateToText>1 month 2 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>11</clearspace:messageCount>
      <clearspace:replyCount>10</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Problem using HSBCHashGenerator CFX</title>
      <link>https://forums.adobe.com/thread/1589265</link>
      <description>&lt;!-- [DocumentBodyStart:eafe3e10-6858-4180-a819-635507574ec6] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Upgrading from MX7 to 10.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Got a .jar file "cpitools.jar" which I've put into /opt/coldfusion10/jre/lib&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;If I do a jar -tf on it, I get:&lt;/p&gt;&lt;p&gt;com/clearcommerce/CpiTools/security/Encrypter.class&lt;/p&gt;&lt;p&gt;com/clearcommerce/CpiTools/security/HashGenerator.class&lt;/p&gt;&lt;p&gt;com/clearcommerce/CpiTools/security/SecCrypto.class&lt;/p&gt;&lt;p&gt;META-INF/MANIFEST.MF&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I've registered it in the CFIDE:&lt;/p&gt;&lt;p&gt;TagName: &lt;a class="jive-link-external-small" href="http://hzhsep14b.dmclub.net/CFIDE/administrator/extensions/cfx_javaedit.cfm?tagname=CFX%5FHSBCHashGenerator&amp;amp;csrftoken=9B9068358313CE2E26802683F8C9DDD7A68186EF" rel="nofollow"&gt;CFX_HSBCHashGenerator&lt;/a&gt;&lt;/p&gt;&lt;p&gt;ClassName: com.clearcommerce.CpiTools.security.HashGenerator&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;BUT when I try to call it...&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;CFX_HSBCHashGenerator SharedSecret="#ss#" HashElement="#datainput#"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I get the error message: The CFX custom tag CFX_com.clearcommerce.CpiTools.security.HashGenerator was not found in the custom tag database. You must add custom tags to the database before using them. If you have added your tag to the database, check the spelling of the tag within your template to ensure that it matches the database entry.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;-----&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;So when it says "you must add custom tags to the database" - it's referring to the registration of the Java CFX, right?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;So I've done that. so I check the spelling of the tag - looks OK to me (and it is unchanged since the functional MX7 code).&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Obviously the mapping is working to some extent - CF was clever enough to realise that when I say &amp;lt;CFX_HSBCHashGenerator...., I am referring to something with "com.clearcommerce.CpiTools.security.HashGenerator".&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;So what's my blindingly obvious in retrospect error?!&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:eafe3e10-6858-4180-a819-635507574ec6] --&gt;</description>
      <pubDate>Tue, 30 Sep 2014 12:50:23 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1589265</guid>
      <dc:date>2014-09-30T12:50:23Z</dc:date>
      <clearspace:dateToText>1 month 2 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname</title>
      <link>https://forums.adobe.com/thread/1579516</link>
      <description>&lt;!-- [DocumentBodyStart:3fa4cd20-4d96-45e4-8d29-4b4fdceb2200] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I've done this a thousand times.&amp;nbsp; I have a stored proc that returns data.&amp;nbsp; I give the resultset a name.&amp;nbsp; I output it with cfoutput query =queryname.&amp;nbsp; Now it's failing for every column in the query.&amp;nbsp; But if I do a cfdump with the queryname as a var, I get the data -- with the exact column names in my cfoutput.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;CF9, SQL Server.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:3fa4cd20-4d96-45e4-8d29-4b4fdceb2200] --&gt;</description>
      <pubDate>Fri, 19 Sep 2014 19:43:24 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1579516</guid>
      <dc:date>2014-09-19T19:43:24Z</dc:date>
      <clearspace:dateToText>1 month 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Error using CFWebsocket tag in ColdFusion 10</title>
      <link>https://forums.adobe.com/thread/1078356</link>
      <description>&lt;!-- [DocumentBodyStart:9a8d2656-a838-47cc-a6fe-e53c84a6daa0] --&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'm using CF 10 and IIS.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I'm using the cfwebsocket tag in ColdFusion 10 and it works the majority of the time, but in Firefox I'm using Firebug and I get these errors randomly sometimes.&amp;nbsp; I'm not sure why though.&amp;nbsp; I setup a basic page where I enter text into an HTML input field.&amp;nbsp; When you press enter, any subscribed clients should receive the message.&amp;nbsp; 7/10 times or so it works fine, but then sometimes the message won't come through and I will get the below errors in Firebug.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;pre class="objectBox-errorMessage objectBox hasBreakSwitch inline"&gt;&lt;p class="subLogRow focusRow errorTitle"&gt;&lt;span class="errorMessage"&gt;SyntaxError: parseJSON&lt;/span&gt;&lt;/p&gt;&lt;span class=" "&gt;&lt;/span&gt;&lt;/pre&gt;&lt;p class="logRow logRow-errorMessage" style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;pre class="objectBox-errorMessage objectBox hasBreakSwitch inline"&gt;&lt;div class="subLogRow focusRow errorTitle"&gt;&lt;span class="errorDuplication"&gt;&lt;/span&gt;&lt;span class="errorMessage"&gt;The connection to ws://127.0.0.1:8575/cfusion/cfusion was interrupted while the page was loading.&lt;/span&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;span class=" "&gt;&lt;/span&gt;&lt;table cellpadding="0" cellspacing="0" class=" "&gt;&lt;tbody class=" "&gt;&lt;tr class=" "&gt;&lt;td class=" " style=";"&gt;&lt;br/&gt;&lt;/td&gt;&lt;td class=" " style=";"&gt;&lt;a class="errorSource a11yFocus"&gt;&lt;pre class="errorSourceCode" title="this.wsConnection=new WebSocket(_2);"&gt;this.wsConnection=new WebSocket(_2);&lt;/pre&gt;
&lt;/a&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;/pre&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Anyone seen this error message in Firefox? &lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:9a8d2656-a838-47cc-a6fe-e53c84a6daa0] --&gt;</description>
      <pubDate>Mon, 08 Oct 2012 00:57:12 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1078356</guid>
      <dc:date>2012-10-08T00:57:12Z</dc:date>
      <clearspace:dateToText>1 month 4 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>How can you determine from within CF if cookies are enabled in the browser you are using?</title>
      <link>https://forums.adobe.com/thread/1574656</link>
      <description>&lt;!-- [DocumentBodyStart:17387699-5079-4ef3-815e-d27c96efc067] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I need to know if the user has cookies enabled when he logs into my website so I can tell him/her to enable them.&amp;nbsp; If they are not enabled, the SessionID will be lost and session vars will not work.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:17387699-5079-4ef3-815e-d27c96efc067] --&gt;</description>
      <pubDate>Sat, 13 Sep 2014 22:06:09 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1574656</guid>
      <dc:date>2014-09-13T22:06:09Z</dc:date>
      <clearspace:dateToText>1 month 1 month ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>consuming webservice with input type of enum</title>
      <link>https://forums.adobe.com/thread/88154</link>
      <description>&lt;!-- [DocumentBodyStart:3debd338-81fe-4bbb-8a3e-30ae131daa90] --&gt;&lt;div class="jive-rendered-content"&gt;When trying to consume a webservice (temporarily located on a
server within my intranet) I get this Cold Fusion Error:
&lt;br/&gt;
&lt;br/&gt;Web service operation "getIndustries" with parameters
{CareerStart} could not be found.
&lt;br/&gt;
&lt;br/&gt;This is what is in the wdsl file for the function I am trying
to access:
&lt;br/&gt;
&lt;br/&gt;- &amp;lt;s:element name="getIndustries"&amp;gt;
&lt;br/&gt;- &amp;lt;s:complexType&amp;gt;
&lt;br/&gt;- &amp;lt;s:sequence&amp;gt;
&lt;br/&gt; &amp;lt;s:element minOccurs="1" maxOccurs="1"
name="getIndustriesRequest" type="tns:CareerTrack" /&amp;gt; 
&lt;br/&gt; &amp;lt;/s:sequence&amp;gt;
&lt;br/&gt; &amp;lt;/s:complexType&amp;gt;
&lt;br/&gt; &amp;lt;/s:element&amp;gt;
&lt;br/&gt;- &amp;lt;s:simpleType name="CareerTrack"&amp;gt;
&lt;br/&gt;- &amp;lt;s:restriction base="s:string"&amp;gt;
&lt;br/&gt; &amp;lt;s:enumeration value="CareerStart" /&amp;gt; 
&lt;br/&gt; &amp;lt;s:enumeration value="ContinuingEd" /&amp;gt; 
&lt;br/&gt; &amp;lt;/s:restriction&amp;gt;
&lt;br/&gt; &amp;lt;/s:simpleType&amp;gt;
&lt;br/&gt;- &amp;lt;s:element name="getIndustriesResponse"&amp;gt;
&lt;br/&gt;- &amp;lt;s:complexType&amp;gt;
&lt;br/&gt;- &amp;lt;s:sequence&amp;gt;
&lt;br/&gt; &amp;lt;s:element minOccurs="0" maxOccurs="1"
name="getIndustriesResult" type="tns:ArrayOfKeyValuePair" /&amp;gt; 
&lt;br/&gt; &amp;lt;/s:sequence&amp;gt;
&lt;br/&gt; &amp;lt;/s:complexType&amp;gt;
&lt;br/&gt; &amp;lt;/s:element&amp;gt;
&lt;br/&gt;- &amp;lt;s:complexType name="ArrayOfKeyValuePair"&amp;gt;
&lt;br/&gt;- &amp;lt;s:sequence&amp;gt;
&lt;br/&gt; &amp;lt;s:element minOccurs="0" maxOccurs="unbounded"
name="KeyValuePair" nillable="true" type="s1:KeyValuePair" /&amp;gt; 
&lt;br/&gt; &amp;lt;/s:sequence&amp;gt;
&lt;br/&gt; &amp;lt;/s:complexType&amp;gt;
&lt;br/&gt;- &amp;lt;s:complexType name="KeyValuePair"&amp;gt;
&lt;br/&gt;- &amp;lt;s:sequence&amp;gt;
&lt;br/&gt; &amp;lt;s:element minOccurs="0" maxOccurs="1" name="Key"
type="s:string" /&amp;gt; 
&lt;br/&gt; &amp;lt;s:element minOccurs="0" maxOccurs="1" name="Value"
type="s:string" /&amp;gt; 
&lt;br/&gt; &amp;lt;/s:sequence&amp;gt;
&lt;br/&gt; &amp;lt;/s:complexType&amp;gt;
&lt;br/&gt;
&lt;br/&gt;I am attempting to use this function with cold fusion like
so:
&lt;br/&gt;
&lt;br/&gt;&amp;lt;CFPARAM name="CareerTrack" default="CareerStart"
type="string"&amp;gt;
&lt;br/&gt;&amp;lt;CFOBJECT webservice="#webservice#"
&lt;br/&gt; name="regExchange"&amp;gt;
&lt;br/&gt;
&lt;br/&gt;&amp;lt;cfset aArrayOfKeyValuePair =
regExchange.getIndustries(#CareerTrack#)&amp;gt;
&lt;br/&gt; 
&lt;br/&gt;Is there something about passing in values to a type of enum
that is special?
&lt;br/&gt;
&lt;br/&gt;I think I should have visibility to the webservice based on
the evidence that when I set the wdsl url in Dreamweaver, it shows
me the service function definitions and I can drag and drop them
into my code.&lt;/div&gt;&lt;!-- [DocumentBodyEnd:3debd338-81fe-4bbb-8a3e-30ae131daa90] --&gt;</description>
      <pubDate>Mon, 11 Sep 2006 21:38:26 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/88154</guid>
      <dc:date>2006-09-11T21:38:26Z</dc:date>
      <clearspace:dateToText>2 months 2 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>5</clearspace:messageCount>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Connecting to Exchange</title>
      <link>https://forums.adobe.com/thread/116208</link>
      <description>&lt;!-- [DocumentBodyStart:d537e574-4600-4274-8f9d-acd0440ff2c9] --&gt;&lt;div class="jive-rendered-content"&gt;I am trying to test out the new cfexchange tags in
Colldfusion 8 so that I can integrate in with our intranet at some
point but am having some difficulty.
&lt;br/&gt;
&lt;br/&gt;I am just testing by using the tag:
&lt;br/&gt;
&lt;br/&gt; &amp;lt;cfexchangeconnection action="open" connection="myConn"
server="192.168.0.20" username="myUsername" password="myPassword"
formbasedauthentication="true"&amp;gt;
&lt;br/&gt;
&lt;br/&gt;I keep getting the error, Unable to connect to the Exchange
server using HTTP/HTTPS protocol. 
&lt;br/&gt;HTTP response code : 302 
&lt;br/&gt;
&lt;br/&gt;Here is what I have currently checked.
&lt;br/&gt;
&lt;br/&gt;1) I can ping the exchange server from the server that is
running Colfusion 8
&lt;br/&gt;2) The Exchange server has "allow" for MS Exchange Server in
the "Web service Extension" of IIS
&lt;br/&gt;3) Outlook Web Access is working and is enabled for my user
account
&lt;br/&gt;4) Rechecked the ip address of the Exchange Server 
&lt;br/&gt;5) tried username/passsword combo that I use for Exchange and
OWA and even tried appending username@domainname.local
&lt;br/&gt;
&lt;br/&gt;Anyone have any ideas to test further
&lt;br/&gt;
&lt;br/&gt;Thanks,
&lt;br/&gt;
&lt;br/&gt;Brian
&lt;br/&gt;
&lt;br/&gt;
&lt;br/&gt;
&lt;br/&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:d537e574-4600-4274-8f9d-acd0440ff2c9] --&gt;</description>
      <pubDate>Fri, 09 Nov 2007 17:21:56 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/116208</guid>
      <dc:date>2007-11-09T17:21:56Z</dc:date>
      <clearspace:dateToText>2 months 2 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>8</clearspace:messageCount>
      <clearspace:replyCount>7</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Clearing Session and/or App variables with Log-out Page?</title>
      <link>https://forums.adobe.com/thread/1549960</link>
      <description>&lt;!-- [DocumentBodyStart:a497a391-b488-4786-8cfd-892d2dc62e99] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Greetings&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I have 3 distinct user types for my app- admins, appraisers and clients.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;All have their own directories and each directory has it's own Application.cfm:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;1) &amp;lt;cfapplication name="appraiseri" &lt;/p&gt;&lt;p&gt;applicationtimeout="#CreateTimeSpan(0,2,0,0)#"&lt;/p&gt;&lt;p&gt;clientmanagement="Yes" &lt;/p&gt;&lt;p&gt;sessionmanagement="Yes" &lt;/p&gt;&lt;p&gt;sessiontimeout="#CreateTimeSpan(0,2,0,0)#"&lt;/p&gt;&lt;p&gt;SetClientCookies="Yes"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;2) &amp;lt;cfapplication name="appraiserview" ......&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;3) &amp;lt;cfapplication name="clientview" .......&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Each have their own login which simply uses their ID in the DB as the session variable.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;login_do.cfm:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;1) Appraisers: &amp;lt;CFIF auth_direct_appraiser.RecordCount NEQ 0 &amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfset Session.appraiser_user_id =auth_direct_appraiser.appraiser_ID&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfset Session.appraiser_fname =auth_direct_appraiser.appraiser_fname&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfset Session.appraiser_lname =auth_direct_appraiser.appraiser_lname&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;2) Admins: &amp;lt;cfset Session.user_id =auth_direct.staff_ID&amp;gt; ......&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;3) Clients: &amp;lt;cfset Session.processor_user_id =auth_direct_processor.processor_ID&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I have had a session persisting for a week now- I have no idea how to get rid of it, and if one simply hits the "login" submit button with no UN or PW, it runs a query on a client (the same one) ?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;My logout page is not working at all- if the code were correct, it would clear any session variable? I have not really set an app variable (except timeout) so no need to clear that?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Here is the code:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;CFLOCK SCOPE="Session" TYPE="Exclusive" TIMEOUT="60"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;CFLOOP COLLECTION="#Session#" ITEM="Key"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;CFIF NOT ListFindNoCase('IveSeenIT', Key)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;CFSET StructDelete(Session, Key)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/CFIF&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/CFLOOP&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/CFLOCK&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;SCRIPT LANGUAGE="JavaScript"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; alert("You have been logged out from the XXXXX Intranet")&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; location.href='login.cfm';&lt;/p&gt;&lt;p&gt;&amp;lt;/SCRIPT&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Any help would be appreciated- this is leaving a huge security gap in the app right now.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:a497a391-b488-4786-8cfd-892d2dc62e99] --&gt;</description>
      <pubDate>Sun, 17 Aug 2014 19:21:54 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1549960</guid>
      <dc:date>2014-08-17T19:21:54Z</dc:date>
      <clearspace:dateToText>2 months 4 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>In CF 9 can I create a custom page URLs, similar to Wordpress?</title>
      <link>https://forums.adobe.com/thread/1538155</link>
      <description>&lt;!-- [DocumentBodyStart:c4bcbdaf-4102-4c82-b01c-f8b5e7a56cac] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I would like to create a function for my clients to create a custom page URL similar tot what Wordpress can can do. So my client's can customize the page URL info for example http:/www.novospa.ca/guinot-skin-care-products/&lt;/p&gt;&lt;p&gt;&amp;nbsp; Is this doable and how would I do it?&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:c4bcbdaf-4102-4c82-b01c-f8b5e7a56cac] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">cold fusion</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">url parameters</category>
      <pubDate>Sun, 03 Aug 2014 04:25:47 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1538155</guid>
      <dc:date>2014-08-03T04:25:47Z</dc:date>
      <clearspace:dateToText>3 months 3 days ago</clearspace:dateToText>
      <clearspace:messageCount>5</clearspace:messageCount>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <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;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">application</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">session</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">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:messageCount>3</clearspace:messageCount>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>General problem communicating with SOAP-API</title>
      <link>https://forums.adobe.com/thread/1542348</link>
      <description>&lt;!-- [DocumentBodyStart:2ea301b0-5b9f-4d01-b858-f7aab26303ee] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hello,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;does anybody know whats wrong with this basic code?&lt;/p&gt;&lt;p&gt;Whatever I post to this API, I always get back the API itself.. Strange. Maybe someone could try this code?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span&gt;&amp;lt;cfhttp method="POST" url="&lt;/span&gt;&lt;a class="jive-link-external-small" href="https://sandbox-soap.billsafe.de/wsdl/V211" rel="nofollow"&gt;https://sandbox-soap.billsafe.de/wsdl/V211&lt;/a&gt;&lt;span&gt;"&amp;nbsp;&amp;nbsp; result="httpResponse"&amp;nbsp; &amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfhttpparam type="header" name="content-type" value="text/xml" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfhttpparam type="header" name="charset" value="utf-8" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfhttpparam type="header" name="accept-encoding" value="no-compression" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfhttpparam type="xml" value="anything" /&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfhttp&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Normally I put SOAP-content in the last cfhttpparam-tag but the API doesnt care about what I'm posting so I think the problem is anywhere else.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I tried to deal with the api using SOAP-UI, that wor&amp;acute;ks.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Any Ideas?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thank you&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Problem is more detailed described here: &lt;a class="jive-link-thread-small" data-containerId="2223" data-containerType="14" data-objectId="1541502" data-objectType="1" href="https://forums.adobe.com/thread/1541502"&gt;SOAP-API is not talking to me&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:2ea301b0-5b9f-4d01-b858-f7aab26303ee] --&gt;</description>
      <pubDate>Fri, 08 Aug 2014 10:58:21 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1542348</guid>
      <dc:date>2014-08-08T10:58:21Z</dc:date>
      <clearspace:dateToText>3 months 5 days ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>displaying coldfusion reports thru Asp.Net site</title>
      <link>https://forums.adobe.com/thread/1532166</link>
      <description>&lt;!-- [DocumentBodyStart:20f240ff-3fa5-4f95-af92-b4412977391c] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;&lt;br/&gt;I am new to coldfusion and have inherited a project from work that involves&amp;nbsp; coldfusion apps that produces reports. I want to create a ASP.Net App with a new front end that will link to the coldfusion&amp;nbsp; apps and display the reports.....any ideas?&amp;nbsp; Thanks in advance&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:20f240ff-3fa5-4f95-af92-b4412977391c] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">asp.net;</category>
      <pubDate>Sat, 26 Jul 2014 22:49:09 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1532166</guid>
      <dc:date>2014-07-26T22:49:09Z</dc:date>
      <clearspace:dateToText>3 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>1</clearspace:messageCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Disable cffunction accepting undeclared arguments?</title>
      <link>https://forums.adobe.com/thread/1524306</link>
      <description>&lt;!-- [DocumentBodyStart:a5d6f75d-576e-48e0-acee-40830f7caf7d] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a lot of function calls with long lists of arguments and sometimes they can get mismatched (invoke with invokeargument status, function argument status_code). Coldfusion allows this to happen and makes the undeclared argument available in the arguments scope. Is there any way to disable this behavior so it only allows declared arguments and throws and error when it gets passed an argument that it doesn't expect?&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:a5d6f75d-576e-48e0-acee-40830f7caf7d] --&gt;</description>
      <pubDate>Thu, 17 Jul 2014 15:05:12 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1524306</guid>
      <dc:date>2014-07-17T15:05:12Z</dc:date>
      <clearspace:dateToText>3 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>7</clearspace:messageCount>
      <clearspace:replyCount>6</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>CF11 Object doesn't support property or method 'getColumnModel', Unable to get property 'tagName'</title>
      <link>https://forums.adobe.com/thread/1523302</link>
      <description>&lt;!-- [DocumentBodyStart:b934266c-0eb8-4368-bd37-8dfe148f8d3c] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have many pages that use CFGRID and most of those pages use script to manipulate either the grid itself or data within the grids.&amp;nbsp; All of the scripting worked fine in CF9 and CF10.&amp;nbsp; While testing it on CF11, none of the code works.&amp;nbsp; To me it appears that changes were made in the ext-js imports that are not backwards compatible.&amp;nbsp; The first error thrown is the "Object doesn't support property or method 'getColumnModel'", with the source being the file that I am calling.&amp;nbsp; The code I typically use to call it is:&lt;/p&gt;&lt;p&gt;changeStatus = function () {&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; grid = ColdFusion.Grid.getGridObject('gridName');&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; cm = grid.getColumnModel();&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; cm.setRenderer(18,ChangeSomething);&lt;/p&gt;&lt;p&gt;}&lt;/p&gt;&lt;p&gt;That error is followed by "Unable to get property 'tagName' of undefined or null reference", with the source being {site}/cfide/scripts/ajax/ext/ext-all.js.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Did the format to call the getColumnModel get changed in ColdFusion 11?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Message was edited by: DONALD BAERT&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:b934266c-0eb8-4368-bd37-8dfe148f8d3c] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">cfgrid</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">coldfusion 11</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">getcolumnmodel</category>
      <pubDate>Wed, 16 Jul 2014 12:05:19 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1523302</guid>
      <dc:date>2014-07-16T12:05:19Z</dc:date>
      <clearspace:dateToText>3 months 4 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>CFGrid Headers Invisible in IE until mouseover</title>
      <link>https://forums.adobe.com/thread/1381444</link>
      <description>&lt;!-- [DocumentBodyStart:5a195837-4971-446a-bc38-eed6d73b113b] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;My client uses CFGRID and IE a lot (yeah, I know) and I have been tasked to solve this problem.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;When the grid first comes up in IE, the headers are invisible; mouse over them and they'll appear and stay on until you move on to a new table or refresh the screen.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Firefox and Chrome do not have this problem.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;To make matters worse, my client has disabled the developer tools access in IE so I can't drill down to the CSS and look for a solution that way.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I am trying to find a cfgrid.onload solution, but apparently the documentation is sparse on the methods available in cfgrid (know where they are? Please enlighten me!)&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I stumbled across .refresh() and updateHeaders() but I cannot find their proper syntax and just what the heck they're supposed to do.&amp;nbsp; I know, lame, but try RTFM when you can't find TFM!&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;My first try was to create and OnLoad this:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;function IEReload() {&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; var grid = ColdFusion.Grid.getGridObject('mygridname');&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; grid.updateHeaders('mygridname');&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; grid.refresh('mygridname');&lt;/p&gt;&lt;p&gt;}&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;which does not work. &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Ideas welcome!&lt;/p&gt;&lt;p&gt;Thanks,&lt;/p&gt;&lt;p&gt;RLS&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:5a195837-4971-446a-bc38-eed6d73b113b] --&gt;</description>
      <pubDate>Thu, 16 Jan 2014 16:59:18 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1381444</guid>
      <dc:date>2014-01-16T16:59:18Z</dc:date>
      <clearspace:dateToText>3 months 1 month ago</clearspace:dateToText>
      <clearspace:messageCount>5</clearspace:messageCount>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Calendar code preformance issue</title>
      <link>https://forums.adobe.com/thread/1523613</link>
      <description>&lt;!-- [DocumentBodyStart:41b047c9-4020-4700-9a43-d71cc55b2018] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I took the below from a function I'm using to render a weekly calendar similar to outlooks weekly calender view. The problem is when I start entering HTML outputs it begins to run very slow. I have another function that returns the events in a structure but if I loop the structure to find events it crashes the browser with a timeout. Can someone tell me what I'm doing wrong, is there a better way??&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;var local = StructNew();&lt;/p&gt;&lt;p&gt;//Copy the URL and Form structures into REQUEST&lt;/p&gt;&lt;p&gt;REQUEST.Attributes = StructCopy(URL);&lt;/p&gt;&lt;p&gt;StructAppend( REQUEST.Attributes,FORM);&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;//Define a default opening date&lt;/p&gt;&lt;p&gt;REQUEST.DefaultDate = Fix(Now());&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;//START *** time increments&lt;/p&gt;&lt;p&gt;local.dtTimeIncrement=5;&lt;/p&gt;&lt;p&gt;local.dtTimeStart=1;&lt;/p&gt;&lt;p&gt;local.dtTimeEnd=24;&lt;/p&gt;&lt;p&gt;local.dteventsPerTime=1;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;try{&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; local.dtThisWeek = (REQUEST.Attributes.date - DayOfWeek( REQUEST.Attributes.date ) +1);&lt;/p&gt;&lt;p&gt;} catch(any excpt) {&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; local.dtThisWeek = (REQUEST.DefaultDate -DayOfWeek( REQUEST.DefaultDate ) +1);&lt;/p&gt;&lt;p&gt; }&lt;/p&gt;&lt;p&gt;local.dtPrevWeek = DateAdd( "ww", -1, local.dtThisWeek );&lt;/p&gt;&lt;p&gt;local.dtNextWeek = DateAdd( "ww", 1, local.dtThisWeek );&lt;/p&gt;&lt;p&gt;local.dtLastDayOfWeek = (local.dtNextWeek - 1);&lt;/p&gt;&lt;p&gt;local.dtFirstDay = local.dtThisWeek;&lt;/p&gt;&lt;p&gt;local.dtLastDay = local.dtLastDayOfWeek;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;if ((Year( local.dtThisWeek ) NEQ Year( REQUEST.DefaultDate )) OR (Month( local.dtThisWeek ) NEQ Month( REQUEST.DefaultDate )) OR (Week( local.dtThisWeek ) NEQ Week( REQUEST.DefaultDate ))){&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; REQUEST.DefaultDate = Fix( local.dtThisWeek );&lt;/p&gt;&lt;p&gt; }&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;//**BEGIN *** Loop the clock HOURS from start time to end time&lt;/p&gt;&lt;p&gt;for (local.i = local.dtTimeStart; local.i &amp;lt;= local.dtTimeEnd; local.i++) {&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; local.DateVal=CreateDateTime(year(REQUEST.DefaultDate), month(REQUEST.DefaultDate), day(REQUEST.DefaultDate), local.i, 00, 00);&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; //**BEGIN *** LOOP THE WEEK FOR EACH TIME SLOT&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; for (local.j = local.dtFirstDay; local.j &amp;lt;= local.dtLastDay; local.j++) {&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; local.dtDayTime=CreateDateTime(year(Fix(local.j)),month(Fix(local.j)),day(Fix(local.j)), local.i, 00, 00);&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; //**END *** LOOP THE WEEK FOR EACH TIME SLOT&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; //**BEGIN *** Loop the clock MINUTES from start to end&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; for (local.k = 1; local.k &amp;lt;= local.TimeIncSel; local.k++) {&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; local.DateVal=CreateDateTime(year(REQUEST.DefaultDate), month(REQUEST.DefaultDate), day(REQUEST.DefaultDate), local.i, local.k*local.dtTimeIncrement, 00);&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; //**BEGIN *** LOOP THE WEEK FOR EACH TIME SLOT&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; for (local.l = local.dtFirstDay; local.l &amp;lt;= local.dtLastDay; local.l++) {&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; local.dtDayTime=CreateDateTime(year(Fix(local.l)),month(Fix(local.l)),day(Fix(local.l)), local.i, local.k*local.dtTimeIncrement, 00);&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; //**END *** LOOP THE WEEK FOR EACH TIME SLOT&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; //**END *** Loop the clock MINUTES from start to end&lt;/p&gt;&lt;p&gt;}&lt;/p&gt;&lt;p&gt; //**END *** Loop the clock HOURS from start time to end time&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:41b047c9-4020-4700-9a43-d71cc55b2018] --&gt;</description>
      <pubDate>Wed, 16 Jul 2014 18:10:54 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1523613</guid>
      <dc:date>2014-07-16T18:10:54Z</dc:date>
      <clearspace:dateToText>3 months 1 month ago</clearspace:dateToText>
      <clearspace:messageCount>1</clearspace:messageCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Facebook Chat</title>
      <link>https://forums.adobe.com/thread/1388256</link>
      <description>&lt;!-- [DocumentBodyStart:c5f35330-b844-467c-bed6-a0f3b32031d4] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi Everyone,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Has anyone built an event gateway or other cfc into Facebook chat. I want to send messages form my facebook app into facebook chat using CF and from my reading it appears that what I want is an event gateway. I really don't know much about XMPP so any and all help is appreciated. &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Mark&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:c5f35330-b844-467c-bed6-a0f3b32031d4] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">facebook</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">event</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">chat</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">event_gateway</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">facebook_chat</category>
      <pubDate>Fri, 24 Jan 2014 02:40:48 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1388256</guid>
      <dc:date>2014-01-24T02:40:48Z</dc:date>
      <clearspace:dateToText>4 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>3</clearspace:messageCount>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Password Protect all .cfm files in a directory?</title>
      <link>https://forums.adobe.com/thread/1495350</link>
      <description>&lt;!-- [DocumentBodyStart:5549fdbe-b554-4f1b-8a0f-dc5d29c8d8ff] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Greetings&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Can anyone share the code one one put within the application.cfm to password-protect all the files in that directory?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The UN &amp;amp; PW are stored in a DB - of course I could create a session_ID and protect each page individually, which I have been doing for years, but in this case, the pages are being loaded using a half-*ss CMS and the users, other than saving files as .cfm, will not be responsible to leave the code on each page.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;In the DB, the user name is subscriber_email, the password is subscriber_password.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks for any help.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:5549fdbe-b554-4f1b-8a0f-dc5d29c8d8ff] --&gt;</description>
      <pubDate>Thu, 12 Jun 2014 17:53:02 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1495350</guid>
      <dc:date>2014-06-12T17:53:02Z</dc:date>
      <clearspace:dateToText>4 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>11</clearspace:messageCount>
      <clearspace:replyCount>10</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cfform autosuggest pass 2 values (locationname and locationid)</title>
      <link>https://forums.adobe.com/thread/1505507</link>
      <description>&lt;!-- [DocumentBodyStart:894a1ae5-7a59-4092-9586-e03c607a8f40] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi chaps,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I've decided it's about time I started using cfform (3 mins in and I've already hit my first stumbling block!)&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I want to have an autosuggest text input for users to choose a city. In my db I have locationnames and locationids. &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;eg&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;locationid&amp;nbsp;&amp;nbsp; |&amp;nbsp;&amp;nbsp; locationname&lt;/p&gt;&lt;p&gt;----------------------------------------&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;1&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; London&lt;/p&gt;&lt;p&gt;2&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; New York&lt;/p&gt;&lt;p&gt;3&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Paris&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;etc&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The user will start to type the locationame - I want autosuggest to show locationanames that match, but when they submit the form I actually want the locationid to be passed..&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;How on earth do I do this with cfform?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks very much for any help you can offer.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Nick&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:894a1ae5-7a59-4092-9586-e03c607a8f40] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">cfform</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">autosuggest</category>
      <pubDate>Tue, 24 Jun 2014 11:29:03 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1505507</guid>
      <dc:date>2014-06-24T11:29:03Z</dc:date>
      <clearspace:dateToText>4 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>6</clearspace:messageCount>
      <clearspace:replyCount>5</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Database Design Question: What are the consequences of using a "One Table to Rule Them All" Approach?</title>
      <link>https://forums.adobe.com/thread/1499090</link>
      <description>&lt;!-- [DocumentBodyStart:f46cc1e6-e60b-498b-992f-03cf73c7c722] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a MSSQL database schema question that I&amp;#8217;d love to have the community's opinion on.&amp;nbsp; I&amp;#8217;m looking for the optimal way of storing one-to-many relationships for a variety of table combinations.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I&amp;#8217;m familiar with the basic idea of relationship tables&amp;nbsp; (the green table links Table1 to Table2):&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;strong&gt;Table1&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table2&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span style="color: #9bbb59;"&gt;Table1Table2&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;Table1ID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table2ID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table1Table2ID&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table1ID&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table2ID&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;What I&amp;#8217;m trying to do though is to be able to link multiple tables together using a single relationship table.&amp;nbsp; I&amp;#8217;m using my server-side code to specify which tables are being linked (green table is relationship table and the red column indicates which table is being linked to Table1):&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;strong&gt;Table1&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table2&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table3&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span style="color: #9bbb59;"&gt;Table1TableX&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;Table1ID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table2ID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table3ID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table1TableXID&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table1ID&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; TableXID&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span style="color: #ff0000;"&gt;TableX&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;In the above example, I&amp;#8217;m using the column &amp;#8220;TableX&amp;rdquo; to define which tables (Table2 or Table3) is being joined to Table1.&amp;nbsp; This brings me to my first question:&amp;nbsp; &lt;span style="color: #8064a2;"&gt;What are the consequences of doing things this way?&amp;nbsp; Am I going to encounter a serious performance hit when records get into the 1000s+ ?&amp;nbsp; I realize that I&amp;#8217;ll have to enforce table integrity on the application layer and I&amp;#8217;m okay with that aspect.&amp;nbsp; &lt;/span&gt;I've been developing my application like this for quite a while now and so far it has worked out pretty well in keeping my database structure simplified.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Now I&amp;#8217;m looking to simplify things even further and create a &amp;#8220;&lt;strong&gt;&lt;em&gt;one table to rule them all&lt;/em&gt;&lt;/strong&gt;&amp;rdquo; approach.&amp;nbsp; Basically, I&amp;#8217;d like to create 1 relationship table that would control the relationships between all of my other tables.&amp;nbsp; In this method I specify in the column values which tables are being connected.&amp;nbsp; For example: (green table below is the relationship table and red tables point to the tables that are linked)&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;strong&gt;Table1&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table2&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table3&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table4&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span style="color: #9bbb59;"&gt;Relationships&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;&lt;p&gt;Table1ID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table2ID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table3ID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table4ID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; RelationshipsID&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span style="color: #ff0000;"&gt;ParentTable&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span style="color: #ff0000;"&gt;ChildTable&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ParentID&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ChildID&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Am I totally crazy here? &lt;span style="color: #8064a2;"&gt;Or would a setup like this be a viable solution for linking multiple tables together in a single place?&amp;nbsp; &lt;/span&gt;So far the only consequences that I see are that my SELECT queries are a little more complex because I have to specify which tables are linked. For example, a simple joined query which looked like this:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;SELECT *&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;FROM Table1 t1 INNER JOIN &lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table1Table2 tt ON t1.Table1ID = tt.Table1ID INNER JOIN &lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table2 t2 ON tt.Table2ID = t2.Table2ID&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Now becomes:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;SELECT *&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;FROM Table1 t1 INNER JOIN&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; (SELECT ParentID, ChildID &lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM Relationships&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; WHERE ParentTable = &amp;lsquo;Table1&amp;#8217;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="color: #4bacc6;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; AND ChildTable = &amp;lsquo;Table2&amp;#8217;&lt;/span&gt;&lt;/p&gt;&lt;p style="margin-left: .5in;"&gt;&lt;span style="color: #4bacc6;"&gt;) tt ON t1.ParentID = t1.Table1ID INNER JOIN&lt;/span&gt;&lt;/p&gt;&lt;p style="margin-left: .5in;"&gt;&lt;span style="color: #4bacc6;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Table2 t2 ON tt.ChildID = t2.Table2ID&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;So aside from having my queries be a little more complex, the database structure looks a lot cleaner when it&amp;#8217;s all diagramed out.&amp;nbsp; Do you think this is a bad idea to develop a database this way? If so, why?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks for taking the time to check this out&amp;hellip; I&amp;#8217;d be curious to know your thoughts.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:f46cc1e6-e60b-498b-992f-03cf73c7c722] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">mssql</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">coldfusion</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">database schema</category>
      <pubDate>Wed, 18 Jun 2014 01:06:05 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1499090</guid>
      <dc:date>2014-06-18T01:06:05Z</dc:date>
      <clearspace:dateToText>4 months 4 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>execute js function on clicking tab?</title>
      <link>https://forums.adobe.com/thread/956699</link>
      <description>&lt;!-- [DocumentBodyStart:9f6252e9-36be-42c5-b270-a66310181988] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;i have a js function that works fine when attached to the onClick event of a button, but i want it to execute when user clicks the tab&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;is there a way to do that?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;function clearURL() {&lt;/p&gt;&lt;p&gt;var testURL = document.URL;&lt;/p&gt;&lt;p&gt;var urlQry = testURL.split("?")[1];&lt;/p&gt;&lt;p&gt;if (urlQry != "") &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; var activeTab = ColdFusion.Layout.getTabLayout('myLayout').getActiveTab().title;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; if (activeTab == 'myTabTitle') &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; var newURL = testURL.split("?")[0];&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; window.location = newURL;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;/p&gt;&lt;p&gt;}&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;thanks&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:9f6252e9-36be-42c5-b270-a66310181988] --&gt;</description>
      <pubDate>Tue, 31 Jan 2012 16:45:37 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/956699</guid>
      <dc:date>2012-01-31T16:45:37Z</dc:date>
      <clearspace:dateToText>5 months 2 days ago</clearspace:dateToText>
      <clearspace:messageCount>9</clearspace:messageCount>
      <clearspace:replyCount>8</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>CF10 Scheduled Task Event Handling Question</title>
      <link>https://forums.adobe.com/thread/1492750</link>
      <description>&lt;!-- [DocumentBodyStart:004a3337-6b2e-494b-93da-511c02588b73] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have some questions about hooking up error handling in CF10 for a scheduled task. I have a cfc ready to go handle the errors. In the coldfusion administrator what exactly do I put down for a path? The example says a.b.server. Is there a specific folder that I need to place the cfc or just path it to wherever I put it? Does it need to be inside the cfusion directory somewhere?&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:004a3337-6b2e-494b-93da-511c02588b73] --&gt;</description>
      <pubDate>Mon, 09 Jun 2014 14:06:11 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1492750</guid>
      <dc:date>2014-06-09T14:06:11Z</dc:date>
      <clearspace:dateToText>5 months 3 days ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>barcode scan</title>
      <link>https://forums.adobe.com/thread/1493503</link>
      <description>&lt;!-- [DocumentBodyStart:51caa907-7a17-4348-a715-31907db4e7c6] --&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;The form I have with several fields on it such as ProductID, Description, Price, &lt;span class="GINGER_SOFTWARE_mark"&gt;ect&lt;/span&gt;.&amp;nbsp;&amp;nbsp;&amp;nbsp; The back-end database is storing the information &lt;span class="GINGER_SOFTWARE_mark"&gt;of&lt;/span&gt; these fields.&amp;nbsp; I have the &lt;span class="GINGER_SOFTWARE_mark"&gt;sheet&lt;/span&gt; list of all &lt;span class="GINGER_SOFTWARE_mark"&gt;productID&lt;/span&gt; and scanner to scan the &lt;span class="GINGER_SOFTWARE_mark"&gt;productid&lt;/span&gt; barcode.&amp;nbsp; The &lt;span class="GINGER_SOFTWARE_mark"&gt;productID&lt;/span&gt; is can into the &lt;span class="GINGER_SOFTWARE_mark"&gt;productID&lt;/span&gt; field from the form.&amp;nbsp; My question is how can I populate the Description and Price of each &lt;span class="GINGER_SOFTWARE_mark"&gt;productID&lt;/span&gt; when it&amp;#8217;s &lt;span class="GINGER_SOFTWARE_mark"&gt;scan&lt;/span&gt;?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:51caa907-7a17-4348-a715-31907db4e7c6] --&gt;</description>
      <pubDate>Tue, 10 Jun 2014 13:48:42 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1493503</guid>
      <dc:date>2014-06-10T13:48:42Z</dc:date>
      <clearspace:dateToText>5 months 4 days ago</clearspace:dateToText>
      <clearspace:messageCount>1</clearspace:messageCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>application.cfc site variables</title>
      <link>https://forums.adobe.com/thread/1489558</link>
      <description>&lt;!-- [DocumentBodyStart:a4b93987-b560-4ef3-9b91-20ee12a4a868] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I switched over to using application.cfc not too long ago. One thing I have struggled with is how to set variables that I use on individual pages of my site like I used to do in application.cfm. I have some passowrds for sftp services etc that I used to set in application.cfm. I have not been able to figure out how to make them work with application.cfc so I can call them where I need to. &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I have tried setting them in onrequeststart, onapplicationstart etc. but nothing seems to work. The variables are never defined. &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Does anyone have a working example of how to set variables that can be used on your site globally?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Is there a better way to store account passwords and variables like that that I am missing?&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:a4b93987-b560-4ef3-9b91-20ee12a4a868] --&gt;</description>
      <pubDate>Wed, 04 Jun 2014 14:07:03 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1489558</guid>
      <dc:date>2014-06-04T14:07:03Z</dc:date>
      <clearspace:dateToText>5 months 1 week ago</clearspace:dateToText>
      <clearspace:messageCount>5</clearspace:messageCount>
      <clearspace:replyCount>4</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>How to get 'name' from 'name@domain.com' using cf reg ex?</title>
      <link>https://forums.adobe.com/thread/1482674</link>
      <description>&lt;!-- [DocumentBodyStart:757c7b94-5454-4382-a920-e568bdcb6305] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi everyone.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;span&gt;I'm trying to get 'name' from &lt;/span&gt;&lt;a class="jive-link-email-small" href="mailto:'name@domain.com"&gt;'name@domain.com&lt;/a&gt;&lt;span&gt;' using cf reg ex.&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I've got this so far #rereplace('temp.emailaddress','[^@]+','')#&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;which is giving me @domain.com - but I want the first part, can anyone point me in the right direction please?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks ever so much.&lt;/p&gt;&lt;p&gt;Nick&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:757c7b94-5454-4382-a920-e568bdcb6305] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">regex</category>
      <pubDate>Mon, 26 May 2014 10:29:50 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1482674</guid>
      <dc:date>2014-05-26T10:29:50Z</dc:date>
      <clearspace:dateToText>5 months 2 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>4</clearspace:messageCount>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>CFTRANSACTION: Am I using it incorrectly?</title>
      <link>https://forums.adobe.com/thread/1481730</link>
      <description>&lt;!-- [DocumentBodyStart:b9968c13-99c6-42aa-8541-c00d097dae72] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Just so we don't get too far off track, keep in mind the code samples below aren't my true code. I'm stripping things down for illustration purposes only - I realize they're bad examples and lack CFQUERYPARAM. &lt;span aria-label="Wink" class="emoticon-inline emoticon_wink" style="height:16px;width:16px;"&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;So, to give a little background first... I started my ColdFusion programming career over a decade ago building fairly large e-commerce applications. Not Amazon scale, but not mom-and-pop shopping carts by any means.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;In those days I often used CFTRANSACTION for situations where multiple INSERT or UPDATE queries relied on each other. For example, a form that inserts a new product into a database table, and inventory counts into a separate table.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;For example:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&amp;lt;cftransaction&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px; padding-left: 30px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;cfquery datasource="mydatasource" result="product_inserted"&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;INSERT INTO products (sku, price, title)&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;VALUES ('555-555', 2.50, 'Spider-Man T-Shirt')&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;/cfquery&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;cfquery datasource="mydatasource"&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt;"&gt;INSERT INTO inventory (product_id, inventory)&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt;"&gt;VALUES (#product_inserted.IDENTITYCOL#, 50)&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;/cfquery&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;/cftransaction&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;This insures that both tables are written to. If a query fails for some reason, the other won't be committed to the database.&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;Somewhere along the line however I started what I believe is a futile (and possibly bad) practice.&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;In some applications I have a ColdFusion template which (when passed an ID number via a URL variable) allows the user to edit a record via a form.&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;The first thing the page does is check for the required URL variable, and then pulls the records from the database. It then displays that record in a form for editing.&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;When the form is submitted, the page obviously checks for the URL variable again, the required form fields, and then queries to make sure the record exists (as you don't want to continue with the UPDATE if the URL variable isn't a valid record, right?&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;So, the processing page for the form update might have code like this:&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;cftransaction&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;cfquery name="find_product" datasource="mydatasource"&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;SELECT *&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;FROM products&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;WHERE id = #url.sku#&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;/cfquery&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;(some code here that checks the form data for proper type, etc.)&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;cfquery datasource="mydatasource"&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;UPDATE products&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;SET myfield = #form.myfield#,&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; anotherfield = #form.anotherfield#&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;WHERE id = #find_product.sku#&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;/cfquery&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p style="padding-left: 30px;"&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&amp;lt;/cftransaction&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;You see what I did there? Somewhere along the line in my programming history I just suddenly started putting CFTRANSACTION tags around blocks of code that used multiple queries, usually a SELECT statement and then an UPDATE statement that was then updating the record found via the SELECT statement. I started treating CFTRANSACTION as some sort of "lock", thinking that it was somehow ensuring that the SELECT and UPDATE statement were uninterrupted by another other user who may be invoking the same page, thus avoiding a race conflict for the record being edited. &lt;strong&gt;Please someone set my mind at ease and tell me this is actually not accomplishing that, and all I'm doing is slowing down my DB processes?&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size: 10pt; line-height: 1.5em;"&gt;If my hunch is correct, and I've had a futile/bad habit for years, what would be the proper method for avoiding the above scenario?&lt;br/&gt;&lt;/span&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:b9968c13-99c6-42aa-8541-c00d097dae72] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">coldfusion</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">cftransaction</category>
      <pubDate>Sat, 24 May 2014 08:48:55 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1481730</guid>
      <dc:date>2014-05-24T08:48:55Z</dc:date>
      <clearspace:dateToText>5 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>6</clearspace:messageCount>
      <clearspace:replyCount>5</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Dynamically give a name to cfimage</title>
      <link>https://forums.adobe.com/thread/1481583</link>
      <description>&lt;!-- [DocumentBodyStart:66ec253c-5bca-4c4d-87e9-1882d34373cd] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I Have a page that displays a series of available items for the public to purchase. each of these items displays an image of the product. My cfimage code is made to scale-to-fit the stored image. normally the displayed results will all shoe different products and their corps pounding images. When I use the code below all of my different products will show the same image instead of showing the images that are linked to each product via a file path stored in the database. Is there a way to set the "name="myImage" dynamically so that each image will display and scale properly?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfimage source="C:\ColdFusion9\wwwroot\shotthp\#product.proimage#" name="myImage"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;!--- Turn on antialiasing. ---&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfset ImageSetAntialiasing(myImage)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfset ImageScaleToFit(myImage,182,"","highestPerformance")&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:66ec253c-5bca-4c4d-87e9-1882d34373cd] --&gt;</description>
      <pubDate>Sat, 24 May 2014 00:59:18 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1481583</guid>
      <dc:date>2014-05-24T00:59:18Z</dc:date>
      <clearspace:dateToText>5 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>4</clearspace:messageCount>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Elapsed time in business days?</title>
      <link>https://forums.adobe.com/thread/1477107</link>
      <description>&lt;!-- [DocumentBodyStart:c22573ba-9b6f-412d-8917-08e03493e818] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Greetings&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I am trying to get query results that would show elapsed time in business days. I have been so far unsuccessful in getting the elapsed days at all.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;An appraiser's clock starts ticking when an order is entered in the system (order_create_date). The clock stops for the appraiser when an order is completed (order_complete_date) and the turn-around time to the client is (order_report_sent_date).&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I attempted:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfquery name="get_client_tat" datasource="#Request.BaseDSN#"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; SELECT order_ID, order_create_date,&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DateDiff("d", order_create_date, order_report_sent_date) AS client_tat&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; FROM main_orders &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; WHERE order_ID = #list_orders_all.order_ID#&lt;/p&gt;&lt;p&gt;&amp;lt;/cfquery&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfquery name="get_appraiser_tat" datasource="#Request.BaseDSN#"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt; SELECT order_ID, order_create_date,&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; DateDiff("d", order_create_date, order_complete_date) AS appraiser_tat&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; FROM main_orders&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; WHERE order_ID = #list_orders_all.order_ID#&lt;/p&gt;&lt;p&gt;&amp;lt;/cfquery&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I simply get null results in &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfloop query="list_orders_all"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;#get_appraiser_tat.appraiser_tat# ,&lt;/p&gt;&lt;p&gt;#get_client_tat.client_tat#&amp;lt;/cfloop&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Would it be better to &amp;lt;cfset get_appraiser_tat = #DateDiff('d', DateA, DateB)#&amp;gt; etc. or in the SQL statement, and how would one count business days only?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Any help would be greatly appreciated.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Norman&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:c22573ba-9b6f-412d-8917-08e03493e818] --&gt;</description>
      <pubDate>Sun, 18 May 2014 21:38:08 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1477107</guid>
      <dc:date>2014-05-18T21:38:08Z</dc:date>
      <clearspace:dateToText>5 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>10</clearspace:messageCount>
      <clearspace:replyCount>9</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Unable to preserve indentation in cfgrid</title>
      <link>https://forums.adobe.com/thread/1477976</link>
      <description>&lt;!-- [DocumentBodyStart:90aa440f-5d0d-4185-982f-46b9527616a8] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have a cfgrid bound to a query in a cfc. The query indents one of the columns with blank spaces dependent on a hierarchy, like:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;...&lt;/p&gt;&lt;p&gt; SELECT regularColumn, indentedColumn = replicate(CHAR(32),((Hlevel-1)*2))+' '+indentedColumn&lt;/p&gt;&lt;p&gt;...&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Query works fine, i can see the indents in SQL server manager, but they never make it back to cfgrid. If i pick any other "visible" character works fine.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Any ideas?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:90aa440f-5d0d-4185-982f-46b9527616a8] --&gt;</description>
      <pubDate>Mon, 19 May 2014 19:56:04 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1477976</guid>
      <dc:date>2014-05-19T19:56:04Z</dc:date>
      <clearspace:dateToText>5 months 4 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>1</clearspace:messageCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cf9 cfselect bind</title>
      <link>https://forums.adobe.com/thread/1476091</link>
      <description>&lt;!-- [DocumentBodyStart:bdb73d80-a69c-4170-b8d8-28eecebdfee8] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have multiple dropdown lists on a form that are interdependent on each other. So, I'm using cfselects with binding based on selection of the previous drop down.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Here's the scenario:&lt;/p&gt;&lt;p&gt;Each 'sales representative' is assigned a number of clients. In turn, the clients are assigned a designated customer service rep.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I have a form that is using a cfselect to bind the clients displayed in the client list based on which sales representative is selected.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Once the 'client' is selected, I would like the next drop down list to populate with all customer service reps but have the rep that is actually assigned to the client be the default selected item in the drop down (e.g., selected="selected"). I need all service reps listed because there are instances that a case will be assigned to a different service rep than the default.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I have scoured the web and reviewed many examples but am still at a loss.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;In my research found something similar to the code I'm using in the cfc (below) to pull the a list of all service reps and compare to see if the rep id is the client's designated rep.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfset result[i+1][3]=true&amp;gt; is being populated correctly, however this does not carry over to my cfselect to indicate the item selected.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Is there a different way I need to go about this?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Please ask if I'm not being clear in what I need this to do.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;THANKS in advance for any assistance!&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Code snippet:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cffunction name="getSvcReps" access="remote" returnType="array"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfargument name="clientId" type="any" required="yes"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfargument name="dsn" type="any" required="yes"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;!---defines variables---&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset var data=""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset var result=ArrayNew(2)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset var i=0&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfif not len(arguments.clientId)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset result[1][1]=""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset result[1][2]="Please select a Client---&amp;gt;"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfreturn result&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfelse&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfquery datasource="#arguments.dsn#" name="svcReps"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; SELECT&lt;/p&gt;&lt;p&gt;&amp;nbsp; service_rep_id&lt;/p&gt;&lt;p&gt;&amp;nbsp; ,CONCAT(first," ",last) as svc_rep_name&lt;/p&gt;&lt;p&gt;&amp;nbsp; FROM&lt;/p&gt;&lt;p&gt;&amp;nbsp; svc_reps&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/cfquery&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfquery datasource="#arguments.dsn#" name="defaultSvcRep"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; SELECT&lt;/p&gt;&lt;p&gt;&amp;nbsp; rep_id&lt;/p&gt;&lt;p&gt;&amp;nbsp; FROM&lt;/p&gt;&lt;p&gt;&amp;nbsp; client_reps&lt;/p&gt;&lt;p&gt;&amp;nbsp; WERE&lt;/p&gt;&lt;p&gt;&amp;nbsp; client_id ='#arguments.clientId#'&lt;/p&gt;&lt;p&gt;&amp;nbsp; and rep_type="svc"&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/cfquery&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;!---convert results to array---&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset result[1][1]=""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset result[1][2]="Select a Service Representative---&amp;gt;"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset result[1][3]=""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfloop index="i" from = "1" to="#svcReps.recordCount#"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset result[i+1][1]=svcReps.service_rep_id[i]&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset result[i+1][2]=svcReps.svc_rep_name[i]&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfif svcReps.service_rep_id[i] EQ defaultSvcRep.rep_id&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset result[i+1][3]=true&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfelse&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset result[i+1][3]=""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/cfloop&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfreturn result&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;/cfif&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cffunction&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:bdb73d80-a69c-4170-b8d8-28eecebdfee8] --&gt;</description>
      <pubDate>Fri, 16 May 2014 22:51:17 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1476091</guid>
      <dc:date>2014-05-16T22:51:17Z</dc:date>
      <clearspace:dateToText>5 months 4 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cfmessagebox error whatever parameters</title>
      <link>https://forums.adobe.com/thread/1473717</link>
      <description>&lt;!-- [DocumentBodyStart:603d3084-97df-4287-9e16-49a502f62a78] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Whatever parameters are used in the CfmessageBox,&lt;/p&gt;&lt;p&gt;I get that error :&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;buttonType attribute is valid only for messagebox type "confirm".&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Running CF9.0&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Example code:&lt;/p&gt;&lt;p&gt;&amp;lt;cfmessagebox name="PopMessage"&lt;br/&gt;&amp;nbsp; callbackhandler="GrabUserInput"&lt;br/&gt;&amp;nbsp; labelok="Check info"&lt;br/&gt;&amp;nbsp; title="Warning!"&lt;br/&gt;&amp;nbsp; icon="warning"&lt;br/&gt;&amp;nbsp; type="alert"&lt;br/&gt;&amp;nbsp; message="This is a message box"/&amp;gt;&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&amp;lt;script type="text/javascript"&amp;gt;&lt;br/&gt;&amp;nbsp; ColdFusion.MessageBox.show('PopMessage');&lt;br/&gt;&amp;lt;/script&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks for help.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:603d3084-97df-4287-9e16-49a502f62a78] --&gt;</description>
      <pubDate>Tue, 13 May 2014 09:51:15 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1473717</guid>
      <dc:date>2014-05-13T09:51:15Z</dc:date>
      <clearspace:dateToText>6 months 17 hours ago</clearspace:dateToText>
      <clearspace:messageCount>6</clearspace:messageCount>
      <clearspace:replyCount>5</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>CF11 cfgrid with binding.</title>
      <link>https://forums.adobe.com/thread/1471349</link>
      <description>&lt;!-- [DocumentBodyStart:c0aa8739-b3eb-4677-9ceb-ebf985f365cd] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;CF11 cfgrid with binding not work like with CF10.&amp;nbsp; Example&lt;/p&gt;&lt;table&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td style=";"&gt;&lt;/td&gt;&lt;td style=";"&gt;bind="cfc:focasaDBAccess.getInfo({cfgridpage},&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td style=";"&gt;&lt;/td&gt;&lt;td style=";"&gt;{cfgridpagesize},&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td style=";"&gt;&lt;/td&gt;&lt;td style=";"&gt;{cfgridsortcolumn},&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td style=";"&gt;&lt;/td&gt;&lt;td style=";"&gt;{cfgridsortdirection},&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td style=";"&gt;&lt;/td&gt;&lt;td style=";"&gt;{internet},{agentur})"&amp;gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;This dont work. Only with one additional arguments. Either "internet" or "agentur". With CF10 this work with much more additional arguments.&lt;/p&gt;&lt;p&gt;Thanks&lt;/p&gt;&lt;p&gt;Detlef&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;how does cf11 cfgrid binding works with additional arguments&lt;/p&gt;&lt;p&gt;at least eight or more.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks for support&lt;/p&gt;&lt;p&gt;Detlef&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:c0aa8739-b3eb-4677-9ceb-ebf985f365cd] --&gt;</description>
      <pubDate>Sat, 10 May 2014 12:36:45 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1471349</guid>
      <dc:date>2014-05-10T12:36:45Z</dc:date>
      <clearspace:dateToText>6 months 22 hours ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>How to capture the reconfigure event on ajax grid?</title>
      <link>https://forums.adobe.com/thread/1473037</link>
      <description>&lt;!-- [DocumentBodyStart:d588695b-eb13-4fcd-8b23-3ea6677d6baa] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;In CF9 i have a cfgrid bound to a hidden field and a cfc query component.&lt;/p&gt;&lt;p&gt;Then i have a select box where the onChange() event triggers a js function which updates the hidden field with the select value and triggers the cfc, populating the grid with new data.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;In this js function, i'm trying to add an event that would trigger a chunk of code when the grid is refreshed, like:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;function myFunc(val) {&lt;/p&gt;&lt;p&gt;&amp;nbsp; document.getElementById('myHiddenField').value=val;&lt;/p&gt;&lt;p&gt; ColdFusion.Grid.refresh('myGrid',true);&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp; var grid = ColdFusion.Grid.getGridObject('myGrid');&lt;/p&gt;&lt;p&gt;&amp;nbsp; grid.addEvents('reconfigure'); &lt;/p&gt;&lt;p&gt;&amp;nbsp; grid.on('reconfigure',function(){ &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; alert("Grid changed!");&lt;/p&gt;&lt;p&gt;&amp;nbsp; });&lt;/p&gt;&lt;p&gt;}&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I don't get an error but the function never executes, don't get the alert. If i change the event to something that happens AFTER the grid gets refreshed, like grid.addEvents('click') it works fine. What am I missing?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:d588695b-eb13-4fcd-8b23-3ea6677d6baa] --&gt;</description>
      <pubDate>Mon, 12 May 2014 16:02:57 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1473037</guid>
      <dc:date>2014-05-12T16:02:57Z</dc:date>
      <clearspace:dateToText>6 months 3 days ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Crosstab - array error</title>
      <link>https://forums.adobe.com/thread/1468595</link>
      <description>&lt;!-- [DocumentBodyStart:1ff87223-9e92-448e-adb3-ec37c24f3feb] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt; get the following error with my code below. Please Help.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Table will be rows = dscgrd, columns = dsckcrse, rows x cols = count of dsckextid.&amp;nbsp; All grouped by teacher_anumber.&lt;/p&gt;&lt;p&gt;&lt;span style="color: black;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/p&gt;&lt;table border="0" cellpadding="0" cellspacing="0" style="WIDTH: 500px;"&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td align="left" style="border:0px solid black;" width="500"&gt;&lt;h1 style="color: black;"&gt;0 is not greater than zero or less than or equal to 0. &lt;/h1&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan="2" style="border:0px solid black;" width="400"&gt;&lt;span style="color: black;"&gt;The range passed to ArraySet must begin with a number greater than zero and less than or equal to the second number. &lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td style="border:0px solid black;"&gt; &lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan="2" style="border:0px solid black;" width="400"&gt;&lt;span style="color: black;"&gt;The error occurred in &lt;strong&gt;C:/ColdFusion10/cfusion/wwwroot/CFIDE/groups/crosstabs.cfm: line 41&lt;/strong&gt;&lt;br/&gt;&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan="2" style="border:0px solid black;"&gt;&lt;pre class="jive-pre"&gt;39 :&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; GROUP="dscgrd"&amp;gt;&amp;nbsp; 40 :&amp;nbsp; &amp;lt;tr&amp;gt;&amp;lt;th&amp;gt;#dscgrd#&amp;lt;/th&amp;gt;&amp;nbsp; &lt;strong&gt;41 : &amp;lt;CFSET temp = ArraySet(course_idarray, 0, b, "N/A")&amp;gt; &lt;/strong&gt;&amp;nbsp; &lt;/pre&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;CFQUERY NAME="crosstabquery" DATASOURCE="LIISthinkgate"&amp;gt;&lt;br/&gt;&amp;nbsp; SELECT&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; teacher_anumber, dsckcrse, dsckextid, dscgrd&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; evaluationstudentcourse&lt;br/&gt;&amp;nbsp; ORDER BY&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; dscgrd, dsckcrse&lt;br/&gt;&amp;lt;/CFQUERY&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;CFQUERY NAME="crosstabcolumns" DBTYPE="query"&amp;gt;&lt;br/&gt;&amp;nbsp; SELECT distinct&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; dsckcrse&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; FROM&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; crosstabquery&lt;br/&gt;&amp;nbsp; ORDER BY&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; dsckcrse&lt;br/&gt;&amp;lt;/CFQUERY&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;CFSET course_idlist = ValueList(crosstabcolumns.dsckcrse)&amp;gt;&lt;br/&gt;&amp;lt;CFSET course_idheaders = ListToArray(course_idlist)&amp;gt;&lt;br/&gt;&amp;lt;CFSET b = ArrayLen(course_idheaders)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;CFSET course_idarray = ArrayNew(1)&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;------------------------------------------------------------&lt;br/&gt;&amp;lt;table&amp;gt;&lt;br/&gt;&amp;lt;CFOUTPUT QUERY="crosstabquery" &lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; GROUP="dscgrd"&amp;gt;&lt;br/&gt; &amp;lt;tr&amp;gt;&amp;lt;th&amp;gt;#dscgrd#&amp;lt;/th&amp;gt;&lt;br/&gt; &amp;lt;CFSET temp = ArraySet(course_idarray, 0, b, "N/A")&amp;gt; &lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br/&gt; &amp;lt;CFOUTPUT&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp; &amp;lt;CFSET i = ListFind(course_idlist&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; , crosstabquery.dsckcrse)&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp; &amp;lt;CFSET temp = ArraySet(course_idarray, i, i, crosstabquery.dsckcrse)&amp;gt;&lt;br/&gt; &amp;lt;/CFOUTPUT&amp;gt;&lt;br/&gt; &amp;lt;CFSET rowtotal=0&amp;gt;&lt;br/&gt; &amp;lt;CFLOOP index="j" FROM="1" TO="#b#"&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp; &amp;lt;td&amp;gt;#course_idarray[j]#&amp;lt;/td&amp;gt;&lt;br/&gt;&amp;nbsp;&amp;nbsp; &amp;lt;CFSET rowtotal=rowtotal+course_idarray[j]&amp;gt;&lt;br/&gt; &amp;lt;/CFLOOP&amp;gt;&lt;br/&gt; &amp;lt;td&amp;gt;#rowtotal#&amp;lt;/td&amp;gt;&lt;br/&gt; &amp;lt;/tr&amp;gt;&lt;br/&gt;&amp;lt;/CFOUTPUT&amp;gt;&lt;br/&gt;&amp;lt;/table&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:1ff87223-9e92-448e-adb3-ec37c24f3feb] --&gt;</description>
      <pubDate>Wed, 07 May 2014 14:24:50 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1468595</guid>
      <dc:date>2014-05-07T14:24:50Z</dc:date>
      <clearspace:dateToText>6 months 3 days ago</clearspace:dateToText>
      <clearspace:messageCount>6</clearspace:messageCount>
      <clearspace:replyCount>5</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>How To Re-Compile ONE Component in Real-Time Without CF Restart?</title>
      <link>https://forums.adobe.com/thread/1468937</link>
      <description>&lt;!-- [DocumentBodyStart:ff78a71d-0e4b-40ee-89e1-5b483a7063f1] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Is there a way?&amp;nbsp; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I've seen tricks for restarting the application, but I suspect this still kills all active sessions, and we have quite a few going on.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I just have one CFC I need to recompile to get some changes in place, but I don't want to upset the entire apple cart.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Is there a way?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;RLS&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:ff78a71d-0e4b-40ee-89e1-5b483a7063f1] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">component...</category>
      <pubDate>Wed, 07 May 2014 20:11:20 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1468937</guid>
      <dc:date>2014-05-07T20:11:20Z</dc:date>
      <clearspace:dateToText>6 months 6 days ago</clearspace:dateToText>
      <clearspace:messageCount>10</clearspace:messageCount>
      <clearspace:replyCount>9</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cflayout tabs not working</title>
      <link>https://forums.adobe.com/thread/135564</link>
      <description>&lt;!-- [DocumentBodyStart:ba5ff19c-a9d8-4dec-8010-1730dbfdfa84] --&gt;&lt;div class="jive-rendered-content"&gt;On my production server and on my dev server at home I am
able to use cflayout with tabs.
&lt;br/&gt;
&lt;br/&gt;However, on my dev server at work... I can not make this
work. When I view the source code after the page renders... it
shows all the code that CF inserts (javascript and divs) but when
viewing the page, CF shows the all the content under each tab in
consecutive order without tabs. 
&lt;br/&gt;
&lt;br/&gt;I then tried other features of the cflayout tag using the
examples from the live docs and still nothing is working.
&lt;br/&gt;
&lt;br/&gt;Help?!?
&lt;br/&gt;
&lt;br/&gt;P.S. I just tested this under firefox and while I had the
Error console open, the browser reported a javascript error that
"Coldfusion" is not defined.&lt;/div&gt;&lt;!-- [DocumentBodyEnd:ba5ff19c-a9d8-4dec-8010-1730dbfdfa84] --&gt;</description>
      <pubDate>Tue, 11 Dec 2007 16:46:18 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/135564</guid>
      <dc:date>2007-12-11T16:46:18Z</dc:date>
      <clearspace:dateToText>6 months 1 week ago</clearspace:dateToText>
      <clearspace:messageCount>3</clearspace:messageCount>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Need ideas for page refresh</title>
      <link>https://forums.adobe.com/thread/1456022</link>
      <description>&lt;!-- [DocumentBodyStart:3f824c5a-bccc-4aa2-8e33-56800ebb2e29] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have an application that I have built that scans in a drivers license and OCR's the data, archives the image etc. I have the coldfusion page set up so it refreshes every couple of seconds. When the ID is scanned with the scanner and the query row is generated I output all of the scanned data and image to the page. Everything is working great with all that. I have a small little issue though.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Since the initial page is refreshing every few seconds waiting for the scan to happen that means that the drop down nav links in the header are refreshing too. There is a reports menu in the navigation that has around 10 links in a drop down for different types of reports. If someone drops it down and is taking time looking at the report names the page will refresh and the menu closes. &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Once the ID is scanned it no longer refreshes every couple of seconds, I disable it. So its only an issue until the ID is scanned.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Any ideas for a way to refresh the page looking for a query recordcount to be &amp;gt;= 1 but not refresh the header?&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:3f824c5a-bccc-4aa2-8e33-56800ebb2e29] --&gt;</description>
      <pubDate>Tue, 22 Apr 2014 11:36:54 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1456022</guid>
      <dc:date>2014-04-22T11:36:54Z</dc:date>
      <clearspace:dateToText>6 months 2 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>4</clearspace:messageCount>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cfform flash not getting recognized</title>
      <link>https://forums.adobe.com/thread/1462054</link>
      <description>&lt;!-- [DocumentBodyStart:c020f1f8-4069-4384-be66-ec2dd2936141] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi,&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Our server recently had a migration. The previous server contained cf7 and new one has cf10. After the migration, one of our application using cfform format flash is not working now. A 'mxml.cfswf' file seems to be not rendering correctly while inspecting the console. &lt;br/&gt;Is there any prerequisite for the cfform flash to get worked in cf 10?&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Any help is appreciated.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:c020f1f8-4069-4384-be66-ec2dd2936141] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">cfform</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">flash_player_not_being_recognized</category>
      <pubDate>Tue, 29 Apr 2014 18:43:57 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1462054</guid>
      <dc:date>2014-04-29T18:43:57Z</dc:date>
      <clearspace:dateToText>6 months 2 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>1</clearspace:messageCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>How get unique option fileds in a dynamic dropdown box</title>
      <link>https://forums.adobe.com/thread/1455987</link>
      <description>&lt;!-- [DocumentBodyStart:11dd745b-82ea-4469-9cde-0ddd51a2af4f] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I'm trying to get single select options in a dropdown menu.&lt;/p&gt;&lt;p&gt;The data is coming from two database.&lt;/p&gt;&lt;p&gt;My CFQuery looks like &lt;/p&gt;&lt;p&gt;&lt;br/&gt;&amp;lt;cfquery name="related" datasource="ISSUE"&amp;gt;&lt;br/&gt;SELECT sparprod&lt;br/&gt;FROM Related&lt;br/&gt;where Active = 'Yes'&lt;br/&gt;union all &lt;br/&gt;select sparprod from TBL_issue&lt;br/&gt;WHERE issue_number = &amp;lt;cfqueryparam value="#URL.issue_number#" cfsqltype="cf_sql_numeric"&amp;gt; &lt;br/&gt;ORDER BY sparprod ASC &lt;br/&gt;&amp;lt;/cfquery&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;td&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;select name="sparprod" id="sparprod" &amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfoutput query="related"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;option value="#related.sparprod#" &amp;lt;cfif (isDefined("rs_issue.sparprod") AND related.sparprod EQ rs_issue.sparprod)&amp;gt;selected="selected"&amp;lt;/cfif&amp;gt;&amp;gt;#related.sparprod#&amp;lt;/option&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfoutput&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/select&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;And the output in the dropdown box looks like &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;PRODUCTS&lt;/p&gt;&lt;p&gt;SPARES&lt;/p&gt;&lt;p&gt;SPARES&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;HOW can i have only ONE TIME Spares.&lt;/p&gt;&lt;p&gt;I've got this problem with all my dynamic dropdown boxes.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks&lt;/p&gt;&lt;p&gt;For your help in advance&lt;/p&gt;&lt;p&gt;Klaas&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:11dd745b-82ea-4469-9cde-0ddd51a2af4f] --&gt;</description>
      <pubDate>Tue, 22 Apr 2014 12:18:42 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1455987</guid>
      <dc:date>2014-04-22T12:18:42Z</dc:date>
      <clearspace:dateToText>6 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Detect Flash using CF8</title>
      <link>https://forums.adobe.com/thread/1451742</link>
      <description>&lt;!-- [DocumentBodyStart:b6ffc25e-9398-4214-b465-86301e5ffc91] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I need to detect whether a browser has flash installed and active, and if not I will switch to an alternative set of code.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Can anybody tell me how I can test for an active flash installation? (on CF8)&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Thanks&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Mark&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:b6ffc25e-9398-4214-b465-86301e5ffc91] --&gt;</description>
      <pubDate>Wed, 16 Apr 2014 11:03:14 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1451742</guid>
      <dc:date>2014-04-16T11:03:14Z</dc:date>
      <clearspace:dateToText>6 months 3 weeks ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>What is script syntax for passing form to REST?</title>
      <link>https://forums.adobe.com/thread/1447486</link>
      <description>&lt;!-- [DocumentBodyStart:f6f06712-0395-4755-9d0a-14db93cae7b4] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I'm lost. I am attempting to pass a FORMFIELD-parameter via the DELETE-method to a REST-function using script language. &lt;/p&gt;&lt;p&gt;I want to delete a resource. I get "Method not allowed", only "GET,OPTIONS,HEAD", so the DELETE-method is not understood. &lt;/p&gt;&lt;p&gt;&lt;br/&gt;I would apprechiate any meaningful input.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;---------(service call)-------------&lt;/p&gt;&lt;p&gt;form.CategoryIDDelete = "X,Y,Z"&lt;/p&gt;&lt;p&gt;httpSvc = new http(); &lt;br/&gt;httpSvc.setMethod("DELETE"); &lt;br/&gt;httpSvc.setCharset("utf-8");&lt;br/&gt;httpSvc.addParam(type="formfield", name="CategoryIDDelete", value="#FORM.CategoryIDDelete#"); &lt;br/&gt;httpSvc.setUrl("&lt;a class="jive-link-external-small" href="http://data.myDomain.net/rest/restService/categories" rel="nofollow"&gt;http://data.myDomain.net/rest/restService/categories&lt;/a&gt;");&amp;nbsp; &lt;br/&gt;res = httpSvc.send().getPrefix();&lt;br/&gt;writeDump(res);&lt;br/&gt;writeDump(FORM);&lt;/p&gt;&lt;p&gt;------------------------------------&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;...calls the rest service function in the registred REST component. &lt;br/&gt;Here I call CategoryIDDelete "catIDs".&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;---------(service function)---------&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;remote Array function delCategory(string catIDs restArgSource="FORM") httpMethod="DELETE" restpath="{catIDs}" produces="application/json" { &lt;br/&gt;&amp;nbsp; &lt;br/&gt;&amp;nbsp; var resp = [];&lt;/p&gt;&lt;p&gt;&amp;nbsp; if (len(catIDs) &amp;gt; 0) {&lt;br/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; ...&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&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;nbsp; }&lt;br/&gt;&amp;nbsp; return resp;&lt;br/&gt;&amp;nbsp; &lt;br/&gt;}&lt;/p&gt;&lt;p&gt;-------------------------------------&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I am uncertain about many things; restArgSource="FORM", restPath="{catIDs}", and why DELETE is not an allowed method.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:f6f06712-0395-4755-9d0a-14db93cae7b4] --&gt;</description>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">script</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">rest</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">delete-method</category>
      <category domain="https://forums.adobe.com/tags#/?containerType=14&amp;container=2225">formfield-parameter</category>
      <pubDate>Thu, 10 Apr 2014 19:22:14 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1447486</guid>
      <dc:date>2014-04-10T19:22:14Z</dc:date>
      <clearspace:dateToText>6 months 1 month ago</clearspace:dateToText>
      <clearspace:messageCount>3</clearspace:messageCount>
      <clearspace:replyCount>2</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Need help with auto suggest - Return multiple fields</title>
      <link>https://forums.adobe.com/thread/1446049</link>
      <description>&lt;!-- [DocumentBodyStart:cfca1599-32c5-4466-9633-464e8fd24ffa] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I am having a hard time getting my autosuggest to work. I have a cfinput where a person can type in a last name. I then want to return the full name and employee ID of the person and bind them to two different cfinputs. Here is my cfc:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfcomponent output="false"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;cffunction name="getPerson" access="remote" returntype="array"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;cfargument name="search" type="any" required="false" default=""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;!--- Define variables ---&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfset var data = ""&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset var result = ArrayNew(2)&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &amp;lt;cfset var i=0&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;!--- Query Location Table ---&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;cfquery name="data" datasource="ds" cachedwithin="#CreateTimeSpan(0,14,0,0)#"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;SELECT PERSONNEL.NAME_LAST_FIRST_MID, PERSONNEL.EMPLID, MST_LD.EMPLID&lt;/p&gt;&lt;p&gt;FROM MST_LD LEFT JOIN PERSONNEL ON MST_LD.SYREDU_SUID = PERSONNEL.EMPLID&lt;/p&gt;&lt;p&gt;WHERE ((MST_LD.PRIMARY_AFFIL_STATUS)= 'Active') AND ((MST_LD.EMPLID) Is Not Null)) AND PERSONNEL.NAME_LAST like &amp;lt;cfqueryparam cfsqltype="cf_sql_varchar" value="#ucase(arguments.search)#%" /&amp;gt; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;order by&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;name_last, name_first , EMPLID ASC&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/cfquery&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfloop index="i" from="1" to="#data.RecordCount#"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cftry&amp;gt; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfset result[i][1]=data.NAME_LAST_FIRST_MID[i]&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfset result[i][2]=data.EMPLID[i]&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfcatch&amp;gt;&amp;lt;/cfcatch&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cftry&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/cfloop&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;!--- And return it as a List ---&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;cfreturn result&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/cffunction&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfcomponent&amp;gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:cfca1599-32c5-4466-9633-464e8fd24ffa] --&gt;</description>
      <pubDate>Tue, 08 Apr 2014 15:06:31 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/1446049</guid>
      <dc:date>2014-04-08T15:06:31Z</dc:date>
      <clearspace:dateToText>7 months 6 days ago</clearspace:dateToText>
      <clearspace:messageCount>2</clearspace:messageCount>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Branch target offset too large for short</title>
      <link>https://forums.adobe.com/thread/236127</link>
      <description>&lt;!-- [DocumentBodyStart:9bbafaaa-032b-43a1-acc4-3765979abb21] --&gt;&lt;div class="jive-rendered-content"&gt;I havent used this component in about 2 months however when I
call any function from this component I recieve this error. "Branch
target offset too large for short" Ive searched and turned up
nothing. 
&lt;br/&gt;
&lt;br/&gt;I tested a really simple component that just returns the
argument sent to it even that threw this error. Im testing with CF7
on OS X using Jrun4. Ill include stack below, any help would be
awesome .
&lt;br/&gt;
&lt;br/&gt;------------------------stack-------------------------------
&lt;br/&gt;
&lt;br/&gt; Branch target offset too large for short
&lt;br/&gt; 
&lt;br/&gt;The error occurred in
/Applications/JRun4/servers/default/cfusion/BIGBLUE/v09/download/dlEngine.cfm:
line 5
&lt;br/&gt;
&lt;br/&gt;3 : &amp;lt;cfif isDefined('ind_#ii#')&amp;gt;
&lt;br/&gt;4 : &amp;lt;cfinvoke component="COM.xDownload" method="tester"
returnvariable="fixal3Ret"&amp;gt;
&lt;br/&gt;5 : &amp;lt;cfinvokeargument name="test" value="1"/&amp;gt;
&lt;br/&gt;6 : &amp;lt;/cfinvoke&amp;gt;
&lt;br/&gt;7 : &amp;lt;cfabort showerror="#fixal3Ret#"&amp;gt;
&lt;br/&gt;
&lt;br/&gt;Resources:
&lt;br/&gt;
&lt;br/&gt; * Check the ColdFusion documentation to verify that you are
using the correct syntax.
&lt;br/&gt; * Search the Knowledge Base to find a solution to your
problem.
&lt;br/&gt;
&lt;br/&gt;Browser Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O;
en-US; rv:1.8.0.3) Gecko/20060426 Firefox/1.5.0.3
&lt;br/&gt;Remote Address 192.168.100.86
&lt;br/&gt;Referrer 
&lt;a class="jive-link-external-small" href="http://192.168.100.86:8100/cfusion/BIGBLUE/v09/download/todays.cfm?mDir=%2FVolumes%2F192.168.100.16&amp;amp;textfield=&amp;amp;mDate=05%2F24%2F2006&amp;amp;mTotPer=6&amp;amp;mConstrain=1&amp;amp;mRecNum=10&amp;amp;imageField.x=60&amp;amp;imageField.y=12" rel="nofollow"&gt;http://192.168.100.86:8100/cfusion/BIGBLUE/v09/download/todays.cfm?mDir=%2FVolumes%2F192.1 68.100.16&amp;amp;textfield=&amp;amp;mDate=05%2F24%2F2006&amp;amp;mTotPer=6&amp;amp;mConstrain=1&amp;amp;mRecNum=10&amp;amp;imageField.x=6 0&amp;amp;imageField.y=12&lt;/a&gt;
&lt;br/&gt;Date/Time 24-May-06 06:54 AM
&lt;br/&gt;Stack Trace
&lt;br/&gt;at
cfdlEngine2ecfm322549419.runPage(/Applications/JRun4/servers/default/cfusion/BIGBLUE/v09/ download/dlEngine.cfm:5)
&lt;br/&gt;
&lt;br/&gt;org.apache.bcel.generic.ClassGenException: Branch target
offset too large for short
&lt;br/&gt; at
org.apache.bcel.generic.BranchInstruction.dump(BranchInstruction.java:99)
&lt;br/&gt; at
org.apache.bcel.generic.InstructionList.getByteCode(InstructionList.java:980)
&lt;br/&gt; at
org.apache.bcel.generic.MethodGen.getMethod(MethodGen.java:587)
&lt;br/&gt; at
coldfusion.bytecode.JavaAssembler.getBytes(JavaAssembler.java:369)
&lt;br/&gt; at
coldfusion.compiler.FunctionAssembler.assemble(FunctionAssembler.java:56)
&lt;br/&gt; at
coldfusion.compiler.TemplateAssembler.assembleFunctions(TemplateAssembler.java:255)
&lt;br/&gt; at
coldfusion.compiler.TemplateAssembler.assemble(TemplateAssembler.java:66)
&lt;br/&gt; at
coldfusion.compiler.NeoTranslator.translateJava(NeoTranslator.java:308)
&lt;br/&gt; at
coldfusion.compiler.NeoTranslator.translateJava(NeoTranslator.java:106)
&lt;br/&gt; at
coldfusion.runtime.TemplateClassLoader$1.fetch(TemplateClassLoader.java:282)
&lt;br/&gt; at coldfusion.util.LruCache.get(LruCache.java:188)
&lt;br/&gt; at
coldfusion.runtime.TemplateClassLoader$TemplateCache.fetchSerial(TemplateClassLoader.java :223)
&lt;br/&gt; at
coldfusion.util.AbstractCache.fetch(AbstractCache.java:58)
&lt;br/&gt; at coldfusion.util.SoftCache.get(SoftCache.java:81)
&lt;br/&gt; at
coldfusion.runtime.TemplateClassLoader.findClass(TemplateClassLoader.java:422)
&lt;br/&gt; at
coldfusion.runtime.RuntimeServiceImpl.getFile(RuntimeServiceImpl.java:662)
&lt;br/&gt; at
coldfusion.runtime.RuntimeServiceImpl.resolveTemplatePath(RuntimeServiceImpl.java:629)
&lt;br/&gt; at
coldfusion.runtime.TemplateProxyFactory.getResolvedFile(TemplateProxyFactory.java:509)
&lt;br/&gt; at
coldfusion.runtime.TemplateProxyFactory.resolveName(TemplateProxyFactory.java:617)
&lt;br/&gt; at
coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341)
&lt;br/&gt; at
cfdlEngine2ecfm322549419.runPage(/Applications/JRun4/servers/default/cfusion/BIGBLUE/v09/ download/dlEngine.cfm:5)
&lt;br/&gt; at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
&lt;br/&gt; at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
&lt;br/&gt; at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
&lt;br/&gt; at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
&lt;br/&gt; at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
&lt;br/&gt; at
coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27)
&lt;br/&gt; at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
&lt;br/&gt; at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
&lt;br/&gt; at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8)
&lt;br/&gt; at
coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
&lt;br/&gt; at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
&lt;br/&gt; at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
&lt;br/&gt; at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
&lt;br/&gt; at coldfusion.CfmServlet.service(CfmServlet.java:107)
&lt;br/&gt; at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
&lt;br/&gt; at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
&lt;br/&gt; at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
&lt;br/&gt; at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:259)
&lt;br/&gt; at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
&lt;br/&gt; at
jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
&lt;br/&gt; at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
&lt;br/&gt; at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
&lt;br/&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:9bbafaaa-032b-43a1-acc4-3765979abb21] --&gt;</description>
      <pubDate>Wed, 24 May 2006 11:57:47 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/236127</guid>
      <dc:date>2006-05-24T11:57:47Z</dc:date>
      <clearspace:dateToText>7 months 6 days ago</clearspace:dateToText>
      <clearspace:messageCount>4</clearspace:messageCount>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
  </channel>
</rss>

