<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:clearspace="http://www.jivesoftware.com/xmlns/jive/rss" version="2.0">
  <channel>
    <title>Adobe Community : All Content - All Communities</title>
    <link>https://forums.adobe.com/</link>
    <description>All Content in Adobe Community</description>
    <language>en</language>
    <pubDate>Fri, 13 Feb 2009 11:09:41 GMT</pubDate>
    <generator>Jive Engage 7.0.0.1  (http://jivesoftware.com/products/)</generator>
    <dc:date>2009-02-13T11:09:41Z</dc:date>
    <dc:language>en</dc:language>
    <item>
      <title>CFDatefield not working in FF</title>
      <link>https://forums.adobe.com/thread/204025</link>
      <description>&lt;!-- [DocumentBodyStart:19aa9aa3-5f84-4c22-8a4d-8be3524ea476] --&gt;&lt;div class="jive-rendered-content"&gt;This has never happened to me: something actually works in IE
and NOT in FF!
&lt;br/&gt;
&lt;br/&gt;Current version of FF is 3.06. The CFdatefield input does not
function in any Mozilla-based browser and throws a Javascript
error: Error: "_f is undefined"
&lt;br/&gt;"Source File: 
&lt;a class="jive-link-external-small" href="http://localhost:8500/CFIDE/scripts/ajax/package/cfcalendar.js" rel="nofollow"&gt;http://localhost:8500/CFIDE/scripts/ajax/package/cfcalendar.js"&lt;/a&gt;
&lt;br/&gt;
&lt;br/&gt;This points to a line in the JS:
&lt;br/&gt;
&lt;br/&gt;"ColdFusion.Calendar.setUpCalendar=function(_6,_7,_8,_9,_a,_b,_c){
&lt;br/&gt;var _d=ColdFusion.DOM.getElement(_6+_b+"_cf_button",_b);
&lt;br/&gt;var _e=ColdFusion.DOM.getElement(_6,_b);
&lt;br/&gt;var _f=null;
&lt;br/&gt;var _10=null;
&lt;br/&gt;if(_e.value!=""){
&lt;br/&gt;_f=_e.value;
&lt;br/&gt;_10=_f.split("/");
&lt;br/&gt;}
&lt;br/&gt;"
&lt;br/&gt;Where the last two lines seem to have a problem.
&lt;br/&gt;
&lt;br/&gt;Can anyone help? This appears to be either a new issue (with
a new release of FF maybe) or it's a local issue with my code
(everything is possible I guess :).
&lt;br/&gt;
&lt;br/&gt;Robert
&lt;br/&gt;
&lt;br/&gt;
&lt;br/&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:19aa9aa3-5f84-4c22-8a4d-8be3524ea476] --&gt;&lt;img src='/beacon?t=1415919972116' /&gt;</description>
      <pubDate>Fri, 13 Feb 2009 11:09:41 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/204025</guid>
      <dc:date>2009-02-13T11:09:41Z</dc:date>
      <clearspace:dateToText>1 year 6 months ago</clearspace:dateToText>
      <clearspace:replyCount>27</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Diagnostics: 10 null The error occurred on line</title>
      <link>https://forums.adobe.com/thread/732353</link>
      <description>&lt;!-- [DocumentBodyStart:4007feae-e253-4af0-8a24-ead8386edcba] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi All,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I am using error catching on a site and it sends me errors when they occur while showing visitors a friendly error.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Recently, I am getting hundreds of errors from different locations of the site that all have one thing in common:&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;"Diagnostics:&lt;br/&gt;10 null &lt;br/&gt;&lt;div class="im"&gt;The error occurred on line 240."&lt;/div&gt;&lt;div class="im"&gt; &lt;/div&gt;&lt;div class="im"&gt;The line number is always different but the diagnostics code is the same. I have read multiple posts on the 'null null' error but that doesn't seem to address this particular 'null' error.&lt;/div&gt;&lt;div class="im"&gt; &lt;/div&gt;&lt;div class="im"&gt;I can't repeat this behavior myself as I go to the site, I don't get the error but visitors have been mentioning it and I am getting way more error emails than usual.&lt;/div&gt;&lt;div class="im"&gt; &lt;/div&gt;&lt;div class="im"&gt;My hunch is it has something to do with the server (memory, speed or something like that).&lt;/div&gt;&lt;div class="im"&gt; &lt;/div&gt;&lt;div class="im"&gt;Can anybody help?&lt;/div&gt;&lt;div class="im"&gt; &lt;/div&gt;&lt;div class="im"&gt;Robert&lt;/div&gt;&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:4007feae-e253-4af0-8a24-ead8386edcba] --&gt;</description>
      <pubDate>Fri, 01 Oct 2010 12:13:15 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/732353</guid>
      <dc:date>2010-10-01T12:13:15Z</dc:date>
      <clearspace:dateToText>4 years 1 month ago</clearspace:dateToText>
      <clearspace:replyCount>5</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>cfajaxproxy callback doesn't work! HELP!</title>
      <link>https://forums.adobe.com/thread/511306</link>
      <description>&lt;!-- [DocumentBodyStart:c3e5912d-add6-4157-8e0d-f809f328b71c] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I have created an application which uses the CFAJAXPROXY tag extensively to call functions through Javascript. Everything works fine on my local machine (Vista, CF8,all browsers).&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;When I upload the files to the server, the CallBackhandler function stops working. Using the CFDEBUG window I can see that the call to the CFC is actually made AND it returns the desired result... yet, it doesn't do anything with the result. It just does nothing!&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The Callbackhandler(s) refresh the page elements (such as CFDIVS and CFLAYOUTS) in order to show the updated data. It just doesn't work!&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;There is no error but there are several warnings in the Error Console in FF that state stuff like:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;"Warning: reference to undefined property o.stopPropagation&lt;/p&gt;&lt;p&gt;&lt;span&gt;Source File: &lt;/span&gt;&lt;a class="jive-link-external-small" href="http://xxx.xxx.xxx.xxx/CFIDE/scripts/ajax/ext/ext-core.js" rel="nofollow"&gt;http://xxx.xxx.xxx.xxx/CFIDE/scripts/ajax/ext/ext-core.js&lt;/a&gt;&lt;/p&gt;&lt;p&gt;Line: 17"&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I am guessing this has something to do with it but am not sure what and why.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I am also guessing that there may be an issue with the paths/mappings of the site that may cause the callbackfunction to lose track or something like that since the structure of the site IS different locally than it is on the server... however, when I call the templates directly (not through the root of the site) it still doesn't work.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I also tried to upload the entire CFIDE/scripts directory and try and point my &amp;lt;cfajaximport&amp;gt; tag to it, but that throws an error (which also doesn't make any sense):&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;&lt;span&gt;&lt;/span&gt;&amp;nbsp;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;h1&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Invalid usage of AJAX tag.&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/h1&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; &lt;span&gt;Use cfajaximport tag to specify SCRIPTSRC or make sure all ajax controls are inside a single cfform tag that has SCRIPTSRC.&lt;/span&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span&gt;The error occurred in&lt;strong&gt;C:\Inetpub\wwwroot\xxxx\xxx\conferencemgr.cfm: line 52&lt;/strong&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; &lt;/span&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;nbsp; &lt;/span&gt;&lt;pre&gt;50 : &amp;lt;!--- i


