ColdFusion

Hi, Can anyone provide help for intergrating JasperReports Library with Adobe Coldfusion. I have been trying to get this to work without much success (using CF2016). The cfjasperreport custom tag looked perfect to what I would like but I am getting a lot of missing file and java class path errors which are currently beyond me. I'm not sure if I should keep trying to figure this out as it hasn't been updated in 6 years and was focused on Railo/Lucee. Outside of cfjasperreport custom tag. I've setup simple Java JAR files and can call methods on those but haven't got very far with the Jasper Report library directly. Side Note: I am aware of CFDocument but would prefer a reliable report builder/designer for managing my reports. I have looked into JasperReports server and Jasper Reports IO and have both working with CF but being able to swap out CFReport with a custom tag with Jasper Report library without need an external service is something that I would find really he

Hello,New student to CF and would like to know how to turn a url in a CF forum comment to become a hyperlink?Thank youMonique

I have  batch file which run script to convert word to pdf .When directly run batch file conversion done perfectly.When I  try to use coldfusion cfexecute to run the batchfile  it take continuously  execute until browser close  no error and no output .My  cfm file and bat file location  is D drive<cfexecute name="C:\Windows\System32\cmd.exe" timeout="2000">cd /D D:\home\docxtopdfbulk-convert-Word2PDF.bat</cfexecute> My batch file :echo offfor %%X in (*.docx) do cscript.exe //nologo SaveAsPDF.js "%%X"for %%X in (*.doc) do cscript.exe //nologo SaveAsPDF.js "%%X" My SaveAsPDF.jsar obj = new ActiveXObject("Scripting.FileSystemObject");var docPath = WScript.Arguments(0);docPath = obj.GetAbsolutePathName(docPath);var pdfPath = docPath.replace(/\.doc[^.]*$/, ".pdf");var objWord = null;var wdAlignPageNumberCenter = 1;var wdPageNumberStyleLowercaseRoman=46try{objWord = new ActiveXObject("Word.Application");objWord.Visible = false;var

Hi,I just did a new install of CF 2021 on a Windows server.  All went well, no error messages.I uploaded a test file and visited it from the local server, I get a 404 error.  I checked and CF is running.The same server has php running on it, and a test php file in the same folder processes.Before I go poking around in the CF administrator and making changes, did I miss something obvious? Thank you

This may be a dumb question, but I was not at my current employer when ColdFusion was installed.  We have 3 environments (Development, Test and Production).  How do I tell if they all use the same license or 3 different ones?

Hello,I've been indexing documents with SOLR, and everyday it seems to crash or hang at some point, and so I find that I have to restart it fairly often.  I normaly do that by SSH-ing into the server and the running the following command:/opt/coldfusion2016/cfusion/jetty/cfjetty restartThat normally works fine.  This morning, however, when I wend to restart it I got this message instead:ColdFusion Jetty service is already running or the port is not free exiting Even when I tried to stop and start it (as opposed to "restart"), I got the same error:> /opt/coldfusion2016/cfusion/jetty/cfjetty stop Stopping ColdFusion Jetty Server, please wait ColdFusion Jetty Server has been stopped > /opt/coldfusion2016/cfusion/jetty/cfjetty start You are starting Admin Component for ColdFusion. Starting this service also starts Solr search service (if installed). ColdFusion Jetty service is already running or the port is not free exiting Does anyone know what might be the is

Hello, I am attempting to set up SAML integration, and have been receiving an error during ProcessSAMLResponse:coldfusion.saml.SamlResponseHandler$SamlResponseException: The response was received at http://…….. instead of https://……….. at coldfusion.saml.SamlResponseHandler.handleLoginResponse(SamlResponseHandler.java:218) at coldfusion.saml.SamlResponseHandler.handleResponse(SamlResponseHandler.java:127) at coldfusion.saml.SAMLServiceImpl.ProcessSAMLResponse(SAMLServiceImpl.java:502) at coldfusion.runtime.CFPage.ProcessSAMLResponse(CFPage.java:17502)Everything is happening over HTTPS, and the ACS url is definitely https on the IDP side (Okta) and I have tried this on two different ColdFusion servers. Does anyone know what might be causing this? One server uses Apache to proxy over to CF and the other uses nginx. Im pretty sure that neither use https during the proxy. Could this be the reason?

