ColdFusion

I'm looking for a way to delete a file on amazon s3. I'm able to upload files no problem but I can't find any documentation on a deleteFile method.  Does it exist? In case this helps someone, here's the CFSCRIPT I use to upload a file after setting up the Amazon S3 cloud service in the administrator (NOTE: filekey is the directory in the bucket):s3Service = getCloudService('awss3', 's3conf');bucketObj = s3Service.root("MYBUCKET","true");uploadStruct = {"srcFile" : fullfilename,"key" : filekey & cffile.serverFile,"acl" : "PUBLIC_READ","metadata":{"place":"us-east-2","deployment":"Production"}}try{uploadResponse=bucketObj.uploadFile(uploadStruct)writeOutput("Object uploaded successfully")writeDump(uploadResponse)}catch (any e){writeOutput("Could not upload the object")writeDump(e)}

I am getting a JSON parsing error (JSON parsing failure: Expected ',' or '}' ) when I try to serialize content returned from an external web service. The content has a double quote in it so CF does not view it as valid JSON. I know you can add a character to escape it, but I do not control the web service so how can I escape the character or format the json content so I can serialize it?<cfhttp method="get" url="MyAPIURL" result="GetJSONResult"><cfhttpparam type="Header" Name="Ocp-Apim-Subscription-Key" value="MyKey"></cfhttp><cfset JSONResult = deserializeJson(GetJSONResult.filecontent)><cfdump var="#JSONResult #">Here is how the JSON is formatted.[{"id": "1234","description": "Stud 2" x 4" x 8ft long "}]

Hello everyone:I wonder if anyone has ever built an Dynamic Organization Chart using ColdFusion without using any plug-in?I know there is some librayry or plug-in will hep you to do so like https://www.jqueryscript.net/demo/Family-Tree-Organization-Chart-jHTree/Thank you in advance 

I have a dropdown form from which the user selects from a list of query populated options (code blow). This query is in the mycars.cfm page whitch is within my views folder.  <h3>Car Names</h3> <cfquery name="carbrands" > SELECT * FROM carcompany WHERE cartype_id = 6 </cfquery> <cfform name="mycars" action="?????.cfm"> <cfselect name="carbrandsearch" query="carbrands" value="car_name" display="car_name"> </cfselect>  I am looking to pass the users selected option (let say Mazda) into a variable so that I can pass that variable into other queries down the page. I am not sure how to do this. I have tried to tie the submit button to the active page itself but continously get this error - File not found: /views/mycars.cfm. However this is the very page that my dropdown is on so I do not understand why it is giving me this error.  I've also heard mention of the bind function but I am not sure how to use it/if it i

I have a pretty simple query that takes about one (1) second to run directly in my Oracle client. SELECT <fields>FROM <view> sWHERE <field value> = 30ORDER BY <fields> There are only 404 rows that are being returned. When this same query is executed through a <cfquery> tag, it takes upwards of 35 seconds for the request to complete.  It's not the datasource because we run thousands of queries against this same datasource without any issues. Many of them return thousands of records.  Any direction is appreciated in what and how to look for the bottleneck. Thank you.

I am rebuilding and upgrading from CF10 to CF2021. I'm encountering some problems with the Chart Package. I was finding messages indicating that the Chart Package was not installed. I tried installing it but it responded with a message indicating that the package was already installed. I check the Package Manager and everthing looks fine.Next I try removing and reinstalling the Chart Package. Removal works fine but then refuses to reinstall the package and suggests checking the lots for additional information. I go through the logs but don't find anything that indicates the source of the problem.Test Package Manager and works perfectly, removing and adding other packages. Try rebooting. Try installing an  older version of the Chart Package. Maybe the Chart Package file is mangled.

Hi all,As a reminder, I am not a programmer, far from it.  Please forgive the poor design.  This is for a small intranet, so I am not looking to improve what we're working with.I have an employees table.  In that table I have these columns that I am interested in working with:First_NameLast_nameSup (more on that in a minute)Job TitleI want to display the Supervisors in a column with their staff, by group, under them.  The number of Sups will vary over time.  Today it's four, in a few months it will be three...This is what I am looking for:OK, so the Sup column form the database.If the employee is a Supervisor, they have a 0 in the Sup column.Reporting staff then have the Supervisor's employee number in their Sup column establishing who reports to whom.I have been able to get the column display for the Supervisors but cannot figure out how to get the staff listed (in groups) under them.Here is what I am using:<cfquery name="Sups" DataSource="#APPLICATION.DSN#

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSf23b27ebc7b554b6c43bda313671e094bb-8000.html

