ColdFusion

Hello, all,I've got a weird glitch using SpreadsheetAddFreezePane() that I've never seen before.  I'm attaching two screencaps.I am attempting to freeze the top two rows, and columns A through M.The first issue is to the right of column M you can see the content of columns C and D.  If I scroll to the right, it disappears.The second issue is that if I scroll down then up, then the row numbers and the first two rows partially disappear.The code is for a second sheet that is added, after the Excel object has been created and the first sheet populated.SpreadsheetAddFreezePane(sObj,13,2);I'm really confuzzed on this one.  Any thoughts?(BTW.. small family emergency just popped up, and I will be leaving work in about an hour to go check on things, so I probably won't be able to answer any questions until tomorrow.)V/r,^ _ ^

Looking for any intel on known issues.- did not want to drag anyone into debugging for us but wanted to mention the item in case it strikes a chordThanks

Hello, all,I'm just playing around with something and wanted to see if I could insert an image into an Excel spreadsheet cell.  I found SpreadsheetAddImage(), and I'm not having any luck with it.  The image is a PNG file, 70 x 70 pixels in width and height.<cfscript>sObj = SpreadsheetNew("testing","true"); // This is for Excel 2013, not the older versions.SpreadsheetSetCellValue(sObj,'Testing Image Insert',1,1);SpreadsheetSetColumnWidth(sObj,1,75);SpreadsheetSetRowHeight(sObj,2,75);imgBytes = FileReadBinary("D:\site\images\emblem70x70.png");SpreadsheetAddImage(sObj, imgBytes, 'png', '2,1,2,1');<cfscript><cfheader name="Content-Disposition" value="attachment; filename=test.xlsx" /><cfheader name="Content-Type" value="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" /><cfcontent type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" variable="#spreadsheetReadBinary(sObj)#" reset="true" />When I open the spreadshe

We're in  the process of migrating from CF9 to CF2016 and are running into really slow compile times. The app startup takes twice as long as before but our real problem is that  we have a lot of dynamically generated CFML that gets written to the VFS (Virtual File System) and then included. This code, executed in a loop x 100 takes:CF9        = 1420 ms. CF2016  = 8643 ms. I have tried with Java 1.8.0_112 and 1.8.0_131 and the result is the same.Is there anything that we can do to speed up the compile time and is this a known issue with CF2016? Why was it so much faster on CF9? Any help would be hugely appreciated as our upgrade is now stalled due to this issue.

We have ColdFusion2016 Enterprise, originally installed in trial mode but now licensed.Its running Microsoft SQL server data sources no problem.I tested a JDBC data source against Microsoft SQL Server database no problem.But when I installed Seefusion 5 and tried to use their JDBC wrapper I get an error where the data source will not connect.Here is the stack trace below;A non-SQL error occurred while requesting a connection from test.Timed out trying to establish connectionDec 01, 2017 11:40:16 AM com.seefusion.Driver connectWARNING: Unable to connectmacromedia.jdbc.MacromediaDriver$InvalidLicenseException: Use of Adobe JDBC Drivers is restricted. Drivers can only be used with Adobe server products. Please check that your license supports the requested driver.    at macromedia.jdbc.MacromediaDriver.unlock(Unknown Source)    at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)    at java.sql.DriverManager.getConnection(Unknown Source)

I've got the following function written in tag syntax:************<cffunction name="myQuery" returntype="query" output="false" access="remote" hint="run some query">   <cfargument name="someRequiredID" required="true" default="24">   <cfquery name="local.getThings">  SELECT ID, entry_title   FROM entries  WHERE blogID = <cfqueryparam value="#ARGUMENTS.blogid#"   cfsqltype="cf_sql_integer">    </cfquery>    <cfreturn local.getThings></cffunction>****************How can I rewrite this using script syntax?iecomponent  displayname="testQuery" {     // confusion starts here ??     // define method myQuery     public query function myQuery() {          //run some query          peopleQuery = new Query(sql="SELECT * FROM PEOPLE").

Hello,I'm learning ColdFusion (have a background in web development) and have created a simple test site in ColdFusion Builder 2016. I run my site using the built in server, the one built into ColdFusion Builder 2016, runs locally on port 8600. I am trying to add my own custom CSS file, and ColdFusion can't seem to find it, keeps giving me a 404. It's a very simple CSS file with a very simple link tag:<html>     <head>         <!-- Some code here... -->         <link rel="stylesheet" type="text/css" href="footer.css" />         <!-- Some more code here... -->     </head>     <!-- Rest of the code here... -->Very simple and straightforward, but for the life of me I can't get ColdFusion to find the CSS file. Does ColdFusion not serve static content? I noticed I get the

