ColdFusion

Hello, all,About two years ago, we started having serious latency issues with our restricted portal.  Many of us spent weeks trying to track down what the cause was.  The rest of us were scrambling trying to optimize the portal as much as we could, in the hopes that we could speed up the site load times.  Part of this band-aid approach involved a custom-made News slideshow on the landing page.  Instead of grabbing four UUIDs, Headlines, and images on every page load, we set up the application.cfc so that every two minutes the query would run and store the UUIDs, Headlines, and images into application variables, and pull from those.Naturally, I placed an exclusive CFLOCK around the process in the application.cfc.  But we are using a separate include for retrieving the images on page load, and part of that is using CFHEADER/CFCONTENT to serve up the images, passing an ID in the URL scope.  This reduced the page load time by only a few seconds, but it helped.

Hi!​​I'm having an issue with joining/merging two different databases. I'm receiving all of the variables from one Datasource, but one variable is not showing up from the other DataSource.Both of them are related to the "IDInquiry" field, but even after relating the two its not showing up.​​Attached is my code:​<cfquery datasource="Portal" name="GetNoms">  SELECT IDStudent, NameFull, School_Name_Previous, InqContactPhone, P1_full, P1_phone_H, P1_city, IDINQUIRY  FROM Inquiries WHERE Inquiry = 1 AND Adm_Record_Status = 'Active' AND (Application IS NULL OR Application = 0) AND Adm_Enr_Status = 'Inquired' AND P1_phone_H IS NOT NULL AND P1_city IS NOT NULL AND YOE = '#YOE#' ORDER BY P1_city ASC</cfquery><cfquery datasource="Portal" name="GetPercentage">  SELECT IDInquiry, PercentComplete_display FROM inq_PWSINPUT</cfquery><cfquery dbtype="query" name="FinalMix">  SELECT * FROM GetNoms, GetPercentage WHERE GetNoms.IdInquiry = GetPercentage.I

I'm having a "File is missing" error which stops me from accessing loopback server that CF2018 is deployed. However, when I look into the specific directory (where the error message shows me xxx file in xxx is missing), the so-called missing file is existing. I tried to restart WebLogic server, not helping. This is the error log I got in Eclipse console log:<Oct 23, 2018 4:14:23,579 PM SGT> <Error> <HTTP> <BEA-101005> <[ServletContext@2099463259[app:cfusion2018_home module:cfusion2018_home path:null spec-version:3.1]] getRealPath() called with unsafe path: "/Projects/Corporate/eaccounting/:93/cfusion2018_home/Projects/Corporate/eaccounting/common/main/emailVerify.cfm".java.io.IOException: The filename, directory name, or volume label syntax is incorrectat java.io.WinNTFileSystem.canonicalize0(Native Method)at java.io.WinNTFileSystem.canonicalize(WinNTFileSystem.java:428)at java.io.File.getCanonicalPath(File.java:618)at weblogic.servlet.internal.WebAppServletC

We are installing on an offline 2012r2 'standard' installation.Installation of CF2018 went just fine - sites are reachable.After running the Lockdown application none of the ColdFusion services will start.  I did select an AD account to use, validated the password was updated first, but after completing the Lockdown and restarting the server the services fail with 'Access Denied'.I have restored the ColdFusion service to use the Local System account and that now fails as well.Any insight would be greatly appreciated.

I am probably dating myself here, but I have an application running Mach-II and Coldspring (which I use for dependency injection). I recently upgraded to CF 2016 and did not have any issues with this version/upgrade. I was testing the CF 2018 Pre-release build today and was unable to get my application to load.  Looks to be throwing on error on this: <cfset var abstract = false /> -----The web site you are accessing has experienced an unexpected error.Please contact the website administrator. The following information is meant for the website developer for debugging purposes.Error Occurred While Processing RequestInvalid CFML construct found on line 243 at column 28.ColdFusion was looking at the following text:abstractThe CFML compiler was processing:A cfset tag beginning on line 243, column 18.A cfset tag beginning on line 243, column 18. The error occurred in D:/APPLICATIONS/CF-INF/cfFrameworks/coldspring/beans/DefaultXmlBeanFactory.cfc: line 243Called from

I couldn't find any recommended hardware specs for the performance monitoring toolset.When I installed it I saw it uses elasticsearch, and it started with 2.5GB monitoring a single empty server.On the elasticsearch site, they recommend a machine with 64GB, I can assume this is different for this implementation. But I can not find any specs for this.How much memory/cpu usage should I expect per added monitored server? Is there any instruction on this anywhere?

When is ColdFusion 10 going to officially support MSSQL 2012? Specifically the "AlwaysOn" Availability Groups and the connection flag "ApplicationIntent=ReadOnly" or "ApplicationIntent=ReadWrite"? The JDBC driver from Microsoft supports it and I believe DataDirect has a new driver that supports it, but it doesn't seem available yet in CF10 and the latest Update 8. I tried running the Microsoft specific JDBC driver, but ran into differences in resultsets.