Bonjour,Quelqu'un a-t-il fait automatiquement des paiements à une date donnée ?Et avec quel établissement ?Merci par avance Hello,Did someone automatically make payments on a particular date?And with which establishment?thanks in advance

 - do you have to install the 2021 code on top of the 2016 installation, or in a new directory?- How can you specify an empty context root, so that you can have code like <node>/file.cfm  The installer forces a non empty value. 

I configured the proxy settings in CF Admin > Package Manager > Settings > Proxy Settings. The error I get is, "An error has occurred while installing the package sqlserver. Please check logs for more details."I checked the logs and it says, "An error has occurred while installing the package sqlserver. Exception : null"I attempted the install via the interactive cli and I get the following:The packages repository https://www.adobe.com/go/coldfusion-packages is not accessible. You can only load the packages that are available locally in the /opt/coldfusion/bundles directory.The following packages will be installed : sqlserver:2021.0.02.328618Downloading the dependent package bcpkix-jdk15on-153.jarDownloading the dependent package joda-time-2.8.jarDownloading the dependent package adobe_sqlserverdriver-6.0.jarDownloading the dependent package adobe_drivers_common-2.0.jarAn error has occurred while installing the package sqlserver. Exception : nullsqlserver package is unins

After installing the update, form variables being sent as a list, cannot be read as a simple values, they are now being sent as arrays.error message is  Complex object types cannot be converted to simple values

This is quite strange... the majority of my IIS redirects are working, but this one for some reason is odd.www.myserver.com leads to www.mynewserver.com no problem... works as it should.www.myserver.com/about leads to www.mynewserver.com/about ... again, works as it should.however, this is weird.www.myserver.com/main.cfm leads to www.mynewserver.com/jakarta/isapi_redirect.dllI'm trying to figure out why, how can I fix this so thatwww.myserver.com/main.cfm leads to www.mynewserver.com/main.cfm

Hello allOnce again, CF installation woes, this time with version 2021. I decided to download the complete installer .bin file, as the "zip" installer didn't work either, and I would like to migrate the current CF2016 settings if possible. I am attempting to install CF20216 on a fresh server (Ubuntu 20.04.3 LTS (GNU/Linux 5.4.0-81-generic x86_64)). After downloading, I simply installed apache2 (apt install apache2) and proceeded to run ./ColdFusion_2021_GUI_WWEJ_linux64.bin.Answered all the questions, and low and behold - failed with this little diddy:Stack Trace:java.lang.NoClassDefFoundError: Could not initialize class java.awt.Toolkit Any help would be appreciated.Thanks in advance Installation Log:__________________________________________________________________________Tue Nov 02 09:24:24 UTC 2021Free Memory: 185706 kBTotal Memory: 253440 kBjava.class.path:    /tmp/install.dir.2033/InstallerData    /tmp/install.dir.2033/InstallerData/installer.zi

Howdy,Recently migrated from CF2016 to CF2021- it seems to have gone relatively smoothly, except we have at least some scheduled tasks that appear to be firing twice.This is a single standalone server.New install of CF2021 on it.No dev server running- this is it for now.A check of the Task Manager appears to show only one instance of CF running.scheduler.log shows the task firing only once ar a given time.But the task code has a CFLOG at the top that writes to a separate log file, and it is chock full of lines like:"Information","ajp-nio-127.0.0.1-8020-exec-188","10/30/21","13:30:00","APPName","Task Start- Check Interval Start: 2021-10-30T17:00:02 End: 2021-10-30T17:15:00" "Information","ajp-nio-127.0.0.1-8020-exec-140","10/30/21","13:30:00","APPName","Task Start- Check Interval Start: 2021-10-30T17:00:02 End: 2021-10-30T17:15:00"You can see the entries are the same except for the thread IDs, and the task is essentially run twice, with mayhem ensuing. Looking for any ideas to track t

Hi   Since upgrading to Big Sur on MacOS I have found that ColdFusion Builder 2018 will not start up fully.   Initially it quit before startup with java.lang.NullPointerException    --- !ENTRY org.eclipse.jdt.compiler.tool.nl_ja 2 0 2020-11-17 11:41:23.455!MESSAGE Could not resolve module: org.eclipse.jdt.compiler.tool.nl_ja [451]Unresolved requirement: Fragment-Host: org.eclipse.jdt.compiler.toolUnresolved requirement: Fragment-Host: org.eclipse.jdt.compiler.tool !ENTRY org.eclipse.osgi.compatibility.state.nl_ja 2 0 2020-11-17 11:41:23.455!MESSAGE Could not resolve module: org.eclipse.osgi.compatibility.state.nl_ja [473]Unresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.stateUnresolved requirement: Fragment-Host: org.eclipse.osgi.compatibility.state !ENTRY org.eclipse.jdt.compiler.apt.nl_ja 2 0 2020-11-17 11:41:23.460!MESSAGE Could not resolve module: org.eclipse.jdt.compiler.apt.nl_ja [450]Unresolved requirement: Fragment-Host: org.eclipse.

