ColdFusion

Our ColdFusion 2016 Enterprise server (Windows Server 2012 R2) is not maintaining connections to an Azure Data Warehouse db. The first Azure query on a page takes a second or more to run. Subsequent Azure queries on the same page take a fraction of a second, e.g.:test1 (Datasource=azureDev, Time=3485ms, Records=1) in D:\DW\dwtest\CF2016\bob\azureAdhoc.cfm @ 12:10:12.012select count(*) cnt from dimpatient where name like 'smith%' and birthdate >'2014-02-01' test2 (Datasource=AzureDev, Time=125ms, Records=3) in D:\DW\dwtest\CF2016\bob\azureAdhoc.cfm @ 12:10:12.012select * from dbo.dimPatientMergeStatus test3 (Datasource=AzureDev, Time=172ms, Records=1) in D:\DW\dwtest\CF2016\bob\azureAdhoc.cfm @ 12:10:13.013select * from dbo.dimPatient where MedicalRecordNumber = '2000000' test4 (Datasource=azureDev, Time=281ms, Records=1) in D:\DW\dwtest\CF2016\bob\azureAdhoc.cfm @ 12:10:13.013select count(*) cnt from dimpatient where name like 'jones%' and birthdate >'2004-02-01' It seems apparen

I am trying to re setup my development server on my home computer (Windows 10) with Coldfusion 2016 after a hard-drive crash. I've set up numerous variations of Coldfusion over the past decade and have always been able to troubleshoot and get them to work.   With Coldfusion 2016 I have been trying for two days with no success.I have IIS setup on the server.I have Coldfusion 2016 installed with D:\ColdFusion2016 as the installation path.I created a new site in IIS, which is located in the folder  D:\Website\The site I added has virtual directories for CFIDE and JakartaI have copied "mysql-connector-java-5.1.45-bin" over to the ColdFusion2016/cfusion/lib folder. (started and stopped CF Server)I have opened IIS and clicked on the website name in the Application Pools, then selected "Enable 32-Bit Applications" under Advanced Settings...I am able to launch CFAdmin at:  http://127.0.0.1:8500/CFIDE/administrator/index.cfm But when I go to load my website in the browser I

We currently use AWS Marketplace for Coldfusion 2016. I want to put API manager on a separate server so how do I get a license file to register API Manager. We currently pay month for 3 Coldfusion Enterprise licenses.Thanks,Kane

I have cgi.path_info that is always formatted like this/data/show/80865How do I get the ALWAYS numeric value after show/ For example, in this case, I want to get the 80865 value.

I have enabled sandbox security for a site. I added the needed data sources and removed the <<ALL FILES>> in the Files/Dirs section and just added the file paths the site requires.  When visiting the site, I was getting the error:Error Executing Database Query.access denied (""java.io.FilePermission"" ""[my cf root]\cfusion\wwwroot\WEB-INF\classes\com\mysql\jdbc\configs\coldFusion.properties"" ""read"")I noticed that this only affects MySQL and Oracle queries (MS SQL server queries would run fine up to the point that I needed to query a MySQL or Oracle DB.)  If I clicked to verify the connections in CF Admin, the site would load and run fine until the server is restarted.I found this thread: https://forums.adobe.com/thread/2319887 which was almost the same issue I am having that suggested adding: "[cf.root]\cfusion\wwwroot\WEB-INF\classes\" and "[cf.root]\cfusion\wwwroot\WEB-INF\classes\-" with READ permissions.  So I added those two paths and this allow

My scheduled tasks stopped and on going into Administrator I got:The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.   Null Pointers are another name for undefined values.        The error occurred in scheduletasks.cfm: line 190   -1 : Unable to display error's location in a CFML template. I found some posts referring to earlier versions of CF and the neo-cron.xml file. This file was blank. I replaced with the file from my development server as per the posts.Can anyone advise why this problem occurred (and has occurred to others)? - I cannot afford to have scheduled tasks anything less than bullet-proofRegardsRichard