This is a problem that was first observed with CF8 using the cfchart tag. We have since upgraded to CF2016 and it still exists. Perhaps this is a programming error on our part but here is the issue:Trying to create a pie chart. In this case I has 4 data items. Two of them have 0 values and the other two each have a value of 50 (representing percentages).This is in response to a title to this posing as a question... How do you feel today?<cfsavecontent variable="chartContent">  <cfchart format="png" pieslicestyle="solid" width="400" height="280">    <cfchartseries type="pie">      <cfchartdata item="Terrific!" value="0">      <cfchartdata item="OK" value="50">      <cfchartdata item="Not so good" value="50">      <cfchartdata item="Terrible!" value="0">      </cfchartseries>  </cfchart></

JavaSEのリリースモデル変更によりColdFusion10になにか変更はありますか？

I have a CF10 server running on Windows 2008 r2. JVM is 1.80_91. I have configured the Mail settings in CFAdmin to our Office 365 instance, I have a relay account we are using configured. When I send test emails they are only TLSv1.0 to Office365. I read a couple of forums and found the Dhttps settings which I have put into Java and JVM in CFAdmin. I restart the CF service and still the test messages are TLSv1.0. I even went into the javacpl.exe and unchecked TLS 1.0 and TLS 1.1 in Advanced.What am I missing? Based on what I have been reading, this should work correctly.