I am using windows server 2008 R2 and Coldfusion 9using.I am using oracle for the database.Sometimes the session of Coldfusion 9 and oracle will continue to remain,Is there a way to deal with it?

The license at http://wwwimages.adobe.com/content/dam/acom/en/legal/licenses-terms/pdf/ColdFusion-2016.pdf​ pointed me to Adobe - ColdFusion 10 for licensing questions, which simply says "Send a mail to adobecoldfusion@adobe.com for all the queries with respect to licensing".  However, when I sent a message to that address, I got a bounce saying that "adobecoldfusion wasn't found at adobe.com".  When I tried to open a ticket at Adobe ColdFusion Learn & Support, I got "If Adobe ColdFusion is owned by your company or organization, you won’t see it listed under your Adobe ID. Chat with Adobe Customer Care", but when I clicked "Chat with Adobe Customer Care", I got "Chat is currently unavailable. Please contact us during our business hours. If you receive this message during business hours, please try again" (it's currently 8:26 PST).  I guess community support is my only option .My question is about licensing for Docker.  My assumption is that we have Enterprise li

Curious where we would put suggestions on improving the portal experience?Yesterday, I noticed the ColdBox question in the discussion category so passed it along to Brad Wood via Twitter that he may know the answer.  He made a good suggestion that there could be a Twitter bot that sent out when these posts come in.  I know i subscribe to @CFOverflow which pushes Stack Overflow questions to Twitter.  I agree with Brad it would be good to have something similar in the portal.Reading through his thread, when he did answer the question, he noted that he wasn't being notified when there were new posts in the discussion.  I think that would also be a great feature to have put in because its easy to forget to come back to check for new posts.Thanks

So in the API manager I tried changing the API proxy port from 9100 to 443. Restarted the manger and it won't start. Log say 443 is already being used. My assumption would be IIS is using it. How do I get the public URL for the manager setup so you can call like so, notice there is no port in the URL.https://mydomain.com/myapiname/v1.0/resource IIS 10WIN SERV 2016

I am remediating some older ColdFusion code which uses an Oracle database. I have noticed many instances where a CFQueryParam has been implemented like this;<cfqueryparam cfsqltype="varchar2" value="#someStringVariable#" />Is this an undocumented CFSQL Type that I am unaware of?If not why doesn't this throw an error at run time?What validation of the data takes place if you enter an invalid CFSQLType?

Good morning CF friends,   Yesterday I finally debugged an ongoing issue that we had determined was an undocumented issue with the past hotfix for CF2016 - which we now know was not entirely true.   The issue was that every so often one of our 8 JVM instances in our CF Cluster would show an error for an application that was looking at the same code base for the same application.  The cfcatch error was for missing include template files that were working great after a reboot of the same instance and fine on the other instances.   What was discovered, is that during the last update (5) the ownership had been changed to root:root on the /opt/coldfusion2016/sec-apps-2/wwwroot/WEB-INF/cfclasses contents that were existing at the time on that single instance (default behavior when applying the update).  However, there were no indicators of what the problem actually was since during a reboot everything worked great again with no errors showing up in any

ColdFusion Builder 2016 on Windows 7 works with mapped drives. When setting up a ColdFusion Project and/or ColdFusion Server, the browse buttons can see the mapped drives and/or one can use UNC paths which are found. On Windows 10 Pro 64-bit this is not the case. No mapped drives can be viewed and UNC paths cannot be found.I have tried several versions of Java JRE with Eclipse Mars (4.6.2) and ColdFusion Builder 2016 plugin. And I have also tried the ColdFusion Builder 2016 stand-alone install.Is this a bug, or can someone tell me how to make this work?

Hi,We are looking for a solution to repeat the header on ALL pages of the PDF generated using <cfdocument> tag. Does CF 2016 have an option for doing that? We are currently using workarounds to get it working but would like to have a much cleaner solution.Thx

I am using ColdFusion 11 and have a page that creates a PDF using the cfdocument tag. Nested in the cfdocument tag is the following markup<cfdocumentitem type="header" evalAtPrint="false">    <cfif cfdocument.currentPageNumber GT 1>         <p>page header</p>    </cfif></cfdocumentitem>The problem I am experiencing is this header is showing up on page 1 when I only want the header to show up on pages greater than 1. Any insight you could provide would be appreciated....Thanks

