ColdFusion

Hi,  So I've setup an event gateway in CF 2016.. Service is enabled, when I look at my instance, it does report events coming in and out, but my code does not execute. I put a simple file write as a test in there and it never creates file. Full code: my.cfc file<cfcomponent output="false"><cffunction name="onIncomingMessage" >  <cfargument name="CFEvent" type="struct" required="yes">     <cfset filewrite( "c:\rave7\temp\smsdev\yo.txt", "oooooo")>     <cfreturn true>  </cffunction></cfcomponent> Calling code:<cfscript>status = false;props = structNew();props.Message = "yo #now()#";status = SendGatewayMessage("vorText SMS", props);if (status IS True) WriteOutput('Event Message "#props.Message#" has been sent.');</cfscript> Any thoughts??  

I am experiencing a very strange behavior with respect to default document processing.If I explicitly go to https://server/index.cfm, the page loads without issue.If I go to https://server/  I am getting the following error: Detailed Error Information:ModuleNotificationHandlerError Code    IsapiModule   ExecuteRequestHandler   cfmHandler   0x80070003Requested URLPhysical PathLogon MethodLogon User    https://server:443/index.cfm   E:\Sites\server\index.cfm   Negotiate   AuthenticatedUser I have enabled failed request tracing in IIS, but nothing is being logged there either.

We are upgradging to CF2021 and have a few text files that we are accessing via a JDBC to text driver. Foermely, we used the fostex driver with CF9.   We found StelsCSV but are having issues getting it to work correctly.  We are getting an error "[StelsCSV JDBC driver] Can't load the file 'txt.txt' to H2 database. Error was: File 'D:\ProcessData_DEV\txt.txt' doesn't exist"  I'm not sure where it's getting txt.txt from .  We don't have that configured anywhere. Are there alternate drivers out there that are easy to get set up? Thank you, -=Rob=-

We are moving to a DevOps model to increase consistency and reliability accross environments. As part of this we are moving to CF2021 (Windows). The silent install seemed like a big step in the right direction, but I can't find any documentation on installing and configuring multiple instances from the cmd line. If anyone has any documentation on how to script this, it would be a huge help. It would also be great if some of the official documentation would include some commands to go with each step that they manually describe. The manual approach lends itsself to mistakes. For example when they talk about enabling features, they could easily include some commands and save us all some time. Here is the cmd script for the features that we need for CF on IIS. Hope it helps someone. # Install Windows FeaturesInstall-WindowsFeature –name Web-ServerEnable-WindowsOptionalFeature -online -FeatureName IIS-WebServerRoleEnable-WindowsOptionalFeature -Online -FeatureName IIS-WebServerEna

I just change my laptop to a new one that has 3200 x 1800 resolution, but when opening CF Builder the tool bars and icons display very small, even the home screen shows very small.I tried with a lower resolution but the IDE displays the same.Is there any fix to this?Thanks.

I have been trying to downoload the Builder from the linke https://www.adobe.com/products/coldfusion-builder/download-trial/try.html, but I am just sent do a "Get Started" page, and nothing downloads.  I have been in contact with customer support via the chat for four days and no progress has been made. When I said the product was ColdFusion Buiilder, I was connected to the photography department. Does anyone have any ideas as to how I can make progress?

After installing this update, all IIS sites show the following message:You do not have permission to view this directory or page. No other changes to the server have been made.  This looks to be a permissions issue, but I cannot tell why.  I tried re-applying NTFS permissions from the root directory (c:\ColdFusion2018), but that did not work.  Also, when I try to uninstall the update using the following command:java -jar C:\ColdFusion2018\cfusion\hf-updates\hf-2018-00012-328566\uninstall /uninstaller.jarThe command prompt returns the following error: Error: Unable to access jarfile C:\ColdFusion2018\cfusion\hf-updates\hf-2018-00012-328566\uninstall I was able to uninstall the update manually by stopping the CF service, deleting the jar file and copying the files and folders back to the instance root directory.  I restarted the CF service and everything works fine. Here are the server details:Windows 2019, CF2018 Update 11 Any help is really

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...