Hi,I get error on Server startup after uninstall the Coldfusion 11 Update 13 hotfix.Here is the Error from catalina.outJava HotSpot(TM) 64-Bit Server VM warning: ignoring option PermSize=128m; support was removed in 8.0Dec 15, 2017 6:42:58 AM org.apache.catalina.startup.ClassLoaderFactory validateFileWARNING: Problem with directory [/apache-tomcat-7.0.77/shared/lib/jsf], exists: [false], isDirectory: [false], canRead: [false]Dec 15, 2017 6:42:58 AM org.apache.catalina.startup.ClassLoaderFactory validateFileWARNING: Problem with directory [/apache-tomcat-7.0.77/shared/lib/commons], exists: [false], isDirectory: [false], canRead: [false]Dec 15, 2017 6:42:58 AM org.apache.catalina.startup.ClassLoaderFactory validateFileWARNING: Problem with directory [/apache-tomcat-7.0.77/shared/lib/javamail], exists: [false], isDirectory: [false], canRead: [false]Dec 15, 2017 6:42:58 AM org.apache.catalina.startup.ClassLoaderFactory validateFileWARNING: Problem with directory [/apache-tomcat-7.0.77/shar

We have CF9 and want to move to CF 2016, but on a new server.  I have been trying to digest the CF2016-Migration-Guide.  I am not real familiar with CF, but I am pretty familiar with Windows Server, IIS, etc...The migration guide is catered for someone doing an in-place upgrade and there appears to be some sizable gaps on steps if you are moving to a new server.I have successfully:- Installed CF 2016 on the new server- Copied the neo*.xml files from the old server and allow them to migrate- Copied the \Inetpub\wwwroot files and folders from the old server to the new- Copied the database folder that the datasources point to from the old to the newWhat I am missing:- Do you I need to recreate the ColdFusion Collections or is there a way to migrate them?  (note: recreating wouldn't be horrible, but I am not sure what folder was specified on the old server when you tell the collection to index)- I am not sure if I a missing anything else.  If I hit my website on the new

Hello, all,I cannot access helpx.adobe.com, just wanted to see if anyone else is having this issue.  If so, then I think Adobe is having an SSL cert issue.  If not, then how can I fix this?  I need access.V/r,^ _ ^

is it possible to set up Outbound url rewrite rules using Coldfusion and IIS? If if anyone has this working, please point me to an example,i have no no problem with IIS and .net or html pages but when I try .cfm either the server hangs or the outbound rules only work with the target page.no issues with inbound rewriteregardsRichard

I'm wondering if Adobe is going to move http://blogs.coldfusion.com/ over to this community so that we have less Blogs to have to sort through when looking for ColdFusion info.  Anyone know?

I seem to be completely confused over how to achieve a Single Sign On for Coldfusion apps that previously used the classic username password form to get started. This is a company Intranet Application. Let me explain. The assumption is that some user has logged in to his company network on any random Windows computer and then opens the Intranet App in a browser of his choice. The Coldfusion App checks to see wether the users USERNAME exists in the Active Directory Structure ... and then using the USERNAME will open the App with the proper security restrictions that the App database has associated with that USERNAME. This is my problem... at the moment: How does the client side let the App know what the UserName is? cgi.Remote_User is always empty... as is cgi.Auth_User. Clearly I'm missing something in my assumption about Single Sign On. Anything you all might be able to offer is readily consumed and greatly appreciated. I've googled my fingers raw for days reading everything I can fin

Hello,This situation affects a ColdFusion Project that is located on a network drive. It doesn't matter if I create a Default Linked Folder or not during the setup process. This problem does not seem to occur with other types of setups, including local file locations, or even other projects located on the network.*In this scenario, on two separate installs using 64 bit Windows 10 with CF Builder 2016 Build 302777, CFB hangs for a minimum of 15 seconds as it tries to populate the "suggestion drop down" after entering essentially any code that ColdFusion Builder thinks it can help me with. It happens after typingvariables.application.session.<cfset (in many cases)<cfset variables.<cfset application.<cfset session.This "ColdFusion Project" has about 100 files in it. (It's a Mura plugin.) I can get around this issue if I copy the entire project folder to my local drive, but that workaround doesn't seem realistic or ideal. Is this how CF Projects are to be set up in CF

I am trying to get the 'request method' (POST, PUT, GET), but somehow it doesn't work.On localhost I do get the request method used back correctly, only on our server it always returns 'GET'.When I put the code on the server in a different folder I do get the method back.What should I be looking for that might overrule or change the 'request method'?Tested with: GetHttpRequestData().method and cgi.REQUEST_METHODUsing: PostmanOn ColdFusion: 11Background: working with CF11 but without CF11 devs. trying to maintain code from my PHP experience.Any help would be greatly appreciated, thanks!

This is the API page Reports.getInactivePages (Method)  and this is how to invoke the API Invoking the API Using ColdFusion . However, I want to use the QueryRowLimit=0 to return all the records. This is what I have.<cfset inactivePagesReport = Server.CommonSpot.api.getObject('reports')><cfset inactivePages = inactivePagesReport.getInactivePages(0)><cfset records = inactivePages.QueryRowLimit = 0 ><cfdump var="#records#" >This is not working. It got this error: Attempt to add a field to a locked structure of type 'Reports_GetInactivePages_Result'

I am trying to get a sandbox PayPal IPN working with the Coldfusion example shown here:https://github.com/paypal/ipn-code-samples/tree/master/coldfusionI've added the location of my IPN file to PayPal and the page is being called by it but all I get is a 'Connection Failure' message in the text file. The IPN file is being called from an https location so not sure what is wrong. Any ideas?

My application requires client certificates at the root level.  Some functions within my site use cfhttp to contact another server that also requires client certificates.  Is there any way to pass the user's certificate on to the other server via cfhttp?  The only solution I can find is to use a specific cert file that exists on my server's file system to send via cfhttp.What I'm looking for is a way to do something like:<cfhttp url="http://www.otherserver.com" clientcert="#cgi.cert_subject#">...but clientcert is looking for a static file in pkcs format.

I'm attempting to write a string to an XML file using CFFile. The XML file must have apostrophes expressed as "'" once complete.I'm using <cffile action="write" file="#VDJ8databasepath#databaseNew.xml" output="#XmlString#" addnewline="no" charset="utf-8"> to write the string to a file.I can change the string to represent apostrophes as " ' " or "'" but when I write it to file, apostrophes are written as either " ' " or "'". As you can see, when the string contains apostrophes represented as "'" CFFile encodes the "&" character as "&" but when the string contains apostrophes represented as " ' " it does not encode them at all and simply leaves them as " ' ".Any ideas how to get my apostrophes written by CFFile as  "'"?

I have the following code which generates a table of data and sends out to an email, but I need it to group by the Status "new_Data" field.Here is what it currently produces:Here is what it should produce:I'm not sure how to change the grouping in my table code to get the Status (in yellow) to break properly?Here is my current code:<!--- Only send the email Mon-Fri ---><cfset weekday = DayOfWeek(Now())><cfif (weekday eq 1) or (weekday eq 7)>  <cfabort></cfif><!--- Query for the Status Audit records that were Changed yesterday ---><cfquery name="rsAudit_Status" datasource="cwo">SELECT tblcom.omID, DATE_FORMAT(tblcom.omEstCompDate,'%a %m-%d-%Y') AS ecd, omOwner, tblcom.omContractDate, tblcom.omStatusID, tblStatus.stSort, tblcom.omType, IF(tblcom.omDelayed='N', 'Priority Builds', 'Delayed') AS delay_name, tblcom.omCustName, tblcom.omCustAddress, tblcom.omCity, omWorkUnits, omBuildClass, IFNULL(Datediff(NOW(),omDate),0) AS DOS, DATE_FORMAT(tbl

Hi,We have 4 ColdFusion Standard Edition servers.  I would like to set all of them to use database for Client Variable Storage - and use the same Datasource.We use UUID for generating CFTOKEN.  Since I am using the same datasource, will it be possible that one server will create same CFID/CFTOKEN as another server?  Remember, that these are Standard Edition servers.  My main concern is that Server 1 creates a set of CFID/CFTOKEN.   Some days later, Server 2 creates the same set of tokens and ends up sharing another users data that had previously logged on to Server 1.Thanks!

HiOur local host is on a computer, and I tried to add another site and… well now its broken.It has been set up to use a separate drive / or maybe partition of the hard for all the websites.I don't know what information to give or were to start so I will try giving some random information to start withOS Windows 8Coldfusion version 10using IIS (i think this is the web server)I can type in localhost into a browser and i get the IIS image page thingIf I try typing in 127.0.0.1/CFIDE/administrator/index.cfm  I get a HTTP Error 404.0 Not found.I have limited knowledge with regards to this so any help or idea would be very grateful.ThanksMark

This is what I have.<cfset inactivePagesReport = Server.CommonSpot.api.getObject('reports')><cfset inactivePages = inactivePagesReport.getInactivePages(0)><cfdump var="#inactivePages#">So, how do I loop through each row and only output certain columns like ID, Name, Link columns?Any help is much appreciated.

The link to download ColdFusion Builder is broken.

Hi Guys and Gals,Having a weird issue with javaloader and a new JAR I had a developer write for me. My existing code uses itext 2.1.7 and its loaded via Mark Mandel's javaloader (https://github.com/markmandel/JavaLoader)  The existing code merges PDF's together (and does a better job than CFPDF and isn't crippled. Its not complicated code either. The part of the code in question:local.outStream = server.javaLoader.create("java.io.FileOutputStream").init( local.fulloutputpath );local.copy = server.javaLoader.create("com.lowagie.text.pdf.PdfCopyFields").init(local.outStream);local.PdfReader = server.javaLoader.create("com.lowagie.text.pdf.PdfReader");Then it does some work. and then closes the PDF:local.copy.close();That close() call throws an error java.lang.RuntimeException: The document is not open.  But it only throws that error if I have added this new JAR I had a guy write for me, to the java loader. I haven't even called the single method of this new class, and it is alr

Hello, all,I've got another head-scratcher.  The following code is producing an error:     thisField = trim(form.thatField);     thisField = new components.myCFC().stripScript(variables.thisField);     form.thatField = variables.thisField;Now, according to cfdocs.org, if you do not explicitly declare that a variable is to be saved in any scope, then the VARIABLES scope is the default scope that the variable will be saved in (ie, "thisVar = '';" is the same as "variables.thisVar = '';".)So.. when I typed thisField = trim(form.thatField); then it should have default saved to the VARIABLES scope.  But the second line is generating the error:Element THISFIELD is undefined in VARIABLES.???   Is this a bug?  Am I missing something?V/r,^ _ ^