ColdFusion

Greetings.I have a need to connect to a file server to read and zip up some files. I am looking for either a solution to the problem, or a definitive "that will not work" We have a windows based CF2018 server in our DMZ.The DMZ is disconnected from the domain as such I can not run CF as a domain user such as cf@mydomain.com Currently the CF service is running under a local admin accout ex. 'svcCF' Logging in to the Windows server as the local dmin  'scvCF', I have mapped a network drive ex. Z: to a network location '\\myserver.mydomain\myfolder' using the credentials of a domain user with permissions on that machine. I am then trying: <cfdirectory action="list" directory="Z:\700 Series\" recurse="false" name="myList"><cfdump var="#myList#"> With an empty result. My guess is just because the local admin account svcCF has a mapped drive (using a different user's credentials to connect) doesnt mean the CF service sunning as the loca

I have a db connection( xxxdev2) on a UAT server.I am trying to setup a duplicate db( xxxdev2b) opn my local server to test db failover if the primary server goes down.For some reason, I connot get the connection working in the coldfusion Datasource section.I can login in to the server using sql studio, but I get the following error on the datsopurce page of CF. "Connection verification failed for data source: xxxdev2bjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: LAPTOP-Rick:1433. Reason: Connection refused: connect"

We're trying to implement a connection to the Google Firebase Firestore database.In java, as explained by firebase documentation, one should add a depencency as follows:dependencies {  implementation 'com.google.firebase:firebase-admin:6.7.0'}This way there's access to FirebaseApp and FirebaseOptions classes.How can we do this in ColdFusion? Tnx!

Hello,I am being asked about our JDK/JRE usage at the School District by what appears to be a legit Oracle representative.I assumed our Cf license covers everything ... but am afraid to answer the email, can't imagine we would have to buy JRE licenses now on top of the Cf license ??Part of his email:I ask because the changes with Java licensing impact uses cases of Java beyond development. For example, if you use Java Runtime (JRE) for 3rd party applications, you could be impacted by these changes depending on what versions/ updates of JRE you have installed.Please let me know if you do have any Java instances installed on any of your desktops or servers so we can figure out if we should discuss this topic further Thoughts ? I checked the servers we have 2016 and 2018 .... looks like the JRE is Oracle and not OpenJDK Thanks

ProblemI have a web application that makes extensive use of websockets for call center agents. There are up to 50 simultaneous users who are triggering messages and listening on channels for chat, phone calls and broadcast messaging. After about a month in production (and, with no issues), we had two failures yesterday where messages stopped being processed. So far, it is unclear if the .cfc extension handlers were receiving the browser websocket messages during the failure, but it is positive that the server was not publishing back out to the browser listeners.When I searched the CF and IIS logs, there is NO record of any anomalous events during the stalled periods (application.log, exception.log, etc...). Restarting the ColdFusion Application Service causes messages to start flowing immediately, but there is no recovery (no catching up) for messages sent during the stall.All other website functionality appeared to be working properly during the stall.I'm awaiting the next failure so

Hi all,I currently use standard authentication butI need to know if CF11 supports modern authentication (office 365). RegardsFederico

<cfset schedindtl.presstime = 230> <cfset schedindtl.pressdate = 20090308> <cfset pressstart = #createdatetime(mid(schedindtl.pressdate,1,4),mid(schedindtl.pressdate,5,2),mid(schedindtl.pressdate,7,2),int(schedindtl.presstime/100),int(right(tostring(schedindtl.presstime),2)),0)#> pressstart = #pressstart# Looks like daylight savings time problem. Looking for help in fixing.

Hi all, I'ìve the CF 11 connected with Informix DB.in the application.log I found the following error. Can you help me to found the root cause?  many thanks "Error Executing Database Query.[Macromedia][Informix JDBC Driver]Connection reset by peer: socket write error The specific sequence of files included or processed is: G:\Inetpub\wwwroot\CFor\AccessoRiservato\_Include\PAGAMENTI\ContributiMinimi_PP\Stampe\F24Stampa.cfm, line: 643 "

Today I was changing the datasource for my client variables. I had initially specified a remote SQL Server database, but wanted to change it to a local SQL Server datasource. Apparently there was a permissions problem with the username I had specified for the datasource and it was causing a "select permission was denied error." Next thing I knew I was logged out of the ColdFusion 2021 Administrator and could not log back in. I kept getting "Invalid User name or Password. Please try again." I know I didn't change my password so this didn't make any sense. Just in case, however, I did use the passwordreset.BAT file in the ColdFusion/bin directory. But I still cannot login.I am on Windows Server 2019, and it is the trial version of Enterprise. (I am moving to a new server).Any help greatly appreciated. I would not want to have to start over setting this server up.Thank you.