Greetings!  After attending the ColdFusion Summit 2017, I was inspired to start using CFBuilder 2016.  Sadly, it appears that I cannot connect to any of our servers using mapped drives on my Windows 10 machine.  Any suggestions? Thanks...    Dan

What would you recommend for a SQL database managment system with Coldfusion?Assuming I am on a windows-based computer

At the Adobe ColdFusion Summit this year, we announced the launch of the new Community portal for ColdFusion developers.The ColdFusion community portal is a one stop portal for anything ColdFusion. Ask a question, post a blog, showcase your work, post your ColdFusion testimonial or even start a discussion. The Ask a question is linked to Adobe forums where a post will be made on your behalf on the Adobe forums.You accumulate points for every contribution you make to the community portal. You start as a newbie and move up the ladder based on the points you accumulate. For instance, if you reach the highest level, which is legend, you get incentives such as a free pass to Adobe ColdFusion Summit, including travel (within the US) and accommodation during the event.Start exploring and start sharing with your fellow developers from the ColdFusion community!

Hi, we are working with ColdFusion 10 and Oracle 12c Database, but when we are trying to connect with the database across CF, we have the following message:  java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-28040: No matching authentication protocolDoes anybody know how can we work with Oracle 12c? Is necessary an update to fix that? Thank you.

Hi,according to the EULA the standard edition license is good for up to 2 cores.We are planning to setup a server (Ubuntu 16.04) on Amazon AWS with a m4.xlarge instance, which is a 4 vCPU machine. Standard edition would be good enough for us (feature-wise), but can we run CF on this instance just using 2 cores, or will the installer fail? We don't want to use an instance from the marketplace, because enterprise edition is overkill and too expensive. Other option would be running on m4.large which comes with 2 vCPU, but we would like to have the 2 more vCPU for the system itself and not for CF.Best regards and thanks.Michael

Currently i use pd4ml API to generate the pdf. In pd4ml there is a feature to manipulate the header and footer. Base on tech do in java we can do the code like:PD4PageMark header = new PD4PageMark() {       public String getHtmlTemplate(int pageNumber) {            if ( pageNumber > 1 ) {                 return "<html><body>some document header stuff...";               } else {                 return "";               }           }       };  pd4ml.setPageHeader(header);currently I can call the object likepd4ml = createObject("java","org.zefer.pd4ml.

I am running ColdFusion 11 on Windows 10. My http://localhost pulls up my windows page but when I added cfm files to wwwroot it won't run anymore and I get this error code.I am simply using notepad and save my code files as cfm.Help me HTTP Error 404.3 - Not FoundThe page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.Most likely causes:It is possible that a handler mapping is missing. By default, the static file handler processes all content.The feature you are trying to use may not be installed.The appropriate MIME map is not enabled for the Web site or application. (Warning: Do not create a MIME map for content that users should not download, such as .ASPX pages or .config files.)If ASP.NET is not installed.Things you can try:In system.webServer/handlers:  Ensure that the expected handler for the current page is mapped.Pay extra attention to preconditions (for e

I have a need to patch an older version of ColdFusion.  There is a security bulletin for this issue https://www.adobe.com/support/security/bulletins/apsb09-09.html, but the download links for the hotfix and the new CFIDE.zip are broken.Does anyone know if these patches are still available somewhere?Broken links:https://www.adobe.com/support/security/bulletins/downloads/hf801-77218.jarhttps://www.adobe.com/support/security/bulletins/downloads/CFIDE.zip

I am using Cold Fusion MX7 on one of many application.After the migration from http to https, all the scheduled tasks shows below error while executing from scheduled task in cf administrator :There was an error running your scheduled Task, Reason for which scheduled tasks might fail include:>The URL is a redirection URL>The URL is protected by IIS NT Challenge/Response or Apache .htaccess password. The Username and Password text fields for editing a scheduled task are intended to support Basic Authentication Only.>The Domain Name lookup failed. Try using the IP address of the domain whenever possible.> The URL is a n SSL site, but the SSL port was specified incorrectly.>The web site is not responding.>The directory specified for published results does not exists.Below are the observations against above error points.*The URL saved in scheduled tasks have https protocols- hence its not a redirection URL.*The URL does not asks for any authentication.*Domain name is corr