ColdFusion

Hi, I've had to increase the allocated memory once before but I forget where to do it? I've looked through CF admin but I must be missing it. Thanks in advance... Gary 

I have just started using PostgreSQL as a datasource for ColdFusion Server 2021 Developer Ed. Used DBeaver to export a legacy MS Access 2007 database into a PostgreSQL 12 database which sits under a schema Datasource registered OK. I ran a cfquery against a table.______________<CFQUERYname="qryFrameworkListRender"datasource="PostgreSQL35W">SELECTPipiObjectClassFrameworkID,PipiObjectClassFrameworkCodePage,PipiObjectClassFrameworkName,PipiObjectClassFrameworkDescription,PipiObjectClassFrameworkExample,PipiObjectClassFrameworkNoteFROMtblpipiobjectclassframeworkWHERE(((PIPI_OK)=Yes))ORDER BYPIPI_Sort, PipiObjectClassFrameworkName;</CFQUERY> ______________ This error shows up. I'm puzzled. The table name is spelt correctly.-----Error Executing Database Query.ERROR: relation "tblpipiobjectclassframework" does not exist Position: 234  The error occurred in C:/ColdFusion2021/cfusion/wwwroot/pipi/framework.cfm: line 2927 : <CFQUERY 28 : name="qryFrameworkList

Good day,I would like to know if there is documentation that explains the field headers in CF2021 so that I may better ingest them into our SIEM Solution.  I have no experience with CF in past and am finding it difficult to locate information about what is being conveyed in the various logs.  Any information is appreciated.Best regards,Greg

Can anyone help me out with settings to get Coldfusion to relay through Gsuite/ Google Workspace. I keep getting mail rejected. Apparently I "must configure your mail server either to use SMTP AUTH to identify the sending domain or to present one of your domain names in the HELO or EHLO command." but I don't know how I would do that with ColdFusion. Thank you.

Hello,Using coldfusion 2016. have some queries related to character entity values.Tried html equivalent character entity for replacing trademark and apostrphe special characters. Function used is given below.private any function specialCharUpdate(strData){// Ampersandarguments.strData = replacenocase(strData, '&', '&##38;', 'All');// ™ trademark// arguments.strData = replace(strData, '™', '&##8482;', 'All');arguments.strData = replacenocase(strData, '™', ' &##153;', 'All');// Apostrophearguments.strData = replacenocase(strData, '''', '&##39;', 'All');arguments.strData = replacenocase(strData, '’', '&##39;', 'All');// Circlearguments.strData = replacenocase(strData, '®', '&##174;', 'All');// Copyrightarguments.strData = replacenocase(strData, '©', '&##169;', 'All');return arguments.strData;} 1) The apostrphe from keyboard ' is getting replaced with 'But another kind of apostrphe ’ is not getting replaced with either ' or «Thi

Does anyone know where to download ColdFusion Builder 2016?  The official URL Adobe - ColdFusion Support Center : More Downloads does not provide a correct download. Thank you in advance for your help, -Chris 

I have a server running CF2018, serving multiple websites.  In CFAdmin, in Mail Server Settings, I have specified the address for our internal email server.  Email generated in this configuration is flowing properly, and has been for years.  What I recently found is that, regardless of the source domain, all emails being passed on to our email server are having the "From" entry in their header file set to the same domain, instead of each email header "From" entry being set to the domain that generated the email.  We are using Exchange 2010 on the internal email server. How do I reconfigure our environment to address the above issue?  As all sites are sending email through the same channel, via CF, is differentiation even possible?

Hi all - I have a clustered environment of three CF Enterprise servers (bare metal) each running four clustered instances.  After much testing, we recently put these into production and are experiencing frequent errors.  This seemingly causes the instance to hang, and requires manually stopping the instance, waiting a few moments and then restarting.    This is happening at random to all instances, across all three bare metal servers, multiple times a day.   It's a full time job identifying the failed server and CF instance, and then restarting it.   Does anyone have any suggestions on how to diagnose the issue? From the coldfusion-error log on a failed instance, we see: Jul 19, 2021 6:27:59 PM org.apache.commons.digester3.Digester startElement SEVERE: Begin event threw exception java.lang.ClassNotFoundException: net.sf.jasperreports.engine.xml.JasperDesignFactory at coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapCla

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.