I am getting: "Registration error for service manager : .http://127.0.0.1:0/PDFgServlet/.Reason: BAD REQUEST and it will not allow me to open any page on my sites." Anyone else see this error or know how to fix it?

Hi,I've been tasked with updating Coldfusion 2016 currently at Update-7 to the latest (17), Can i directly go from 7 to 17 or is there any issues if I do so? Where can I find details regarding dependencies and instructions. Since I took over this from someone who left, this is my first attempt at an upgrade 🙂My current version is 2016,0,07,311392. (Linux Redhat Enterprise)(Tomcat version : 8.5.32.0, Java version 1.8.0_192) Please let me know. ThanksSajan

My settings in ColdFusion Administrator 9 appear the same as those I had previously on ColdFusion 7. When a page errored out on CF7, I'd see something like this;Error Occurred While Processing Request Variable  XFHDSHSDHJ is undefined.The  error occurred in D:\Website Data\mywebsite.com\variabletest.cfm: line  11 : <cfoutput>#xfhdshsdhj#</cfoutput>Now I see: 404 - File or directory not found.I don't have cferror tags in application.cfm (someone thought that was the problem).  I know you can view the errors in the application log, but I really liked having the error messsage display directly on the erroring page.Thank you!

Hi Friendly Folks,When I check "Enable TLS connection to mail server" in CF Admin under "Mail", what version of TLS is activated? I have searched around and been unable to find an answer.Thanks!- Shawn

Migating to a new server, and getting an error when uploading a new photo.  Any help appreciated.   Here is my code:<cffile action="upload" filefield="Photo" destination="#ExpandPath ('../images/temp/')#" nameconflict="MakeUnique"><cfset Photo = File.ServerFile><cfset NEWPHOTONAME = 'VE_' & '#dateformat(now(), 'yyyy_mm_dd_')#' & '#timeformat(now(), 'hh_mm_ss_')#' & '#photo#'><cffile action="rename" source ="#ExpandPath ('../images/temp/#photo#')#" destination="#ExpandPath ('../images/original/#NEWPHOTONAME#')#"><cfset Photo = "#NEWPHOTONAME#"> Server doesn't like the #ExpandPath ('../images/temp/#photo#')# reference. Error message:  The value of the attribute source, which is currently C:/HOSTINGSPACES/virginia/virginiaequestrian.com/wwwroot/images/temp/IMG_2123.JPG, is invalid. Checking the folder, the file was uploaded to the correct "temp" folder, and is in fact there. Any help appreciated!

Hi,I always preface with I am not a programmer.  🙂I just moved my server.  The new server is Windows 2019 with CF 2021.On the new and old server CF was installed on the E drive.On the old site, I accessed the CF Administrator on the web through https://My.Site.org/CFIDE/administrator/index.cfm.  That doesn't work with the new server.I can access it while directly on the server at http://127.0.0.1:8500/CFIDE/administrator/index.cfmThe old server was in place for a long time, I tried searching and cannot find out how I was able to access the old server through my PCs browser while not directly on the server.Suggestions? Thank you!

I'm getting errors using some of the sample code (after adjusting for typos): https://helpx.adobe.com/coldfusion/using/integrate-coldfusion-amazon-sns.html <cfscript>//'archinet_aws_user_1' and 'snsConf' are aliases configured in the CFAdmin panel// define the credential and the configuration aliases in the ColdFusion Adminsns=getCloudService("archinet_aws_user_1","snsConf");// code below.</cfscript> Throws this error:"The httpClient and the httpClientBuilder can't both be configured." Any one else encounter this?