Hello,I have recently updated coldfusion from 2016 to 2021, before update I used following code to write an excel file with cells containig dropdown list <!--- Create an instance of a new spreadsheet ---> <cfset spreadsheet = spreadsheetNew("My Spreadsheet", true)> <!--- we need all this so we can have dropdowns ---> <cfset workbook = spreadsheet.getWorkBook()> <cfset worksheet = workbook.getSheet("My Spreadsheet")> <cfset dataValidationConstraint = createObject("java","org.apache.poi.xssf.usermodel.XSSFDataValidationConstraint")> <cfset cellRangeList = createObject("java","org.apache.poi.ss.util.CellRangeAddressList")> <cfset dataValidationHelper = createObject("java","org.apache.poi.xssf.usermodel.XSSFDataValidationHelper").init(worksheet)> <!--- Define cell list rowstart, rowend, column start, column end ---> <cfset list = cellRangeList.init(0, 0, 0, 0)> <cfset dvconstraint = dataValidationHelper.createExplicitLis

Hi all,Can anybody help me in resolving this issue. The details are mentioned below.I am generating PDF using <cfdocument> tag of Cold Fusion.I have a header and footer to be displayed on each page. I am rendering data in a table. If rows in the table exceed a page , and continue on the next page , I want the table headers to be repeated on each of the page.Example :Currently this is happening:Page Header Sr NoNameOccupation1AA2BB3CCPage Footer : Page No 1Page Header 4AA5BB6CCPage Footer : Page No 2--------------------------------------------------------------------------------------------------------------------------------------------------------What I want is : Page Header Sr NoNameOccupation1AA2BB3CC Page Footer : Page No 1 Page header Sr NoNameOccupation4AA5BB6CC Page Footer : Page No 2

I have Azure Container Instance running Coldfusion 2021 on Linux Server.I am getting Connection verification failed for PDF Service Manager: localhost.Connect to 127.0.0.1:8993 [/127.0.0.1] failed: Connection refused (Connection refused) http://127.0.0.1:8993/PDFgServlet/verify How to resolve this issue?  

I have a form that has a file input with the multiple attribute set. This form might also have other file uploads.If I use the FileUpload function specifying the multi-file input it will only upload the first file. If I use the FileUploadAll I cannot specify an input name, and it will upload all documents from all upload fields. It doesn't retain any information about which field the files came from, so I now have a jumble of files that I cannot usefully assign anywhere.In the FORM variables we get temp file names e.g. "neotmp11170355642215183856.tmp", but there is no information that I can find that would allow me to cross reference this to the results of FileUploadAll.I did see a post about using binary read operating on the temp filenames in the FORM variable, but this won't help as there is no information available telling me what the uploaded file was supposed to be (pdf/doc/etc) and the original filename.Is there any way around this where I can upload multiple files from "fi

Hi! I have not used CF for a long time and I'm coming back to CF 2021. I kind of recall that the older CF generations abandon CFFORM and CFINPUT or if it wasn't abandon I did not use them in my codes because I remember many CF programmers suggested me not to use them as they cause or may cause many issues (couldn't remember what exactly after all these years). With the newer CF version since 2016 does CF fixed or revised CFFORM and CFINPUT tags and they are now safe to use? I prefer to use these tags if they are not causing issues as I build a lot of forms (simple mostly) and required form authentication for required fields and so on. Using CFFORM, CFINPUTs actually help me speed up my work instead of building javascript everytime. Thank you for validating my knowledge as I've been absent from CF for so long.

Register now!   Adobe Connect is a powerful, flexible application that lets you run webinars, conferences, open office hours, team meetings and more. One of the more useful capabilities is the option of building your own custom pods to handle workloads, provide interactivity and expand the capabilities of Connect. In this session, Mark Takata, Technical Evangelist for Adobe ColdFusion, will take you from 0 – 100 in building a custom Connect pod which leverages Adobe ColdFusion, JavaScript & MySQL to build a custom conference scheduling application. Special guest Alistair Lee will join us briefly to explain Connect’s incredible features & answer questions regarding the Connect SDK.   Register now!

It's the time of the year when your favorite ColdFusion event is back with a bang! The last two years were a challenge for each one of us. The pandemic hit us hard and impacted us all. We had to resort to online meetups and organize the summit virtually.   This year, we are organizing the summit in person in Las Vegas. Grab your seats today. Meet with ace developers, ColdFusion experts, and hear from our own about what's ColdFusion is coming up in its next major release.    ColdFusion is a community-driven platform and we'll love to listen to your feedback and thoughts. Be there in Las Vegas and experience the next wave of innovation.   Key dates: When: Oct 3-4, Las Vegas How to register: Conference website

I design my first front end site using bootstrap.  I then export the bootstrap file into a regular HTML extension. I open the HTML file in dream Weaver and save that file as a.CFM extension. When I go to preview the page, all of the behaviors, the scroll, the modal all no longer works.  When I sAve the file extension back to an HTML file, everything works. Is there a method to allow the same behaviors to work under a cold fusion extensions as it does with the regular HTML extension? Does cold fusion work with bootstrap and JavaScript behaviors?

I installed ColdFusion 2021 and now I catch some error:class coldfusion.runtime.TemplateProxy cannot be cast to class coldfusion.runtime.Struct (coldfusion.runtime.TemplateProxy and coldfusion.runtime.Struct are in unnamed module of loader coldfusion.bootstrap.BootstrapClassLoader @3b2553d9)I investigated the issue and found that we can't use Structure this.EnvStruct.Items directly in the query. I fixed the query:But It's not a good idea, because we have a lot of functions when we use the structure, this code is working in Coldfusion11 and Coldfusion2018.  Could you help me?

Hi folks. I am trying to get data from an array in a JSON file. I create the variable webhook from the JSON. I need to get the product_ID from the two arrays.  When I dump webhook to a file, it looks like this:...line_items:[array]1) [struct]id: 14image:[struct]id: 57src: https://i0.wp.com/www.blah.com/wp-content/uploads/2022/07/block_logo_round.png?fit=1200%2C1200&ssl=1meta_data:[array]1) [struct]display_key: _reduced_stockdisplay_value: 1id: 155key: _reduced_stockvalue: 1name: Block & Tackle Smokehouse and Tavernparent_name: undefinedprice: 19product_id: 56quantity: 1sku: [empty string]subtotal: 19.00subtotal_tax: 0.002) [struct]id: 15image:[struct]id: [empty string]src: [empty string]meta_data:[array]1) [struct]display_key: _reduced_stockdisplay_value: 1id: 156key: _reduced_stockvalue: 1name: Paddle parent_name: undefinedprice: 54product_id: 82quantity: 1sku: [empty string]subtotal: 54.00subtotal_tax: 0.00First, I'm setting count to the Array Length.<cfset count

