Questions

Hi thereI am looking for the right ColdFusion functions to compare with PHP functons.In PHP:PHP Calculations (these are the correct ones)$xValue = base64_encode(hash_hmac("sha512", "test", true)); echo $xValue;Is the result:ZjNlNzQ4NGE3YmIyMjJmNDU4MzgxOTZhMTQzMDIwYjNmOGNkZDJhMDQzYjZjOWMyNWU4NTBkMmM5NDk1MGQ5YTRhMzE5OGRmOWFmOWZhMDMxOGNmOGRhMDg2NGVmMzU2NGE2YWU1MjA3NTQwN2Q0ZmFmNjFjMjJkOGZiZDM3NGU= In CF:<cfset xMacValue = ToBase64(Hmac("test", "HMACSHA512")) /> <cfdump var="#xMacValue#" />is the result:NkJEQ0NEN0VFNkY1QUYyMTU5NjNENDY0NERBMDQwMjQ=.Which CF functions do I need to use to get the result from PHP? Thank you for your supportSteve

Hello good people - I've an 'easy;' one whipping my butt.I have two random dates, I need to display how many years, months, days have passed between the dates. I've been playing around with DateDiff and its all fine to "year" level, but days and months are killing me.  I tried one of Ben Nadel's techniques, but I end up with a "12" on my month counter when it should be "0".  (For the record, for testing purposes I had my two dates precisely a year apart, and got 1 year and 12 months... erm, no!)Yes, I have searched these forums (and others).  Yes, I got lost as none of them are helpful, either over complicared, or too siimple "Just use datediff()".  I cannot beleive somehting this simple (which I can do in Excel* in 12 seconds) has now been taking all weekend on Coldfusion.*Example of Excel code which is working 100%=DATEDIF(E6,B!, "y") & " y " & DATEDIF(E6, B1, "ym") & " m " & DATEDIF(E6,B1, "md") & " d."

Is everyone else seeing the same short, wide, blank box when clicking "Download and Install" for Update 4? Steps to reproduce are:Log in to ColdFusion 2021 AdministratorPackage ManagerAvailable Versions: select "ColdFusion 2021 Update 4"Click "Download and Install" The background dims and a blank box appears alongside the "Core Server" image... and then nothing. This happens on several machines in a variety of browsers (Firefox, Chrome, Internet Explorer, Microsoft Edge) and is unimpacted by disabling extensions. Thanks for any pointers.

This is always a head scratcher. Is there a way to simply install a server update and any packages that may need to be updated as well? I seem to only be able to do the reverse, update installed packages which may then install a server update.

I am hoping someone can point me in the right direction. I have a CF2021 Server which runs a Node.js websocket server and CF pages (via javascript) as a client. Messages from user to user work as expected, so no issue there.This CF Server also has a custom API built using CFML that handles and routes inbound SMS messages. My question is; what would be the best way to send the SMS message (by now its json) to the Node.js websocket to it can send it to the user(s).I tried using the same javascript that the browser client uses, but it appears that the CFML API script is "browser-less", so that doesn't work, or should it?I thought something like Apache Groovy may be the solution, but I am having difficulties with any websocket broadcast example I have found.Any suggestions would be greatly appreciated.thanks in advance

Do we know if ColdFusion, any supported version, is affected by the just released Spring Framework vulnerability,https://tanzu.vmware.com/security/cve-2022-22965? I need to provide updates to my InfoSec team, Phil

I am deploying a Docker image running Apache on top of Coldfusion to Azure App Service. I am unable to connect to the App Service Coldfusion Server from the Performance Monitoring Tool running on another machine.Can I connect the server to port 80/443 rather than 8500 port? Thanks!

Is there any sort of remaining log4j issue with the newest version of ColdFusion 2021? Either vulnerability or is the version of log4j included EOL?

 I’m trying to output data in the form of a grid pattern using coldfusion or MySQL . When I execute the code below, it outputs it in the regular drill down format. I Want to see if there’s a ColdFusion method and or a MySQL method that will allow my data to be out in a grid-like format With each row having a different person and each column having the results for that particular person in the row over a period of time. Please see the attached code and please also see the attached desired output. I am trying to see how I can get the desired results to look like the second image. Is it an array function in ColdFusion that I would need to do that in? Attached code: Regular output desired output 

We are running into an issue of Coldfusion looking for java in the wrong place.For some reason in the 2021 container, coldfusion is looking for java in `/opt/coldfusion2021/jre/bin/java` ,but it actually exists at `/opt/coldfusion/jre/bin/java`.I've tried setting the JAVA_HOME variable to `/opt/coldfusion/jre/bin/java` in the Dockerfile, through a .env file, and through docker-compose's environment key.I've also tried building the containers individually and running them with the -e (extra vars) flag where I set the env var.The question is:Where is the default JAVA_HOME set in the coldfusion configs? Any help will be greatly appreciatd.  Thank You, 

