Questions

I have a question (actually two) about how caching works with cfquery so I can make sure that what I'm doing on our website makes sense. (We're on CF10)I have a database that stores certain details about each of the web pages on our site.  Contact ID, title, date added/updated, whether it's a recent or featured item, etc.  The unique identifier for each page is the path (/folder/subfolder/page.cfm).  Since out site is organized in several major topic areas, there's a column to identify which topic the page is in (and that's the same as the folder name that set of pages resides in).Some or topics get tons of hits, and some get very few, so I've been doing this: <cfquery name="getalltopics" datasource="dsn" cachedwithin="#createtimespan(0,1,0,0)#"> SELECT (columns I need FROM pages WHERE topic = <cfqueryparam value="#topicname#"  cfsqltype="cf_sql_varchar"> </cfquery> <cfquery name="getpagedetails" dbtype="query"> SELECT (columns I need) FROM

CF beginner.When transferring from flash to HTML format, is there a way to control attributes which are not accessible through tags (for example HSCROLL and WIDTH in CFTREE)? Seems like going modifying the Ext JS object is the only way (for example using ColdFusion.Grid.getGridObject) as described in CFML reference but this apparently only works for editable objects. Is this the correct approach? Are there other ways of doing this? staying with a non-HTML format is not an option and so any help is greatly appreciatedDisclaimer: just starting with CF and haven't had a chance to try these things in practice.

I have been trying numerous ways to install CFBuilder 3 Trial into Eclipse 4.2.2 on Mac (Yosemite) and just cannot get CFBuilder to load the CF Perspective. I have tried in various Eclipse versions, and in multiple orders including just installing CFBuilder Trial Edition without in a clean 4.2.2 Eclipse from clean CF install (plugin only, but tried also installing full CFBuilder app both before and after plugin installation, rebooting between each install) and new workspace. My ultimate goal is to also install Flash Builder 4.7 into the same Eclipse app, but am starting with CFBuilder since Flash Builder installs successfully. Note that this question is ONLY for the ColdFusion Builder 3 installation alone without Flash Builder installed on the machine.Bottom line: I just cannot get CFBuilder 3 to load into Eclipse 4.2.2 and show the CF Perspective even though it appears to be a successful plugin install; I am starting Eclipse either from both the plugin directory's shortcut and from th

We are not having any issues but other applications on the server need to work on SQL management 2008 or greater platform.  So we are trying to find out if we have to upgrade our CF 8 to a newer version or not.  Currently, our current setup is working fine.

I am trying to install both Flash Builder (FB) 4.7 and ColdFusion Builder (CFB) 3 into the same IDE and cannot seem to be able to do so successfully. The environment is Mac OSX Yosemite.I have tried installing CFB as a plugin into FB (can't, FB uses Eclipse 4.3), FB as a plugin into CFB (succeeds but FB does not show up as a perspective even though it seems to install successfully), and each as a plugin into Eclipse stand-alone 4.2.2 (last one installed does not show up). Now, my "uninstall" for CFB is hosed - hangs at 32% - i think some original paths written to the uninstall directories are no longer there or something.Is there a trick to getting FB and CFB 3 to work together on Mac Yosemite?

Getting an error on a CF 11 Enterpirse Server Administrator on Win2008 64bit when going to Server Update - UpdatesElement UPDATESETTINGS.UPDATESERVICE is undefined in a Java object of type class [Ljava.lang.String; referenced as '' The error occurred in index.cfm: line 103Called from index.cfm: line 52Called from index.cfm: line 51Called from index.cfm: line 1-1 : Unable to display error's location in a CFML template.  Also, in the top frame of the admin contol panel there are no resources|info|?| logout links and there is an error in the source code: 	at cftopnav2ecfm1029300467.runPage(/CFIDE/administrator/topnav.cfm:241)    <br />   <br />   <pre>java.lang.NullPointerExceptionat coldfusion.server.UpdateService.init(UpdateService.java:132)at coldfusion.server.UpdateService.<init>(UpdateService.java:123)at coldfusion.server.UpdateService.getInstance(UpdateSe

I'm using Mac (OS X 10.10.2 Yosemite) and the Apache with CF 11 for developing. After installing the new Apple Security Update 2015-003 ColdFusion stops working? What can I do? What are the reasons?

Currently we are using Coldfusion 9 standard edition for our web application. However recently we are facing performance issues where users are complaining that the system is very slow and they are not able to access at times. When checked we noted that as we have CF 9 standard edition, we do not have server monitoring feature available. Hence we are thinking of upgrading to Enterprise edition. Now here my question is - how many/what changes will be needed in code etc so that applications should be supported on Enterprise edition. Also what is the procedure to upgrade?Also any hints or pointers to find as what may be causing the slow system performance will be very helpful.ThanksHarshal

Hello, everyone,For almost a year, now, my team and I have been trying to get our CF servers to use the same updated Java as the OS server is using.For the most part, it's been pretty successful.  If we point the CFAdmin "Java and JVM" to the same updated/upgraded Java that the server is running, CF works.Except when it comes to Solr collections.Solr will work with Java 1.7 u21 or earlier; but nothing newer.  As I understand it, for security purposes Oracle started denying certain network permissions with Java 1.7 u25.  Those permissions are still denied through to the current Java 1.8 u40, and I'm pretty sure Oracle has no intention of reverting those permissions.  Apparently, Solr is relying upon these denied permissions.Does anyone know if Adobe and/or the Lucene team plans on addressing this issue?V/r,^_^

Whenever you load a tab dynamically with a cflayoutarea (tab) in Coldfusion 9 it won't get the height right (usually just does like 20px high). This will also happen when trying to reload a tab with coldfusion.navigate. I need to figure out how to access the underlying EXT or use coldfusion functions to get these tabs to redraw. As of now my only workaround is assigning a height to it, but that will create scrollbars instead of just correctly fitting the height as it should. Below is a example layoutarea:<cflayout type="tab"  style="padding:5px; width:940px;" name="ajaxTabs">     <cflayoutarea name="tab0" selected="#tab0#" style="padding:5px; min-height:450px;" overflow="auto" refreshonactivate="yes"                         title="<p id='n1'>Saved Newsletters</p>"          

Looking in coldfusion-error.logs I'm seeing a bunch of entries likeSEVERE: The web application [/] created a ThreadLocal with key of type [coldfusion.util.DateUtils$1] (value [coldfusion.util.DateUtils$1@6c59782f]) and a value of type [java.util.GregorianCalendar] (value [java.util.GregorianCalendar[time=1350663029000,areFieldsSet=true,areAllFieldsSet=true,lenient=false,zone=sun.util.calendar.ZoneInfo[id="America/Los_Angeles",offset=-28800000,dstSavings=3600000,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZone[id=America/Los_Angeles,offset=-28800000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2012,MONTH=9,WEEK_OF_YEAR=42,WEEK_OF_MONTH=3,DAY_OF_MONTH=19,DAY_OF_YEAR=293,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=3,AM_PM=0,HOUR=9,HOUR_OF_DAY=9,MINUTE=10,SECOND=2

I just migrated to windows 2012 and cf11.I'm trying to get IIS8 to show detailed error messages relating to CF errors.I've found a lot of documentation relating to cf10 and iis7... but it looks like it all leads to dead ends and doesnt work.Right now on any coldfusion 500 error, I am displaying:ERRORAn error occurred while executing the application. Please try again or contact the administrator.It would be great if I could show the CF error to help me troubleshoot the migration headaches a little faster.thankssteve

How to render the included style via the CFdocument to create a PDF ?Font size, family, color, backgound color are not rendered.Is there a special syntax to make it work ?My code is :I do a cfsavecontentand put the variable in the cfdocumentthe style is in the head of the html.Thanks for any help.Pierre.

I have been trying to get clustering going but sessions never work. In a virtual machine, I have CF11 Enterprise on Windows installed. The VM was copied from a staging environment that was previously setup following the common "CF Lockdown Guide", but I don't believe we're having an issue there.I have stripped the VM down to the basics and reverted many "lockdown" changes. The CF services are setup to run as an administrator. I have two websites in IIS - one basic index.cfm site that dumps instance name, and a full site that is dumping instance name, alongside having a login and much functionality. Three instances are setup in CF Admin - cfusion, Instance1, and Instance2. Instance1 and Instance2 are both part of a cluster, Cluster1.I have tried all combinations of "sticky sessions" and "session replication", reinstalling the CF Connectors (tried both globally and per-site) and Handler Mappings each setting update. Services were restarted after each change, as necessary.I have also trie

Hello,I  am encountering "[SQL0104] Token ; was not valid. Valid tokens: ). " error  , when  I  execute below statement.Using ; (semi colon) for  sql statements separation.Please  let me know , how  to fix  it.Thanks in advance.<cfquery name="qInsertTo" datasource="dsn">    <cfloop from="1" to="25" index="i">        insert into test1(userId,firstname) values('xx#i#','fname#i#') ;    </cfloop></cfquery>PS:  I  don't want to keep  cfloop outside  cfquery.

I an trying to create a revenue page,1st issue:Columns will have the days in the month - not sure how to do this without hard coding it in but would like to somehow dynamically populate this.The data will be pull from a database:https://bubbl.us/view/2788d1/5195a9/25F4oONgeDEtU&r=1719403621/2nd issue:How can i match the date entry in the database with the approriate column.There might be another way to do this which I'm open to, can't seem to wrap my head around this issue.Any input is appreciated.

Hi,  I want to be able to get the value of the CodeItem  from the getItem function to use for my second function getOpt.  But not sure how to do it, would you lend me a hand?- Thanks<cffunction name="getItem" access="remote" returntype="struct">    <cfargument name="wo" type="string" required="yes">      <cfsetvarqResult="" />       <cfsetvarresult = {} />        <cfqueryname="qResult">          SELECT * fromsaleorders         whereprodOrder= <cfqueryparamvalue="#arguments.wo#" cfsqltype="cf_sql_varchar"/>        </cfquery>                <cfsetresult = {CodeItem="#qResult.Code#",Description=#qResult.Description#} />   

I have a report that is generated through various JavaScript asynchronous requests. We are now required to produce a PDF, save it on the server and email that report to the user using Cold Fusion. When generating PDF, Cold Fusion makes an HTTP request for the page to be printed and waits for a 200 response.The problem is the 200 response is received before all the async requests are fulfilled. Apart from rewriting the report page entirely in ColdFusion, any ideas as to how to accomplish this? That is, wait for all the async requests to be fulfilled prior to generating a PDF to be saved and emailed.Thanks!

Your assistance is appreciated.  I am attempting to create a data source on server #1 that is to connect to a database residing on Server #2.  Thus far, each attempt made results in an error that the database "is already opened exclusively by another user, or you need permission to view its data."  Be advised that I am experienced in working with data sources when the database resides on the same server.

I have Acrobat Professional X. And I need to read a Microsoft Access Database. I don't have LiveCycle Form. Is there any way that I can connect to my database?

Coldfusion 11 does not display the ODBC driver that was created in Windows 7.Thanks,Tim

During a console install of CF 11 on CentOS 6.5, I'm getting this error:Invalid path to Apache binary (the file does not exist).Apache is installed via RPM.Apache: 2.4.3OS: CentOS 6.5 64bitPlease advise.

I have just done an install of CF 11 three times today and the password that is created during the install does not authenticate.  I have read several posts, some of which date back to May 2014.  Is there not a hotfix for this issue?  Certainly the recommendation for changing a browser is understood as I am using IE, but still what about the hotfix?

Hi,I'm using cfgrid cfgridcolumn to display data on a page.  Somehow the following code does not show the comma.  Cfgrid is in html format.<cfgridcolumn name="InletFlueGasFlow_acfm" numberformat="9,999,999" header="Inlet Flue Gas Flow ACFM"> tried also with type <cfgridcolumn name="InletFlueGasFlow_acfm"   type="numeric" numberformat="9,999,999" header="Inlet Flue Gas Flow ACFM"> What is a valid numberformat?  The Adobe documentation for cfgridcolumn says numberformat="format" 9 Optional digit placeholder. Same as _ but shows decimal places more clearly., Separates thousands with commas. Any idea why my comma not showing? Thanks.

Is onRequestEnd.cfm mandatory if Application.cfm is defined?