mport Ajax Tags ---&amp;gt;
51 : &amp;lt;!--- &amp;lt;cfajaximport&amp;nbsp; tags="cfform,cfinput-datefield,cfwindow,cfinput-autosuggest,cflayout-border, cflayout-tab, cfdiv"&amp;gt; ---&amp;gt;
&lt;strong&gt;52 : &amp;lt;cfajaximport scriptsrc="/js/cfide/scripts/"&amp;gt;&lt;/strong&gt;
53 : 
54 : 
&lt;/pre&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;So, although I think it is related to the JS files in the CFIDE directory and that for some reason it can't find the script for the callbackhandler function in the page, it just does nothing.&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;Maybe I am completely wrong and I don't want to steer anyone in the wrong direction so if you have any better ideas, please let me know.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I can't find any information about this issue anywhere (perhaps I have stumbled upon something unique!?). And, just to reiterate... everything works fine on my local server!&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 for any help!&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:c3e5912d-add6-4157-8e0d-f809f328b71c] --&gt;</description>
      <pubDate>Fri, 23 Oct 2009 11:19:45 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/511306</guid>
      <dc:date>2009-10-23T11:19:45Z</dc:date>
      <clearspace:dateToText>4 years 4 months ago</clearspace:dateToText>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>bound autosuggest only displays selective results?</title>
      <link>https://forums.adobe.com/thread/446655</link>
      <description>&lt;!-- [DocumentBodyStart:d9deee64-4491-47b0-b7ae-896e121583c3] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;I've been stumped by this issue and hope someone here can point me in the right direction:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I have a autosuggest field that is bound to a component. When I call the component directly, it works as intended... when I try and use the component through the binding, it doesn't give me the same results.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Here's the autosuggest code:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;p&gt;&amp;lt;cfform name="teamsform"&amp;gt;&lt;/p&gt;&lt;p&gt;Search for a team: &amp;lt;br&amp;gt;&lt;/p&gt;&lt;p&gt;Use team name, team id or any part of a team member's name.&amp;lt;br&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfinput autosuggest="cfc:/ofcomponents.teams.getteams({cfautosuggestvalue})" autosuggestminlength="2" type="text" name="userSearchTerm" size="50" typeahead="yes"&amp;gt;&amp;lt;br&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;input type="submit" value="Go"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfform&amp;gt;&lt;/p&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Here's the CFC:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;p&gt;&amp;lt;cfcomponent&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&lt;span&gt; &lt;/span&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cffunction name="getTeams" access="remote" returntype="string"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;span&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;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfargument name="usersearchterm" required="yes" type="string"&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;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfquery name="getTeams" datasource="#REQUEST.dsn#"&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; SELECT t.team_name as name&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; FROM of_users u left outer join of_teams t on u.of_user_id = t.user_id&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; WHERE 0 = 0&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;lt;cfif arguments.usersearchterm neq ""&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; and (t.team_name like '%#arguments.usersearchterm#%'&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; or t.team_id like&amp;nbsp; '%#arguments.usersearchterm#%')&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;lt;/cfif&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;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and u.user_type_id in (select user_type_id from of_user_types where user_type_description = 'team')&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; UNION&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; SELECT t.team_name as name&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; FROM of_users u, of_teams t, of_team_participants tp &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; WHERE u.of_user_id = tp.participant_id and t.of_team_id = tp.team_id&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;lt;cfif arguments.usersearchterm neq ""&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; and u.first_name like&amp;nbsp; '%#arguments.usersearchterm#%'&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; or u.last_name like&amp;nbsp; '%#arguments.usersearchterm#%'&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;lt;/cfif&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;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; and u.user_type_id = (select user_type_id from of_user_types where user_type_description = 'participant')&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;lt;/cfquery&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&lt;span&gt; &lt;/span&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;lt;!---&amp;nbsp; &amp;lt;cfdump var="#getteams#"&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;cfabort&amp;gt; ---&amp;gt;&lt;/p&gt;&lt;p&gt;&lt;span&gt; &lt;/span&gt;&amp;lt;cfset returnlist = valuelist(getTeams.name)&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; &lt;span&gt; &lt;/span&gt;&amp;lt;cfreturn returnlist&amp;gt;&lt;/p&gt;&lt;p&gt;&lt;span&gt; &lt;/span&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 style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;/cfcomponent&amp;gt;&lt;/p&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;As mentioned, when I call the component directly, like this:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;p&gt; &amp;lt;cfinvoke component="/ofComponents.teams" method="getTeams" returnvariable="varret"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &lt;span&gt; &lt;/span&gt;&amp;lt;cfinvokeargument name="usersearchterm" value="Logan"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp; &amp;lt;/cfinvoke&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;lt;cfdump var="#varret#"&amp;gt;&lt;/p&gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;It gives me the correct results (i.e. the Team name)&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;When I type the same term in the text field, I get no results. When I type in a team name, I only get a result when the team name starts with the search term I am typing. Any other search returns no results.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Can anyone see if I am doing something wrong or is there something else going on that I am not aware of?&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:d9deee64-4491-47b0-b7ae-896e121583c3] --&gt;</description>
      <pubDate>Thu, 11 Jun 2009 21:14:40 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/446655</guid>
      <dc:date>2009-06-11T21:14:40Z</dc:date>
      <clearspace:dateToText>5 years 4 months ago</clearspace:dateToText>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>CFC vs. Query performance</title>
      <link>https://forums.adobe.com/thread/166535</link>
      <description>&lt;!-- [DocumentBodyStart:db56cac8-cf31-4837-a214-62783209d1c7] --&gt;&lt;div class="jive-rendered-content"&gt;I created a discussion board. Each entry displays the