Hi,( ColdFusion Server Developer 2016,0,11,314546  )Consider:<cfcomponent> <cffunction access="remote" name="getDCR" output="false" returntype="string" returnformat="JSON"> <cfset var graphresultset= "" /> <cfquery datasource="datasouce" name="dcr"> SELECT [FINANCIAL_YEAR], DATE_FIELD, COUNT(*) as DCR_Count FROM XXXX WHERE YYYYY GROUP BY P.[FINANCIAL_YEAR], P.DATE_FIELD ORDER BY P.DATE_FIELD </cfquery> <cfreturn graphresultset> </cffunction> </cfcomponent> that returns:"COLUMNS":["FINANCIAL_YEAR","DATE_FIELD","DCR_COUNT"],"DATA":[["FY19/20","July, 01 2019 00:00:00",127],["FY19/20","August, 01 2019 00:00:00",2740],["FY19/20","September, 01 2019 00:00:00",4140],["FY19/20","October, 01 2019 00:00:00",4154],["FY19/20","November, 01 2019 00:00:00",3653],["FY19/20","December, 01 2019 00:00:00",3521],["FY19/20","Jan

I installed ColdFusion update 14 and all of my ColdFusion websites ( except the administrator website ) return a 403. Please help. This is a WIndows Server 2012 ColdFusion 2016 build. Re-installing is not an option. I have removed the update for now until I can find a solution. HTTP Status 403 – ForbiddenType Status ReportDescription The server understood the request but refuses to authorize it.Apache Tomcat/8.5.42

Does anyone know if the zero-day exploit affecting the popular Apache Log4j utility (CVE-2021-44228) that was announced on 12/9/2021 will affect ColdFusion version 10 and 2018?

I am using coldfusion 10 and IIS server 7. I am getting some issue like. website sometime being blank page and I restart the coldfusion service in windows machine then it starts working. please help me to resolve the issue.

I'm getting “java” cannot be opened because the developer cannot be verified when I try to install coldfusion 2021. I am on Mac OS 11.3.1 (Coldfusion 2021 is supported on Mac OS v 11 according to this https://helpx.adobe.com/pdf/coldfusion2021-support-matrix.pdf ) I go to system preferences > Security & Privacy - it says "java was blocked from use because it is not from an identified developer" I click Allow Anyway but then cf installer says "Adobe ColdFusion 2021 quit unexpectedly." - I click Reopen and then get "The file can’t be found." ColdFusion_2021_GUI_WWEJ_osx10.dmg is the file I got from the downloads page. Can anyone from Adobe help me at all please?

After installing CF2016 Updater 17 (up from Updater 11) and going through the directions from Updater 14, I cannot access the Administrator.  The password reset feature does not work either.  I can access the admin by updating the neo_security.xml file and setting admin.security.enabled = false.  Should I try uninstalling the updaters and re-installing?  

Hola, alguien sabe como resolver el problema de Coldfusion 2018 no inicia.Al momento de iniciar Coldfsuion 2018 application server me manda un mensaje que menciona que no se pudo iniciar en e equipo local. Ya detuve los demas servidores y aun asi sigue sin iniciarlo.

Hi. If you happen to know where I can find the 2016 CFML language reference PDF, please can you point me to it? I have Googled and browsed and can't find this particular document. It must have existed!The current online docs are too "advanced" and I need the specific 2016 version. Thanks in advance.Gary.

Hi,There used to be a ColdFusion developer version that we could download to use for development. Is that still available? if so, do you have a link?

When I try to install ColdFusion 2021 developer version, I get the message “libjvm.dylib” cannot be opened because the developer cannot be verified.  No matter how many times I click "Allow Anyway" in Security & Privacy, the same message occurs. I can't get by this block. What can I do to complete the installation of ColdFusion 2021?

Tengo un problema con la configuración de Coldfusion 2021, ya configuré mis datasource de Microsoft Sql Server y la verificación de los mismos es EXITOSA, el problema viene cuando hago la modificación del "virtual directory", dentro del archivo server.xml ubicado en: C:\ColdFusion2021\Mi_Instancia\runtime\conf, mi Context queda de la siguiente manera: <Context path="/app" docBase="C:\ColdFusion2021\Mi_Instancia\wwwroot" WorkDir="C:\ColdFusion2021\Mi_Instancia\runtime\conf\Catalina\localhost\tmp"></Context>Cabe señalar que esto me ha funcionado desde Coldfusion 2011 y Coldfusion 2018.Cuando hago la modificación del Contexto de mi aplicación e intento ingresar me devuelve un error diciendome que no tengo instalado el paquete de Sql server.Error:El paquete de Sql Server si lo tengo instalado: El error surge solamente después de hacer la modificación del Context en mi server.xml. Espero alguien me pueda apoyar a encontrar una solución a esto. Gracias.

I'm getting "The app can't run on your PC" anytime I try install the CF 2018 update 13 on my Win2019 Server.  How does one go about this issue. I'm running CMD as an admin, I've enabled all admin security on the group policy but still the same issue. See attached document

Has anybody developed any AI/ML applications on Azure Cognitive Services API?  I'd be interested in hearing your experiences, and , seeing some example of your code for connecting if you're willing to share. Best regards,Ronnie 

Hi, guys...I've found imageGetExifMetadata for extraction.Now, I'm trying to figure out how to edit an image's meta data.Can CF do that, itself?If not, anyone have a solution?Thanks for any assistance!Rick

Hi Experts,I am trying to send billing information to  -  pilot-payflowlink.paypal.comand I am using AJAX call to do that, $.ajax({      url : "https://pilot-payflowlink.paypal.com",      headers: {          "Content-Type": 'application/x-www-form-urlencoded',          "accept": "application/json",          "Access-Control-Allow-Origin":"#HostAddress#"      },      type: "POST",      crossDomain: true,      Accept: "application/json",      async: true,      contentType:false,      processData: false,      data: data,      cache: false,      success : function(data) {            alert("Posted Successfully!");          alert(data);          con