Hi, I am using Coldfusion 8. In CFIDE I saw "Connection String" parameter under Advanced setting for MSSQL Data connection. I was wondering if we can use it for failover using a connection string like: "Data Source=server1;FailoverPartner=server2;Initial Catalog=db_name;Uid=db_user;Pwd=db_pass;" Where server2 is mirrored database. thanks in advance :)

I am using the following:— ColdFusion 2021— SQL Server Express 2019— SQL Server Management Studio 18.12.1— Dreamweaver I'm trying to set up a data source in the database tab, but when I click on RDS Login, I get the following error message:1. The URL specified for this site's testing server may be incorrect: http://localhost:8500/estimates/2. The testing server may be incorrectly configured (for example, ColdFusion may not be running). I have created a data source in CF Aadmin, and I'm able to connect to the database, if I hard code the query into Dreamweaver, the query and code runs just fine.  I just can't do it through the database panel.  To clarify, the testing server is correct because I can view the files when I type in the URL. The ColdFusion server is running - I checked it in Windows >> Services.  I just can't connect to the database in Dreamweaver's Databases panel. Thank you.    

After upgrading my site from ColdFusion 11 to ColdFusion 2021, I'm receiving error messages that I can't decipher.  Can anyone tell me what is actually failing here?  For example, what does EXCEPTIONS <small><i>not set</i></small> mean? Funny that.  I've been doing this for two decades now and this is the first time I've been stumped by a ColdFusion error message.  I guess there's a first time for everything.  😄 Any assistance is appreciated.

Running into a cfimage problem trying to convert a tiff image to a PNG or JPG. PNG conversion results in a 0 byte file.  JPG conversion produces am image, but it is a negative of the original.<cfimage source="test.tif" action="convert" destination="test.jpg" overwrite="true">

When I first started writing ColdFusion code (in the Allaire days) a CFChart line graph would allow one to mouseover a datapoint and it would pop up the values of both axes in a sort of tooltip. When I upgraded to CF11 I lost the X axis information and would just get the Y axis datapoint. That sucked out loud, but I dealt with it. But now I've upgraded to CF2021 and have lost all the tooltip popups. I tried JPG, PNG, and HTML (which failed completely). What's going on? I have not changed the code since the earliest incarnation. I've attached one of the sections of code.

We have been developing ColdFusion applications for over 20 years and I cannot believe what I am seeing with the Adobe ColdFusion 2021 pricing. We have a client that we have been developing and maintaining an application for since the year 2000, one of oldest clients. Recently they sold the one divisions that uses the application to another company. So, they are going through the process of separating the parts of the business and moving the applications and network to the new entity. The new company have decided to move all the infrastructure from inhouse hosted systems to a Microsoft Azure hosted system. It is 2022, so they may as well host everything in the Cloud, makes senses and what better time to do it then we you have to set up all the systems. The current application is used by approximately 100 employees and is used inhouse only. The current system runs on Adobe ColdFusion Server 2016 Standard Edition with a Microsoft SQL Server back end. It isn’t a very complex sys