Hi everyone, We have recently upgraded our website infrastructure from Win2003 Coldfusion 9 to Win2012R2x64 with Coldfusion 11.We sorted everything out except one error that keeps coming up.From time to time, Coldfusion throws a TemplateNotFoundException for some cfm files which exist on the filesystem. These files they have high hit ratio and coldfusion serves them correctly 99% of the time, but once in a while (maybe 10 times every 50000 requests) they throw the templateNotFoundException to the user.In coldfusion-error.log I can see the following error "org.apache.coyote.ajp.AjpProcessor getRealPathFromServer SEVERE: Error in getRealPathFromConn java.io.IOException: Socket read failed" which lead me to believe this is an IIS connector issue (I'm not 100% sure)I have tried to optimize the IIS connector using the parameters found on the following article but didn't helphttp://blogs.coldfusion.com/post.cfm/coldfusion-11-iis-connector-tuning Our IIS server (8.5) has only 1 site and I con

I'm developing an app that populates a calendar with an event being generated in the code.  The issue I'm having is when the calendar event is created (using MS Exchange and Outlook) it adds some characters to the message body that I don't want. For every event I create the body gets automatically populated with the following lines: When: Monday, December 24, 2018 8:30 PM-9:30 PM. UTC      (The date of the event) Where: 10664 W Victory Rd                                 (The address of the event *~*~*~*~*~*~*~*~*~*I don't want those characters (in bold above) to show as I'm populating the body of the calendar event with my own HTML formatted text.  My question is how do I prevent the default message from being added to the calendar event?Thanks in advance for any and all help!!!

Hello, all,I'm working on a project whereby we can run a script that will check all the links of a generated page to make sure that each link (local and off-site) are valid.As of now, and I can be open to change, I'm using AJaX to call a CFC function that uses CFDIRECTORY to recursively get all .cfm and .htm pages of a site, swap out the physical drive path for each entry with its FQDN address, loops through that using CFHTTP to parse the page, then uses REMatch to get an array of all anchor tags in the page.  I am currently looping through the arrays and adding the values as KEY to a struct to eliminate duplicates, then CFRETURN the ArrayToList(StructKeyArray(array),"|").  CF is returning something like:<a href="https://www.domain.com/index.cfm">Link One</a>|<a id="newlink" href="https://www.google.com">Link Two</a>|<a alt="test" id="testing" href="https://www.another.com/index.asp">Link Three</a>So how can I get just the value of the href

Is there an official statement from Adobe as to whether Windows Server "Server Core" installation option is supported or not?The "Server Core" installation option is not listed on the ColdFusion product support page, https://helpx.adobe.com/pdf/coldfusion2018-support-matrix.pdf.But then "Server Core" installation option is not a product edition, it is an install option available to Datacentre and Standard editions of Windows Server:What is Server Core? | Microsoft Docs "The Server Core option is a minimal installation option that is available when you are deploying the Standard or Datacenter edition of Windows Server."And both of those editions are supported by ColdFusion.

Hello,I am trying to create an excel sheet (xlsx) using cfspreadsheet which gets data through a query object (SQL Server) having more than 200K records. When attempting to do that the cfm page just runs for few minutes (have set timeout for the page as 3600s) and stop processing further without any error and at the same time the excel sheet does not get created.The requirement is to let user download the excel sheet with very large number of records whenever they want, no fix schedule for it.Note: For another instance, upon dumping the SQL query object alone on the page it displays the records (in this case approx. 80K) successfully in a minute (approx.) however, cfspreadsheet does not work for this even.Any advise / thoughts would be greatly appreciated.Thank you.

Can someone point me to a link or do I have to buy a 64 bit computer

Hi Friends,I have coldfusion9 in my application server. I have integrated .Net dll into CFM page. Its currently working fine.Now installed ColdFusion 16 trial version on a new server. Moved ColdFusion 9 code to new server and everything working fine except .Net integration part.I am getting error "DotNet Side does not seem to be running.Ensure that the DotNet agent is running and you have provided the correct host and port information "My dotnet dll registered in "GAC_MSIL"My server is WIndows 2008 R2 32bit.I don't know what i am missing.Please help me.Thanks,Ashok Mohanty

I have HTML fragments with embedded CF tags stored in a field in my database. When I read the field from the database, I want to have the CF tags, etc. evaluated and store that in a string.  Let's say Text contains "This is my #Content#" and Content contains "substituted content".   I want both to be evaluated (recursively) so that the substitutions take place correctly and I end up with "This is my substituted content".I have tried this, but all I get is Final containing "This is my #Content#".    <cfsavecontent variable="Final">        <cfoutput>        #Text#        </cfoutput>    </cfsavecontent>Is there any way to get this recursive substitution to happen?Thanks!

I have a name field in my database like this -table has 15M rows'Jones, Albert Louis'Where the field is like thislast name, first name, middle nameI have a cf search that the user can enter a first name and last name and a middle name that searches that fieldI have everything indexed properlyWhen I do this query I get results immediatelyselect * FROM table wherename LIKE 'Jones%'  But when I add the first name the query never returns results or takes a very long timeLike thisselect * FROM table wherename LIKE 'Smith%, John%' Is my syntax correct? Is there a better way to do this query?

Hi,I created the schedule runs every 30 minutes.  It shows the last run in Oct-10-2018 08:20:00AM, but I didn't get anything.  I then click on the green icon to manually run the schedule task and it was  was completed successfully, but again, I didn't receive anything.  I then try to manually copy the url and run it in the browser and it worked.Can anyone please help?

Hello,I currently have a table that displays the data from a query.  I would like to make it more flexible so I would like to use CFGRID to output the information instead (for pagination, sorting, outputting to MS Excel etc.).However, I need to change the cell color of certain fields based on the data in those fields.  For instance, if the value in the certain field is 0-30 I need it to be red, if it is 31-60 I need it to be yellow and 61-100 I need it to be green.I remember doing this last summer for one of my clients, but I was under a fairly strict NDA and couldn't keep any of my notes/code and I don't recall much about how I went about doing this.  There is probably a better way than what I did in any event.I think it had something to do with writing the query to a new query and wrapping the values with some CSS code for the color as i processed it.I rather doubt that I am the first person to ask this question, but I haven't been having much luck finding the answer s

Hi,I am working on printing the labels with a particular network printer ( TCP/IP ), when the user click a button on UI.CUPS is installed but didn't configure the printer yet. Whats the next step, after configuring it in CUPS control panel?Have no clue on how to get this done!!! We are using Coldfusion 9.Thanks

Hello,cfimap is unable to read emails when users send emails with xlsm attachments. No issues with xls files. Has anyone experienced this?An exception occurredwhile performing action GetHeaderOnly in cfimap tag.          Error Detail: Thecause of this exception was: com.sun.mail.util.FolderClosedIOException.Thanks!

Hi,I'm on CF 11 and have Fusion Reactor 7.4.2 up and running. Under Requests => Setting => "Request Content Capture" I say Reactor should capture Requests and Responses.I perform an AJAX Requests and get an error as an argument does not contain a JSON string as expected. I disable Request Capture again, and everything works as expected.My AJAX call looks like$.ajax({    url: "my.cfc?method=myMethod&_cf_nodebug=true",    data: {        listType : 1,        userID : 1,        listID : 1,        extraField : JSON.stringify( {"myvar":1} )    },    type: "POST",    success: function(data){        //    }});When Request Capture is enabled, the resulting "request.header.xml" file has a parametermap with all the values incl

Hi,Trying to render the html code to PDF. I am having a hard time to figure out a way to render bar-code font using cfdocument.- Tried installing the bar-code in local machine, didn't work- Tried copying the font files to docker Image, didn't work- Used @11220649-face in style, still didn't work None of those are working . Appreciate it, If anyone can jump in for a help. ThanksVishnu<cfdocument             format="PDF"             pageType = "custom"             pageHeight = "3"             pageWidth = "4"             margintop="0"             marginright="0"             marginleft="0"    &