Questions

Good morning everybody,I have a page containing a list of files (Excel in different format such as xls, xlsx and xlsm).To open it, I use different content type: (see code below)For the extension xls and xlsm, it work fine.for xlsx, I receive the following error:     "Excel cannot open the file 'xxx.xlsx' because the file format or file extension is not valid."I already search on internet https://forums.adobe.com/message/8911025#8911025 and tried without effect.I can open if I use the "cfcontent type='application/msexcel' " but I loose everything about Excel 2010.There is anyone which can help me?Thank you in advance for your supportBest regardsAndréthe code:<cfset FileName  = Replace(request.getXlsFile.Uploaded_File_Name, ' ', '_',"All") ><cfset extension = request.getXlsFile.template_ext ><cfoutput>        <cfheader name="Cache-Control" value="private">    <cfheader name="Content-Dispositi

Just did a clean install of El Capitan, need to reinstall everything.  Did a fresh install of CF2106 Developer Edition.  Install 100%, cf starts up, I see the Migration screen asking for a password, after that. I just see this error.The following information is meant for the website developer for debugging purposes.Error Occurred While Processing Request The error occurred in Application.cfm: line 530Called from Application.cfm: line 189Called from Application.cfm: line 176Called from Application.cfm: line 1-1 : Unable to display error's location in a CFML template. Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.Browser  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36Remote Address  ::1Referrer  http://localhost/CFIDE/Administrator/index.cfmDate/Time  22-May-17 05:51 PMStack Tra

Hi All,I was able to setup CF9 with SSL in the pass using this https://forums.adobe.com/thread/1330662Getting an error using Firefox 53.0.2 when I open my site https://localhost:9100/mySitelocalhost:9100 uses an invalid security certificate. The certificate is not trusted because it is self-signed. The certificate is not valid for the name localhost. Error code: SEC_ERROR_UNKNOWN_ISSUERAdding the exception doesn't fix the issue because I cannot use my site with https.Any ideas about this issue?BestJFB

After deploying cf11 update 12, in cf administration > Datasource when testing connexion, I get an error :SQLException while attempting to connect: java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read..Then I have replaced macromedia-drivers.jar in lib sub-directory with the one from CF11-update 6 and restarted coldfusion : problem has gone.I am running CF on a windows 2012 64 bit system and oracle database is also windows 2012 64bit.I had same issue with updates 8,9,10 and 11. Why is adobe not fixing such bug ? Should I use other dirver to access oracle database ?

We're using ColdFusion 2016 Update 4This problem was just brought to my attention by a user who probably has not used her application since Update 4 was applied.The application worked fine until reported to me on 5/19/17 our update was applied on 4 /25/17.I've attached screenshots at the bottom of this post.The workflow is the user enters a new event hits save - that's itBut now after the first save she has to go to edit mode and change the 00 to 17 and save again. The change sticks after the edit, but we need to find a fix for this.here is the code:        <cfform class="EMwrapper" name="MainForm" format="html">            <cfgrid name="gridEM"                    query="EM"                    format="

Path to the CFC I'm trying to instantiate is:/webroot/client/com.client.www/model/SomeComponentwhere "/webroot" is a ColdFusion mapping to the actual web root. I'm trying to make this work *without* having to create a mapping.I'm using CreateObject(). I can't use the dot-notation format (webroot.client.com.cllient.www.model.SomeComponent) because the directory name "com.client.www" would be interpreted as 3 levels deep which is wrong, it's one directory name. So, I'm using the path instead. However a path with a directory with a dot in the name appears to confuse ColdFusion. For example, this works:CreateObject("component", "/webroot/client/website/model/SomeComponent")but this does not:CreateObject("component", "/webroot/client/com.client.www/model/SomeComponent")Clearly the dots are causing some trouble. The reverse domain name format I've got here is a silly old thing that we're migrating away from, but in the mean time old projects have this format so we've got to deal with it.I've

Last night my System Admin performed a Windows Update on out Server 2012r2 machine that holds our ColdFusion Server.After the restart, the ColdFussion 11 Application Server service will not start.  All of our logs seem to be empty as well.  Could I get any assistance on this?ColdFusion has been fully updated.Thanks,John