Hello, Just a query on 2 differing ways of calling a function from a component in Coldfusion. I've always called functions in one of 2 ways.  Method 1:  <cfset myComponent = createObject("component", "pathToMyComponent.componentGet")> <cfset myVariable= myComponent.getKey ( data = someDSN, key = myKey, ........)>​ Method 2:  <cfinvoke component="pathToMyComponent.componentGet" method="getKey " returnvariable="myVariable"> <cfinvokeargument name="data" value="#someDSN#"> <cfinvokeargument name="key" value="#myKey#"> ....... </cfinvoke>  My question would be is there any overhead using Method 1 over Method 2. I assume there must be

There appears to be a significant bug in Adobe's ColdFusion Documentation on getting variables with period references.Under the "getting a variable" heading it shows the following sample code: <cfoutput>myVar.a.b is: #Variables["myVar.a.b"]#</cfoutput> However, you can't reference a struct key like that in any version of ACF.  Here's a snippet that will throw an error every time you try to execute it (change the server to try different versions).Here's the code: <cfscript> variables.myVar.a.b = "apple"; writeDump( variables[ "myVar.a.b" ] ); </cfscript> Oddly enough, I feel like CFML should work as the documentation describes.  It is too bad that it does not. 

Hello CFers,I installed the ColdFusion 2016 Update 17 (from Update 16) which came out this week and unfortunately all of my Coldbox sites are getting 500 errors when trying to load them.  The line that is causing the error is as follows:`variables.thisRoute.handler = arguments.handler ?: "";`The error that is being generated in the logs is:"Error","ajp-nio-127.0.0.1-8016-exec-12","03/23/21","22:31:22","6A70E1E9B0E6E14EC4590A014F4D5C13","coldfusion.runtime.CFPage._isDefinedElvis(Ljava/lang/String;)Ljava/lang/Object; The specific sequence of files included or processed is: C:\websites\mysite.com\wwwroot\index.cfm, line: 1217 "java.lang.NoSuchMethodError: coldfusion.runtime.CFPage._isDefinedElvis(Ljava/lang/String;)Ljava/lang/Object;at cfRouter2ecfc1597072887$func_CF_ANONYMOUSCLOSURE_ELVIS1155.runFunction(C:\websites\mysite.com\wwwroot\coldbox\system\web\routing\Router.cfc:1217)at coldfusion.runtime.Closure.invoke(Closure.java:109)at coldfusion.runtime.UDFMethod$ArgumentCollectionFil

Does anyone know the correct syntax/ settings to create an Oracle datasource in ColdFusion 2021? I just did an upgrade and when it imported Oracle datasources, it claims the "Use of Adobe JDBC Drivers is restricted." and we were using macromedia.jdbc.MacromediaDriver. We also have the Oracle thin client installed but I'm not sure of syntax for the JDBC URL and placement of jar files. Can anyone point me in the right direction? Thanks!

I installed ColdFusion 2021 Developer Edition on a newly created Azure VM runing Wndows 10 Pro, and IIS 10.  I then started the process to add a website to the VM by creating a Server instance in the CF Admin, and a webstie in IIS.  After that I ran the WSConfig.exe for the website in Administrator mode.  I clicked the "Add" button, made sure the "AppServer Host" and the "IIS Website" were for the website I added.  When I clicked the "OK" button I received a popup with the error "An unknown error has occurred."  The only option on the popup error was an "OK" button, which I clicked.  The connection was not made.  The attached image is a screen shot of a window that was running in the background.  I don't know if it helps.  Any suggestions on how I can get the WSConfig to work? 