preferences of the user who posted the entry, such as 'Allow
Private Messages', 'Allow Emails' etc. When looping through the
entries, I have to query the database to get the preferences for
each individual 'poster'. Because I thought it would increase
performance, I created a CFC method and call the Object into the
session scope. Then I initiate the method when looping through the
results and setting a variable in the THIS scope in the instance to
the query result value.
&lt;br/&gt;
&lt;br/&gt;When comparing the two ways of doing it, there's a four-fold
increase in load time using the CFC, this doesn't seem right and I
suspect I am doing something wrong.
&lt;br/&gt;
&lt;br/&gt;Below are the two different approaches, maybe someone can
help me:
&lt;br/&gt;
&lt;br/&gt;Without CFC:
&lt;br/&gt;
&lt;br/&gt;&amp;lt;cfoutput query="results"&amp;gt;
&lt;br/&gt;&amp;lt;cfquery name=getPoster datasource="xxx"&amp;gt;
&lt;br/&gt;select first_name
&lt;br/&gt;from users
&lt;br/&gt;where user_id = #results.user_id#
&lt;br/&gt;&amp;lt;/cfquery&amp;gt;
&lt;br/&gt;&amp;lt;/cfoutput&amp;gt;
&lt;br/&gt;
&lt;br/&gt;
&lt;br/&gt;With a CFC:
&lt;br/&gt;
&lt;br/&gt;CFC Code:
&lt;br/&gt;&amp;lt;cfcomponent&amp;gt;
&lt;br/&gt;
&lt;br/&gt;&amp;lt;cfset THIS.user_data_id = 0&amp;gt;
&lt;br/&gt; &amp;lt;cffunction name="getPosterPrefs" access="public"
returntype="query"&amp;gt;
&lt;br/&gt; &amp;lt;cfargument name="user_data_id" required="yes"
type="numeric"&amp;gt;
&lt;br/&gt; 
&lt;br/&gt; &amp;lt;cfquery name="getposter" datasource="xxx"&amp;gt;
&lt;br/&gt; SELECT allow_pm, pm_ignore_list, show_email
&lt;br/&gt; FROM forum_user_data
&lt;br/&gt; WHERE user_data_id = #THIS.user_data_id#
&lt;br/&gt; &amp;lt;/cfquery&amp;gt;
&lt;br/&gt; 
&lt;br/&gt; &amp;lt;cfreturn getPMprefs1&amp;gt;
&lt;br/&gt; 
&lt;br/&gt; &amp;lt;/cffunction&amp;gt; 
&lt;br/&gt;
&lt;br/&gt;
&lt;br/&gt;&amp;lt;/cfcomponent&amp;gt;
&lt;br/&gt;
&lt;br/&gt;In the page:
&lt;br/&gt;
&lt;br/&gt;&amp;lt;cfif (not structKeyExists(session, "replyPrefs"))&amp;gt;
&lt;br/&gt; &amp;lt;cflock name="lock_replyPrefs" timeout="5"
type="exclusive"&amp;gt;
&lt;br/&gt; &amp;lt;cfobject component="/tvocomponents.forums"
name="session.replyPrefs"&amp;gt;
&lt;br/&gt; &amp;lt;/cflock&amp;gt;
&lt;br/&gt; &amp;lt;/cfif&amp;gt;
&lt;br/&gt;
&lt;br/&gt;&amp;lt;cfoutput query="results"&amp;gt;
&lt;br/&gt;&amp;lt;cfset session.replyPrefs.user_data_id =
#getReplyPoster.user_data_id#&amp;gt;
&lt;br/&gt;#message#
&lt;br/&gt;&amp;lt;cfif
#session.replyPrefs.getPosterPrefs(getReplies.thread_reply_user_id).allow_pm#
eq 1&amp;gt;Allow Private Messages&amp;lt;/cfif&amp;gt;
&lt;br/&gt;&amp;lt;/cfoutput&amp;gt;
&lt;br/&gt;
&lt;br/&gt;Thanks for any help.&lt;/div&gt;&lt;!-- [DocumentBodyEnd:db56cac8-cf31-4837-a214-62783209d1c7] --&gt;</description>
      <pubDate>Wed, 07 Mar 2007 18:37:01 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/thread/166535</guid>
      <dc:date>2007-03-07T18:37:01Z</dc:date>
      <clearspace:dateToText>7 years 8 months ago</clearspace:dateToText>
      <clearspace:replyCount>3</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
  </channel>
</rss>