I have come across an interesting issue and hopefully I'm not the only one with this scenario.  First the environment: 64-bit Windows Server 2008 (I found the same issue on SP2 and R2), ColdFusion 9.0.1 Enterprise edition, ColdFusion HotFix 1, IIS 7 (native mode), Sun Java 1.6.0_22, Microsoft SQL Server 2005 (on a different server).The issue that I have is I cannot get my datasource to verify.  ColdFusion returns this error:Connection verification failed for data source: clientsjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.Now here is what I have found so far.  I think I have finally narrowed this down to an issue with the Sandbox Security and the fact that we are using a database instance on our SQL server.  With the S

I have a vulnerability scanner that is showing our CF version as version 6. But I do not have version 6 installed.  it is actually version 2016.its saying its finding it herehttp://servername:8500/CFIDEany assistance, besides just forwarding me an 80 page document, would be appreciatedthank you!

I have 4 queries that have a date column. I need to output to a table sorted by date desc.But the dates that need to be sorted are from the 4 queries.Its not a good candidate for  UNION as each query has different columns, like thisQuery 1name - address -city -dateQuery 2col a- col b- DateQuery 3col d col E- DateQuery 4col d -col e- col f   - DateAnysuggestionss?

This is Venkat from Infrastructure Support and we are providing support for our client using Adobe ColdFusion platform. Our Client purchased the Adobe ColdFusion 10.0 Standard license under TLP Licensing Program and the support contract was ended on 24th March, 2014 and we would like to renew the support contract now. Could you please share the quote for renewing Adobe Support Contract  at the earliest and the ColdFusion licensing information as below,

Reason: Cannot complete operation becausee resource no longer exists.Opened a single CFC outside of a project to edit, error above ensued trying to add a bookmark. Same error when file was opened \\foo\bar\baz.cfc or z:\bar\baz.cfc

Greetings all -I'm hoping someone can help explain why this following attempt at binding a CFC is not working:1. I set up a CF Server Mapping to my cfc folder:Logical path = /testcfcPhysical path = E:\ColdFusion8\Components\testcfc2. I set up a virtual directory to my cfc folder:Virtual path: /testcfcPhysical path: E:\ColdFusion8\Components\testcfc3. If I use CFINVOKE to call the CFC, it works as expected.<cfinvoke component="testcfc.testRequests" method="get_Clients" returnvariable="var"><cfinvokeargument name="fiscal_year" value="#year(now())#"></cfinvoke><cfdump var="#var#">4. If I attempt to bind the CFC, I get the error "Error Invoke CFC /testResults.cfc: Not Found"<cfselect name="tstClientID" id="tstClientID" bind="cfc:testcfc.tstRequests.get_Clients('#year(now())#')" bindonload="true" value="client_id" display="client_name" />Debugging the error, I see that CF is attempting to find the CFC in the root directory of the app... it is disregarding the d

I plan to run the following two processes. In order to maintain data consistency I plan to use CFLOCK. I've never use CFLOCK in the past and not sure if this is going to work in maintaining data integrity. Please advise.   <cflock scope = "Session" timeout = "30" type = "Exclusive">                 <cfexecute name="SomeName" arguments ="#PathToFile#  #PathToLogfile#" errorFile="#PathToErrorFileLog#" outputFile="#PathToOutPutFileLog#"             timeout="300></cfexecute>                    <cfquery name="UpdateUserID">              Update TempTable              SET UserID = '#session.userid#'  

Hey Guys,We just had a PCI scan on one of our servers, and the following issue was returned:J2EE Misconfiguration: Insufficient Session ID LengthMy understanding is that the Session ID length is set in the underlying JVM for CF.Is there any solution to this?ThanksSteve

I saw a post about this a few years ago, but never an answer.We have some very old forms that use the hidden field type of server side validation to check required fields (_required).  The same forms on ColdFusion 10 return a correctly formatted validation error page.  The form under CF11 returns a page that shows the html tags.The form contains hidden fields like this: <input type="hidden" name="From_required" value="Name of person submitting request is required.">When a form is submitted with an empty field the page displayed looks like this: Form entries are incomplete or invalid.    <ul><li>Name of person submitting request is required. </li></ul> Go <a href="javascript:history.back()">back</a> and correct the problem. I know using this type of validation isn't good, but we need to get them over to CF11 as is for now.  I tried changing the form to a cfform, but got the same results.  I also changed the _requir

