ColdFusion

I am working on bringing an organization up-to-date on their Coldfusion deployment.  They are currently running Coldfusion 9 on a VM with lots of troubles with the underlying OS or VM.  The first step is to migrate to a new machine, then we'll focus on updating ColdFusion.  We'll need a few days of running the old and new VMs side-by-side to be sure everything is stable while we move customer sites over.  So I'm licensed for one server, but will need to use two servers for a few days.  Can I do this without purchasing additional licensing?

Hi all,We're developing a webapp where managers are able to assign learning to their team members - ideally, this learning needs to be completed within a set timeframe and so we've been playing with assigning a task in outlook 365 with the required date/time etc.  Whilst we can do this for the actual user, there doesn't seem to be an option to assign the task to someone else using cfexchangetask.Has anyone been able to achieve this and if so how?  Thanks

Hi I have found a form online which work great! Now I want to add a new box to the form which allows for a message, so i want the box to be bigger, multiple lines rather than the 1 line I have at the moment.Currently I have the followingat the top of the page:    <cfparam        name="FORM.email"        type="string"        default=""        />In the form:<div class="control-group form-group">     <div class="field-text">       <label for="email">       Email:<br><br>       <input            type="text"            name="email"         

I've built a functional REST service that is successfully returning a query result:<cffunction name="getAllOrders" access="remote" returntype="any" httpmethod="GET" returnFormat="json">   <cfquery name="getAllOrders" datasource="test">      select * from concreteOrder   </cfquery>   <cfset results = #serializeJSON(getAllOrders)#>   <cfreturn results></cffunction>I've been trying different formats but I'm not understanding the docs (my apologies, the holidays has made my brain fuzzy). Does anyone know the correct format I should use in the serializeJSON() method to successfully bring back name:value pairs from the query results in my JSON object? All I've been able to do is bring back each row as a blob and then my Angular app can't do anything with that.... Ideally I'd like to bring back each row with something like "id": "1", "col2":"value", "col3":"value".... and so on

Hello, we have a large repository of PDF technical documents (mostly papers presented at meetings) that we've been trying to get indexed on Google Scholar, with no luck. The PDFs are stored outside the webroot, behind a sign-in wall, and served up to visitors via cfpdf, cfcontent and more.We've gone over the Google Scholar guidelines for inclusion as carefully as we can. Our content is being indexed by Microsoft Academic, which appears to follow the same guidelines, but no luck with Google. Google themselves do not provide a way to talk to them directly about it. We've tried submitting requests to have our content manually indexed, to no avail.Does anybody have experience with getting content indexed by Google Scholar? I am happy to share my ColdFusion code, although it's pretty simple. It may have something to do with the PDFs being outside the webroot and thus unable to be indexed by Google bots, but I can't think of any way to test this or verify it. We are definitely not blocking G

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!