ColdFusion 2021 Update 2 (2021.0.02.328618) WINx64Java VM Version 11.0.11+9-LTS-194  <cfoutput>#DateFormat("01/01/1982","dd-Mmm-yyyy")#</cfoutput> Thrown the same error with "01-Jan-1982" and all different date format for 01/01/1982.No issue for dates like 02/01/1982, 01/01/1981, etc. Had tried to run the same code on cffidle.org but no error was thrown.A quick check was that cffidle was running on Linux while mine was on Windows. The error is as below: - 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 RequestParameter validation error for the DATEFORMAT function.The value of parameter 1, which is currently 01/01/1982, must be a class java.util.Date value. The error occurred in D:/wwwroot/test_cf2021_date.cfm: line 31 : <cfoutput> 2 : 3 : #DateFormat

Hi Team,My application front end is coldfusion 2021 and back end is Oracle database so now we are migrating our application into Azure services.1. Is azure supports Oracle database?? Thanks...

Hello, We are upgrading ColdFusion from 2016 to 2021. So, is 2016 CF code will it work on 2021.?

Hello, Can I have CF 9 and CF2021 tags and functions details. I want to know whcih tags and functions are not supported in CF2021 from which we used in CF9.

I have created two VMs(windows 2012r2 and 2019), fully updated, onto vmware. I have installed coldfusion 2021 enterprise(trial), x64, update 2 on both. I have selected production + secure profile, .net/pdf/solr and the default options for the rest. Right after the installation when I log into CF administrator and click enable sandbox security and restart the CF application service after that, it times out and I have to change the config for sbs in neo-security.xml to be abe to start the service again. This happanes on both VMs with fresh windows installations and fresh CF installations. The lockdown tool does not make any difference. The logs do not contain any useful information, the service just times out. The jvm.config file looks fine to me. The timeout is 240 seconds.Am I missing anything here? What can I try to get this working?

HelloI know I'm living in the past here- Macromedia Homesite- what an amazing IDE in its day. Not easy to replace. I've tried many times to use Dreamweaver but never got it to just show a simple uncluttered interface like MMH. Just edit & browse- resource tab on the left showing the webroot and the cfm files split screen. Supposed to be able to choose what browser to use but that ability went south with the acceleration of browser technology. In MMH, one can choose Netscape! Drag & drop table & column names once a DB connection is established. Simple.I have no idea if Builder can be set up this way. It would be great if someone has succeeded in setting up any CF IDE like this?Thanks! see below 

Hi Team,I am working on coldfusion9 application now we want migrate our application to coldfusion 2021 in this context we want to know1. If we migrate our application coldfusion 9 to coldfusion 2021 do we need to do any code modifications after migration or simply migrating to Coldfusion 2021 does all the things? 2. Because coldfusion 2021 has cloud support does our coldfusion 9 code will work in the cloud after migration..if it will work what are all the code & configuration level modifications we need to do? Looking for your earliest reply..... Thanks.....

I have an interesting issue.  I have installed CF2021 side by side with an existing cf 2016 version in order to evaluate the functionality of all components before releasing it.  When I remove the connectors from 2016 and rebuild them with 2021 all appears to work ok.  We have a nightly reboot of the server scheduled and the next day after the server has come up, none of the sites work and I get an SSL error.I/O Exception: java.security.NoSuchAlgorithmException: Error constructing implementation (algorithm: Default, provider: SunJSSE, class: sun.security.ssl.SSLContextImpl$DefaultSSLContext)The problem goes away after restarting the coldfusion service but will, and not always, return after a server reboot.   I have removed the connectors from 2021 and placed them back on 2016 except one test site which after every server reboot has no errors in testing the cfhttp or ssl connections by itself.  The only time I have been able to force the problem is by addin

Hello All:I tried to read password protected excel file by using this line of code<cfspreadsheet action="read" query="MyControlPanelQuery" src="D:/LocalDocuments/FileName.xlsx">I gave me this error "An error occurred while reading the Excel: org.apache.poi.EncryptedDocumentException: The supplied spreadsheet is protected, but no password was supplied"I got this kind of error because the FileName.xlsx is password protectedThe thing is "<cfspreadsheet action="read"....> doesn't any attribute to read a password protected excel file.Any advice please? Thank you