ColdFusion

I'm in the process of trying to migrate from Coldfusion 2018, to Coldfusion 2021. And after what seems like a successfull migration, I am encoutring weird behavoir for cfincludes.The code in the .cfm file, that is included, is written out as plain text to the webpage, this being a cfquery, and the tag and contents of a cfscript-tag.The code itself worked when on Coldfusion 2018, so this is probably due some setting I have not set, but I could not find anything.

I am trying to create a cfhttp request to our Cisco ISE API server to retrieve endpoint devices in groups. The api is only able to return 100 devices per page and one of the groups has around 15,000 devices in it. When I run a cfhttp command for one response page on a CF page it gets a response within 300-500ms. I then tried creating a loop that would increment the page in url of the cfhttp request 10 times so in theory returning 10 pages of data or 1000 devices worth of data. When I run the cfhttp in a loop, there tends to be requests that fail with a response of connection failure: bad_record_mac. I am running the page in a Coldfusion 2021 Update 6 server with JDK 11.0.11. This being ran on a developer build on my local machine but similar issues show on our development server which is an enterprise build. Things I have tried:- Downloaded cert from https site using chrome and inserted it into keystore (currently removed as it didn't seem to change anything when added)- Adde

We are trying to build a coldfusion environment on aws using the AMI. I can't use the quick launch feature so we are using terraform and calling the API. It gets created and I can see coldfusion running on the ec2 instance but it seems like there are loads of things that aren't created in the provisioning. The current state of what we have done is :1, Created an ec2 ( ubuntu ) instance and completed the base confgiuration, and verified coldfuion and fusion reactor are running. We can't get to the admin console.2. An ALB was created to direct traffic to ports 80 and 443 but they aren't running because the ami doesn't install apache/nginx...We have our own structure for our vpc, alb, route53, and aurora db that we build and all the security groups are created accordingly. The problem is when we go to the route53 address and try to access the ColdFusion administrator it doesn't load. It also doesn't seem to allow the ebs volumes that are supposed to be created by the ami are created.

I'm working on a project to migrate a number of legacy CF10 applications to a Windows auto-scaling environment in AWS.I'm trying to find out if this is a supported configuration, and if so, what type of licensing we would require.The plan is to create a base server image (AMI) for the application. This base image would be used in an auto-scaling group to launch as many VM (EC2) instances as required to support the current load.We can configure the minimum, and maximum EC2 count for the group, and configure the instance type used and vCPU count. However in AWS obviously we wouldn't have any visibility or control over the physical servers used to run the EC2's.Any assistance would be greatly appreciated.

Hello,I have to replace the analytics.js snippet with the gtag.js snippet for our site. I've reached out to google several times and I get no response or a response that doesn't address my questions.After looking through documentations I believe we have to install tag into our code, if so where would I do this?https://developers.google.com/analytics/devguides/collection/gtagjsThen, it asks to migrate it by following this https://developers.google.com/analytics/devguides/migration/ua/analyticsjs-to-gtagjs#analyticsjs_2_gtagjsbut what exactly would I change on our ColdFusion file (code below) to match this : https://developers.google.com/analytics/devguides/migration/ua/analyticsjs-to-gtagjs#analyticsjs_2_gtagjsI'm not familiar with this. Please help.This is our google analytics cfm file:<cftry> <cfparam name="Request.sTrackFunnelStep" default=""> <script> window.ga=window.ga||function(){(ga.q=ga.q||[]).push(arguments)};ga.l=+new Date; ga('create','TAD_ID','aut

I've read the documentation and I'm currently attempting to migrate to gtag 4, everything seems to be captured by GTM except the purchase event. Below is the code I implemented, could this be a global object issue? Perhaps other third parties code I have are interfering with it in the global object? <script> window.ga=window.ga||function(){(ga.q=ga.q||[]).push(arguments)};ga.l=+new Date; ga('create','UA-9075829-1','auto'); ga('require','ec'); <cfoutput> <cfif Variables.bTrackReceipt> <cfloop query="qOfqCart"> ga('ec:addProduct', { 'id': '#courseid#' ,'name': '#JSStringFormat(coursename)#' ,'category': 'Course' ,'brand': 'My Store' <cfif unitprice EQ unitdiscountprice> ,'price':'#unitprice#' <cfelse> ,'price':'#unitdiscountprice#'

Hello, Long story short, my company recently performed an update on my local Windows 10 64 bit environment, which broke my local ColdFusion 2016 instance. (I believe they changed some permissions, CISCO umbrella etc.)  I had an issue with starting the ColdFusion service, so I ended up reinstalling ColdFusion 2016 and got past the services issue but when I went to configure my existing IIS 10 sites again I received the following error through wsconfig ("as an administrator") "Error while configuring connector on IIS. Make sure you have administrator privileges" Since I could not get past the wsconfig / IIS error, I completely uninstalled CF 2016 and installed ColdFusion 2021 (we have clients running 2016 and 2021). I also removed IIS 10 and reinstalled IIS 10 for a fresh start with IIS. I have set up my initial local development site in IIS again. However, once again when I run CF wsconfig, I still get the "Error while configuring connector on IIS. Make sur

I have an application running on Coldfusion 2021. I want to use Azure Service Bus queue to send and receive messages.I am unable to find proper documentation for receiving messages and processing them.How can I achieve that? 

<cfset array = [true,false]> <cfset queryAddcolumn(qry, 'checkbox', 'bit', array> and in the cfgrid, i bind to the cfc, and i use the following <cfgridcolumn> <cfgridcolumn name='checkbox' header='test' type='boolean' display='true' select='true'> the checkbox still doesn't show up by default. It displays true/false. Only when the grid is set to type 'edit' that the cell will change to checkbox when doubleclicked. This is not what the doc claims... the doc claims that the checkbox will be displayed.

Hi,I have a CF 2021 with all the latest patches and am trying to create a new instance but the service does not get created even though I checked the box (I tried twice) and below is the result.Enterprise Administrator - Creating New CF Instance[step 1 of 2] Creating new CF Instance... Done[step 2 of 2] Creating the CF runtime, this may take a few minutes...DoneReturn to Enterprise Manager No errors and I can see the new instance folder under D:\ColdFusion2021.  I checked instances.xml and I do see that the new instance was added but no service was created. Is there a way to manaully create the service?  I did not have this issue with other servers running the exact same version of CF with same patches (up to date)Thanks!Gabe 

We have 100+ application, and we use Unix crontab to run jobs, basically it call the CF URL and executes the .CFM page at the scheduled time. I'm trying to move cron jobs into CF and eliminate 3rd party system. I'm using CF CFschedule function to set properties and the URL of the page I want to execute. The issue I came across is the authentication. We have apps with different auth types, Azure, Shibboleth, AD and any call to the page returns 200, but it does not call the page. It due to the prompt to authenticate. Is there a way for task to call the scoped pages outside the authentication? I'm trying to avoid managing the special account and dealing with login and tuh issues for 100+ apps just to execute tasks.  cfschedule(action="update", task="Reminder4ToDo", operation="HTTPRequest", url="https://coldfusionsrvr.example.com/apps/myapp/runtodoreminder.cfm", mode="

Hi, I'm trying to implement SAML SSO for a client and I'm getting the error:"Possible replay attack occurred as there is no login/logout information associated with this request." Code:<cfset config = {idp = {name = "ClientName"},sp = {name = "TestSP"},relayState = "cart"}><cfset InitSAMLAuthRequest(config)><cfset response = ProcessSAMLResponse("ClientName","TestSP")><cfdump var="#response#"> The SP config is simple and shown in the image. The IDP is using a SAML URL from the client. I've not been able to find any info on this error. Can anyone provide some suggestions? I'm hoping I'm doing something obviously wrong. Thanks,Dom

I'm trying to use Coldfusion to integrate with the Wordpress API. In order to add images through the Wordpress API, you have to include the image in the body of the post call. PHP has the file_get_contents() function, which returns the image as a string, which can then be passed in the body of the call. Does Coldfusion have a similar function that will return an image as a string?

Hi,I am getting the error/exception java.lang.reflect.InvocationTargetException when I tried to do cfspreadsheet action="write".I am using Coldfusion 2021 version 2021.0.06.330132.JVM Oracle version 11.0.18.Operating System is Red Hat Enterprise Linux release 8.5. Please help. Thank You

I'm trying to get the Coldfusion2023 docker image to build and while it has worked on occaision the admin page won't open / is hung with no information in the logs.  I'm new to cold fusion and I don't know where to begin troubleshooting this problem any suggestions would be appreciated. Here is my test docker-compose.yml version: "3"services: coldfusion: image: adobecoldfusion/coldfusion2023:latest ports: - 8500:8500 environment: - acceptEULA=YES - password=123 volumes: - ../cold_fusion/app:/app And here are the logs for /opt/coldfusion/cfusion/bin/../logs/coldfusion-out.log20:57:24.661 [main] ERROR coldfusion.server - Protocol not availablejava.net.SocketException: Protocol not availableat sun.nio.ch.Net.getInterface4(Native Method) ~[?:?]at sun.nio.ch.DatagramChannelImpl.getOption(DatagramChannelImpl.java:417) ~[?:?]at sun.nio.ch.DatagramSocketAdaptor.getOption(DatagramSocketAdaptor.java:426) ~[?:?]at sun.nio.ch.DatagramSocket

Hi,I recently migrated our site from the old Google Analytics to the new analytics, then begun using GTM services. For some reason the GTM cannot conenct to the site in debug mode and it's not recognising any tag in there. Nonetheless, there's a tag because it's receiving user info into the service. Could it be something wrong with the event called "purchase" which is triggered every time the customer places an order?

I am trying to connection a database instance which is gcp , i have the correct credentials but I am getting error on CF admin dsn , I can connect this db instance using sqlserver studio using the login credentials(ip, db username , db password) but not able to connect it from cf admin which is also in gcp. Connection verification failed for data source: testDBjava.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sqlserver'.The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sqlserver'.

Hi, Is it possible to disable some checkboxes in a cfgrid depending on some values and keeping some enabled? If yes, does anyone have an example pls? Thanks and regards, Yogesh Mahadnac

Hi, we are running a Coldfusion server ver. 10,0,23,302580 which is connected to a MS SQL server ver. SQL 2017 And users getting that pages are sporadic not loading with error and we see in the log the following message:  ajp-bio-8012-exec-304","02/18/21","12:20:23","appControl","Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Named Pipes Provider: Could not open a connection to SQL Server [53]." and it can be to any page using a SQL connection. The workaround for the users are to Refresh the page a few times and then they are able to load the page. We do not use Named Pipes on our SQL server.  We have specified the connection string to be: Server=tcp:dbs-**.***.se;Database=***; to force coldfusion not to use Named Pipes, but for some reason Coldfusion still wants to connect using Named Pipes, how can we disable this? thanks for any help or tips best regardsMartin

I created a simple LiveCycle PDF that has 1 image and 3 textfields. Using the ColdFusion code below, I was able to pass data from ColdFusion into the form. However, I can't figure out how to dynamically populate the image. When I run the code, the image is always empty.Does anyone know how to do this? All of my image paths are stored in a database and need to be dynamic.ColdFusion Code---------------------------------------------------------------------<cfpdfform source="c:\webs\testpdf.pdf" destination="c:\webs\result.pdf" action="populate" overwrite="true">     <cfpdfsubform name="form1">         <cfpdfformparam name="img1" value="C:\webs\jellyfish.jpg"/>        <cfpdfformparam name="txt1" value="Swatch 1"/>        <cfpdfformparam name="txt2" value="Orange"/>        <cfpdfformparam name="txt3" value

I am wondering if anyone has any ideas to help me troubleshoot a mail issue with ColdFusion 2016:The server is sending and receiving mail via Google Workspace Gmail. It has been working fine for at least a year, and there haven't been any changes lately. But suddenly, maybe 50% of the time, there is a connection error trying to send or receive mail. I can't seem to figure out what's wrong. This is what the errors look like in the ColdFusion Out logs:Jun 14, 2023 14:30:12 PM Error [ajp-nio-127.0.0.1-8016-exec-6] - com.sun.mail.util.MailConnectException: Couldn't connect to host, port: smtp-relay.gmail.com, 587; timeout 120000; nested exception is: java.net.ConnectException: Connection refused: connectJun 14, 2023 14:30:12 PM Error [ajp-nio-127.0.0.1-8016-exec-6] - A problem occurred when attempting to deliver mail. This exception was caused by: com.sun.mail.util.MailConnectException: Couldn't connect to host, port: smtp-relay.gmail.com, 587; timeout 120000; nested exception is... A

Hi, I am in the process migrating CF 2018 to CF 2023, one issue I notice is in 2018 the PDF created is same as the html regarding hyper link, for example, this html: <a href="/temp/getfile.cfm"> but with CF 2023, the PDF add the context path to the above link, so when user click the link in PDF, it actually go to:http://myserver.com/myapp/temp/getfile.cfmCF 2018: http://myserver.com/temp/getfile.cfmIs it a way to configure CF 2023 not to add the context path "myapp" in PDF ?this is using cfdocument tag.Thanks.

Howdy,We're having issues with our Coldfusion 2021 install and decided to try installing SeeFusion 5.2 to wrap the datasources and get more query info. Part of the instructions say to copy adobe_sqlserverdriver-6.0.jarto<CFROOT>/runtime/libHowever, when we try to startup, we get:WARNING: Failed to scan [file:/C:/ColdFusion2021/cfusion/runtime/lib/adobe_sqlserverdriver-6.0.jar] from classloader hierarchyjava.io.IOException: invalid manifest formatI tried running bnd to look at the jar file but it did'nt complain about anything.Any udeas?Is there an update of the file available?Thanks for any help you can provide.

Hi Everyone, I have created a scheduled job that deletes the data from db, when i access the file through browse it runs fine, but when i gave the url in schdule task in CFadmin it does not run, it shows that schedule task ran successfully but it does not run. Code in my cfm file: FormSubmit.cfm<cffunction name="deleteFileFromDB" returnformat="plain"access="remote"><cfargument name="fileId" type="string" required="yes" />        <!--- <cfoutput>Inside Model 2</cfoutput> --->   <cfset myDataSource = "sds_dev" />        <!---  <cfset myDataSource = application.datasource />--->        <cftry><cfquery name="deleteFileDetails" datasource="#myDataSource#">            DELETE            from             uploadFileTest            &nb

I have scheduled tasks that trigger email every day at the same time. The task runs, but the user never receives the email, and the undelivered mail folder is also empty. The task page can be accessed without logging in.When  I restart my ColdFusion services, the user receives the email.Can you guide me to resolve this issue?Using Coldfusion 2021 Update 6