During install of CF11, the Web Configuration Tool does not create a "CFML" handler in IIS 7.5 for the main web site. Specifics: 1. Uninstalled CF10. 2. Installed CF11. 3. Got websites functional. Default web page set to "index.cfm". 4. Found main page errors when no page specified. i.e. (https://www.xxx.yyy/) , Error: 404.5 Page not found, cfhandler error. 5. Several attempts of Web config Tool, once for specific web sites and then for ALL web sites. 6. Each attempt left the "CFML" handler out of the configuration for the main site. 7. Finally, running tool for "All", and then in main site "Handler Mappings", click on "Revert to Parent" pops in the missing handler and all works well. 8. Add corrective process to CF11 install procedures.

If I need to get a date & time value for a SQL query for 5:00 PM yesterday, and 5 PM today how do I do thatI want to get all of the records between 5 PM yesterday and 5 PM todayselect *  from MYTABLE            WHERE  BATCH_DATE > (yesterday at 5PM ) AND   BATCH_DATE <  (todayat 5PM)  order by id desc

Is it possible to use TLSv 1.1 on Coldfusion MX 6.1? If so how can I do it?Any help would be appreciated.Thanks,Joe Klovance

I would like to add coding keyboard shortcuts, but can't find a place to add. For instance: I would like to add "cntrl+p" for "<p></p>" tags to match eclipse shortcut.  I see how to edit existing shortcuts, but not how to add.  Help would be appreciated. Thanks.

I have recently upgraded from ColdFusion 9 to ColdFusion 11. However in my websites in IIS the object handlers still point to ColdFusion 9. I during the installation of CF 11 used the wsconfig and there are no error messages in the log files. I can find no documentation on how to point the Object Handlers to Cold Fusion 11. Can anyone help?Thank you in advance!

Greetings,After applying update 12 to CF11 enterprise server, our users reported strange behavior on cfinput   type='datefield' .in Google Chrome. Looks like conflict with Google Chrome type[date] that shows Chrome calendar.No problem with Firefox or IE.Would be nice if Adobe support look into that issue.I checked the page source for cfinput tag type='datefield' in Google ChromeThis is before update 12<div  style="float:left;">   <input name="NewsExpirationDate" id="NewsExpirationDate"  type="datefield" value="04/27/2017" class="datefieldinput DateClass edit"  placeholder="mm/dd/yyyy"  />     </div><div  id="NewsExpirationDateSystemSetupForm_cf_buttondiv" style="float:left;padding:3px;">      <img id="NewsExpirationDateSystemSetupForm_cf_button" src="/CFIDE/scripts/ajax/resources/cf/images/DateChooser.png" alt='Date Picker' />        </

Debugging error output isn't restricted to the IPs specified to receive debugging output in certain cases.This is an issue that has been around since at least ColdFusion 9, as far as I know.Within CFAdmin, we have disabled the global error template (/CFIDE/administrator/templates/secure_profile_error.cfm) in order to enable error debug output for our debugging-enabled IPs.  The problem is that the template that dumps out error information is loaded and processed regardless of whether or not the user's IP is in the debugging IP list.  The "normal" way to get around this, as far as I know, is to specify an error template within your application.  For example, we do something along the lines of:<CFIF NOT isDevIP> <CFERROR TYPE="Exception" TEMPLATE="ErrorTemplate.cfm"> </CFIF>However, this doesn't catch everything.  Exceptions that occur prior to the <CFERROR> tag being processed will still result in all users seeing the debugging error output re

I can´t download Coldfusion 2016 from the Adobe website.I found the right page. I fill out the info form. I select linux 64 version. I press download. A broken link page is displayed.I see someone else posted the same problem 2 months ago but there has been no reply.Any help, please?Bob

My Boss is really pissed off at me. Without knowledge I have advise my boss to purchase ColdFusion Standard License but we really needed ColdFusion Enterprise License.Is there a way we can refund and get ColdFusion Enterprise License?