When using the Web Server Configuration tool I'm receiving the following error. I don't want to attempt installing this on a server if I can't get it running locally. java.lang.NullPointerExceptionat com.adobe.coldfusion.connector.connectorinstaller.ParserUtils.parseXMLDocument(ParserUtils.java:103)at com.adobe.coldfusion.connector.connectorinstaller.ConfigParser.getRootNode(ConfigParser.java:52)at com.adobe.coldfusion.connector.connectorinstaller.ConfigParser.getTreeNode(ConfigParser.java:37)at com.adobe.coldfusion.connector.connectorinstaller.ConfigParser.getConnectorHeartbeatPath(ConfigParser.java:200)at com.adobe.coldfusion.connector.connectorinstaller.WebServerInstaller.writeConnectorPropertiesFile(WebServerInstaller.java:988)at com.adobe.coldfusion.connector.connectorinstaller.IISInstaller.installConnector(IISInstaller.java:337)at com.adobe.coldfusion.connector.connectorinstaller.gui.AddConfigDialog$AddConfigThread.run(AddConfigDialog.java:1189) It looks like the wsconf

Hi folks,we are testing application in ColdFusion 2021I am getting below error message as i am using offset in ormExecuteQuery()we used offset for pagination.error is : "query result offset is not supported"I tried below steps to resolve but none work for me.1. Adding hibernate configuration filethis.ormSettings.ormconfig = "hibernate.cfg.xml";<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration><session-factory><property name = "hibernate.legacy_limit_handler">true</property></session-factory></hibernate-configuration> 2. Adding below setting along with other orm settings.<cfset structInsert( this.ormSettings,'hibernate',structNew(),true )><cfset structInsert( this.ormSettings.hibernate,'legacy_limit_handler',true,true )>i am not sure this works or n

Adobe tells me:"Boolean values Use True, Yes, or 1 for  true  and False, No, or 0 for false. Boolean values are not case sensitive." String values are enclosed in double quotes. When used in code, are boolean values enclosed in quotes like strings are? Or are they used, plain?For example, should the following be written as:<cfif session.isloggedin is "1"> —or— <cfif session.isloggedin is true> Thanks!

I have been at this for quite a few years and tried since ColdFusion 2016 to get PDFg working on Redhat Linux.  I finally got it working and would like to share my steps in hopes of helping someone else:Installed Coldfusion 2021 at /opt/ColdFusionDownload Linux Version of Add on Services Install defaults(admin, solr, and pdfg) but change java path to /usr/java/latest(where I have java installed for ColdFusion).  Choose install directory of /opt/ColdFusion/addonservicesIn /opt/ColdFusion/addonservices/cfjetty change java path because it apparently didn't care what you said during install(I've created a bug report):     #SOLR_JVM="/opt/ColdFusion/addonservices/jre"     SOLR_JVM="/usr/java/latest"     Remove /opt/Coldfusion/addonservices/jre3.  Download fonts required for linux install     wget http://cgit.freedesktop.org/xorg/font/ibm-type1/snapshot/font-ibm-type1-1.0.3.tar.gz     tar -zxvf fon

Migrating a few websites from CF 4.5 to 2018 (I know!) and could use some assistance.  Seems CF 2018 doesn't like my syntax:<cfquery name="CalCount" datasource="#dsn#">SELECT ID FROM Calendar WHERE Approved = 1 AND Caldate > #now()# -1 AND WebsiteID=#application.WebsiteID#</cfquery>Seems #now()# converts to{ts '2021-06-10 07:26:22'}SELECT ID FROM Calendar WHERE Approved = 1 AND Caldate > {ts '2021-06-10 07:26:22'} -1 AND WebsiteID=1CF doesn't seem to like my syntax. Will be digging into dates and formatting, but any insights appreciated. 

I've created a CAR file in CF2018 Administrator on our development server but I can't get it to deploy on our production server. Creating the archive was a little buggy. When I select "Assoc. Files/Dirs" in the archive wizard, I'm unable to select any of the other options. When I skip "Assoc. Files/Dirs" altogether, it seems to work. The resulting file is 385k. (Does that file size suggest a successful build?) Once I've built the archive, I move the CAR file to the production server, use the CF Administrator to deploy, and... nothing happens. The file path is cleared from the input and no datasources have been added, collections, mappings, etc. I'm not skilled at reading the CF logs, but there doesn't seem to be anything related to my failed efforts. Both servers are current through Update 11. Any insight or suggestions? Thanks!