ColdFusion

HelloI need to keep the accent marks in the SQL Server database.My imported data (4000 + records) from a CSV in Excel contains hundreds of French diacriticals:é –  (l'accent aigu)à/è/ì/ò/ù – (l'accent grave)â/ê/î/ô/û –  (l'accent circonflexe)ç – (la cédille)ë/ï/ü –  (l'accent tréma)Each instance in the strings have changed to ? diamonds no matter what they were supposed to be. Is there a way to repair them after they have been imported or do I need to do this in the CSV file before the import, if possible?  What character encoding will SQL Server keep?Thanks for any help with this.

Hello, part of our website is down and our institution uses Cold Fusion.  Currently our primary support person is not available.  Can anyone suggest a company or group that might be able to help?  We are located in Western NY.  Thanks!

Just a heads-up: the URL for joining the CFML Slack workspace and channels has changed. If you want to join the CFML Slack, use the form at cfml-slack.net.   As some may have noticed, the old URL for joining (cfml-slack.herokuapp.com) no longer works. Since it's mentioned in many places on the web, I wanted to help spread this news. This cfml-slack.net URL replaces that one, while the URL for the CFML Slack channel itself is unchanged: cfml.slack.com.   For more explanation/context, and especially if you may be new to considering the CFML Slack, see my blog post with more on this recent change.

Back in ColdFusion 10 we developed a few APIs using the new (at the time) abilities of CF to publish REST services.  Fast forward to now and we're looking to make some upgrades in how the APIs are published and how we manage them.  First we looked at the ColdFusion API Manager that Adobe began giving away in CF2016.  While this looked to have promise, we're running into issues with it and a lack of support know how.  So, we're thinking of going with a service more popular with the rest of the world. As we've dug further, we're intrigued with Rapid API and publishing on their platform.  Going through the setup, there is an option to upload your OpenAPI specs to auto-load your API.  However, the earliest version of Swagger/OpenAPI they support is 2.0.  Unfortunately, it seems Adobe has let this part of ColdFusion languish without an update because CF only produces Swagger 1.2 docs. Does anyone know if CF will be updating their Swagger/Ope

HelloI'm using a query to match first & last names from a main table (ged_main-3543 records) on a lookup table (marier_main- 264 records). When I use this query, I get 25 matches:<cfquery name="match_ged_fam" datasource="#Request.BaseDSN#">SELECT ged_lastname, ged_firstname, ged_datebirth, ged_placebirth, ged_datedeath, ged_placedeath, marier_lastname, marier_firstnameFROM ged_main, marier_mainWHERE ged_lastname LIKE marier_lastnameAND marier_firstname LIKE ged_firstname</cfquery> When I use this query, I get 67 matches: <cfquery name="match_fam_name" datasource="#Request.BaseDSN#">SELECT ged_lastname, ged_firstname, ged_datebirth, ged_placebirth, ged_datedeath, ged_placedeathFROM ged_main t1WHERE exists(SELECT marier_lastname, marier_firstnameFROM marier_main t2WHERE CHARINDEX(t2.marier_lastname,t1.ged_lastname)>0AND CHARINDEX(t2.marier_firstname,t1.ged_firstname)>0)</cfquery> I am trying to figure out why the results are not the s

We have a failing web server, and legacy Coldfusion Application I am trying to migrate to a new server.So I have a new server I am installing on and going from CF 2016 to 21. Things for the most part are working fine, but I am stumped on one error. I am not a CF guy , just inherited an app. Years ago I had to do an upgrade form one older version to another and found it was due to variable case sensitivity changing so I have hunted around in the past as well. I keep thinking the behavior means something small is missing like that variable I have seen in the past Out of a few menu choices, one lets me run a few queries and export to excel. The queries run fine but I get an immediate 503 error when I try to export. One of the other tabs has export code and works with no problem.if I hit the website(its an internal website) using http://192.XXX.X.XX:8500/WEBSITE, I get no errors at all, even on the menu that perviously errors. The 503 error is if I hit it by name http://intr

Hello - I have CF 2021 and it was installed last year. We have a license for it but recently within the last 2 weeks it displays a message saying that we have 15 days left in the grace period. However it is not counting down each day I login. Is this a bug of some sort?  How do I fix this? I am currently on update 3. Thank you!  

After installing Update 5 for CF2021 and updating the JDK from 11.0.14 to 11.0.17<cfdocument no longers works if the encryption attribute is specified. We've tried document-2021.0.05.330109.jar (two versions, one from the update 1,831kb, and one sent to us from CF Support: 4,233kb) i.e.<cfdocumentfilename = "MyFile.pdf"format = "PDF"fontembed = "yes"mimetype = "text/html"encryption="128-bit"permissions = "AllowPrinting,AllowCopy">My Content</cfdocument>Fails with no error message. Removingencryption="128-bit"permissions = "AllowPrinting,AllowCopy"works, although the pdf can then be edited. Good:<cfdocumentfilename = "MyFile.pdf"format = "PDF"fontembed = "yes"mimetype = "text/html" >My Content</cfdocument>

I have Azure Container Instance running Coldfusion 2021 and Apache on Linux Server.I am using the mod_jk connector.I am getting the following error sometimes. java.lang.NullPointerException at coldfusion.runtime.ClientScopeServiceImpl.GetClientScope(ClientScopeServiceImpl.java:330) at coldfusion.runtime.AppHelper.setupClientScope(AppHelper.java:971) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:503) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(Br

UPDATE 10/19/2022: Added information about refreshed installers. Thank you @Charlie Arehart for this.   We are pleased to announce that we have released the updates for the following ColdFusion versions: ColdFusion (2021 release) Update 5 ColdFusion (2018 release) Update 15   In these updates, we’ve fixed a few security and feature-specific bugs, along with other libraries. We’ve also introduced support for M1 macOS.   We've also refreshed ColdFusion 2021 installers. You can find the refreshed installers on the ColdFusion downloads page.   For more information, see the tech notes below: ColdFusion (2021 release) Update 5 ColdFusion (2018 release) Update 15   NOTE: After applying this update, you must reinstall any custom hotfixes that might have been applied earlier. The hotfixes for ColdFusion 2021 Update 4 are located in the folder, /ColdFusion2021/cfusion/hf-updates/hf-2021-00005-330109/backup/lib/updates.   These updates fi

I'm recieving this message when i try to look up what shcedules are setup in this instance of CF. I'm not sure what or if there are schedules running but I get this message even after restarting the CF system. Server DetailsServer ProductColdFusionVersion2016,0,03,301771EditionStandard  Operating SystemWindows Server 2012 R2  OS Version6.3  Adobe Driver Version5.1.4 (Build 0001)  Tomcat Version8.0.32.0   Error Occurred While Processing RequestThe system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.Null Pointers are another name for undefined values.The error occurred in scheduletasks.cfm: line 201-1 : Unable to display error's location in a CFML template.Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.Browser Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36

Our current installation and setup: Server ProductColdFusionVersion2018,0,08,318307EditionEnterprise Trial  Operating SystemUNIX  OS Version3.10.0-1127.el7.x86_64  Update Level/mnt/data-drive/jboss-eap-7.1/standalone/deployments/8888888/cfusion.war/WEB-INF/cfusion/lib/updates/chf20180008.jaAdobe Driver Version5.1.4 (Build 0001)   We have purchased CF version 2021. Our issue is, CF2021 License Key is not compatible with CF2018. Is CF 2021 License Key is backwards compatible?

First of all, this is NOT about a Flash app or the Flash Player. We know that ship has sailed. The client has a legacy front-end desktop executable which was compiled from mxml/as files and runs on the AIR application platform - on many devices in a closed network. So, a console, and not a web or browser-based app.The back-end data & biz rules are provided by a ColdFusion 11 server via a homegrown API that pumps traffic through the /flex2gateway/ daemon.Obviously they need to migrate to CF2021, right away - IMO. I'd also like them to rework this front end too, but that's a 2 year project at least. Anywhoo: When I hit the /CFIDE/flex2gateway/ folder on my development version of 2021, I get a plain 404. So it's not there?Does this mean the support is entirely missing (deprecated) now? Or maybe it's hidden behind some lockdown defaults and config fiddling?I've heard of a possible solution using Lucee and BlazeDS, but I'd prefer to exhaust the ACF options first. I k

We're experiencing occasional "class not found" errors after modifying a java jar set to reloadOnChange.These are the settings we use in our various application.cfc(s): this.javaSettings = {LoadPaths = [ 'G:\www\_config\autoLoadJar\' ], loadColdFusionClassPath = true, reloadOnChange= true, watchInterval = 5, watchExtensions = "jar,class,xml" }; In our server farm we have a number of servers hosting a dozen plus different web applications each with ColdFusion 2021. Generally the jar loading works as expected, but sometimes after updating a jar, although most the applications function correctly and recognize the change, one or two will lose access to any of the classes in the updated jar. Any request to a page or cfc referencing a class file results in a "class not found" error. Resetting the specific application or restarting the service fixes the issue. Note that other applications on the same machine function correctly. Any help would be appreciated. Arthur&nb

Hi, Stack; IIS+CF2021 I'm trying to use the ColdFusion Security Sandbox with a pretty sophisticated ecosystem and I've noticed that parts of it tend to give java access denied errors if they are not accessed with the proper caseSensitivity. Imagine you have a sandbox entry for:E:\inetpub\wwwroot\someDirectory\That allows you to see:E:\someFiles\ and E:\someFiles\- This all works great in most cases. But then if someone gets to the website like https://someweb.com/someDirectory/index.cfm  it works fine.Then if they somehow get to https://someweb.com/somedirectory/index.cfm  It does NOT always work. The error message with the 'access denied' ALWAYS has the exception error struct with the relevant tag.Context."TEMPLATE" member saying:E:\inetpub\wwwroot\somedirectory\index.cfm You can go correct the link in your browser:https://someweb.com/someDirectory/index.cfm  And it might still fail. IIS captures the link right in the lo

  This session will walk you through everything there is to know about PMT architecture and the configurations to look out for when installing PMT on your systems. Get a deeper look at how data flows in the system and the configuration files where the data is stored. Explore the common customer issues and find out how using archiving can reduce the disk consumption.   Nimit Sharma from the ColdFusion engineering team will take you into a journey of PMT and how PMT can help you monitor your servers.   YouTube recording   Webinar link (registration closed)  When:  July 30, 2020 10 am PT  

I'd like to be able to use a hex value for color like: <cfset SpreadsheetFormatCell(xl,{color="#FE0000",fgcolor="#Clr#"},#xl.rowcount#,1)> or <cfset SpreadsheetFormatCell(xl,{color="#355f91",fgcolor="#Clr#"},#xl.rowcount#,1)> Currently you can only use this list of predefined colors:Colors="black,brown,olive_green,dark_green,dark_teal,dark_blue,indigo,grey_80_percent,orange,dark_yellow,green,teal,blue,blue_grey,grey_50_percent,red,light_orange,lime,sea_green,aqua,light_blue,violet,grey_40_percent,pink,gold,yellow,bright_green,turquoise,dark_red,sky_blue,plum,grey_25_percent,rose,light_yellow,light_green,light_turquoise,light_turquoise,pale_blue,lavender,white,cornflower_blue,lemon_chiffon,maroon,orchid,coral,royal_blue,light_cornflower_blue"

Hi.How can I do a cfhttp POST call, to API, in CF21, with this required parmeters:APIKEY (string) header; DOC (file pdf) formdata; TEXT (string) formdata Something like this:"<cffile action="readBinary" file="filePathName" variable="attachedFile"><cfset attachedFile=binaryEncode(attachedFile,"BASE64")><cfhttp url="#externalUrlToCall_notColdfusion#" method="POST" charset="utf-8" result="apiresult" timeout="10" multipart="yes" multipartType="form-data"><cfhttpparam type="header" name="Content-Type" value="multipart/form-data"> <cfhttpparam type="header" name="APIKEY" value="#CONSTapiKey#"><cfhttpparam type="header" name="Content-Disposition" value="form-data; name='DOC'; filename='fileName'"><cfhttpparam type="formfield" name="DOC" value="#attachedFile#"><cfhttpparam type="formfield" name="TEXT" value="Hello"></cfhttp>"  I'm new in API call and this don't work in CF 21 (in postman or python it works).What am I doin

Hello all, We recently upgraded to Coldfusion 2021 from a working Coldfusion 9. One of the applicatons uses the jquery .ajax function and serializeJSOn in Coldfusion.  Under version 9, it all works well, and returns to the javascript an array with ROWCOUNT, COLUMNS, and DATA.   Under 2021, it does not work properly.  After some research, I have changed the #SerializeJSON(goat, true)# to #SerializeJSON(goat, "Struct" )#, and tried other various things.   Interestingly, the 2021 javascript is not even fired under the "success" option in .ajax.   Could anyone point me in the right direction? Thanks, Jim

My team develops and maintains a Coldfusion application (using CF 2018 Update 15) including multiple occasionally connected clients using the flex gateway for data exchange.Currently our application is being migrated to new server infrastructure and on the new servers we need help with a problem. On the old servers we had the following JVM timezone configuration: -Duser.timezone=NewYorkThis had to be added because without this timezone parameter some objects could not be synchronized between the flex clients and the server. All of our servers are in timezone CET, but on the old servers everything worked well. The time used in the Coldfusion application was server time (CET). On the new servers with the same JVM configuration the server time again is CET, but Coldfusion now internally uses timezone NewYork. When we configure CET in the JVM everything is ok in the Web application, but again the Flex clients fail to synchronize. The only difference I can see betwe

We would like to update our Coldfusion servers from CF 2018 to CF 2021, but we still have mobile apps using flash remoting in connection with the coldfusion servers. We are working on replacing those apps, but this needs time.On the page about deprecated features I can see that the flash remoting was retired in CF 2018 but I do not see that it was removed in CF 2021.But when I install CF 2021 there is no administration for flash remoting any more and I did not find out how to get it alive again.Is it possible to use flash remoting in CF 2021 or was it removed without documentation on the deprecated features page?

Sans CFdocument !Avec CFdocument !  La présentation n'est plus la même ! Problème de police de caractères et de mise en place, ...Le fautif : <CFDOCUMENT format="pdf" filename="../../#session.site#/_Facturier/Facture_#Session.Fac#.pdf" pagetype="A4" unit="cm" overwrite="true">De plus, joint à email, il ne s'ouvre pas !Merci par avance pour votre aide.MEILLEURS VOEUX pour 2023.

I would like to be able to format part of a cell so that the output looks like:Updated for SSEWG: Yes Date: 8/31/2022instead of having to put each section into a different cell like:Updated for SSEWG:YesDate:31-Aug-2022                

Hello, first off I stink at CSS. Issue is I can't get all the buttons to be dead center in their div when they're in a form field. So far I can only get one to do it (which is odd). You can see I don't really know how to use grid-column or grid-rows that well. Please help fix this: <html> <head> <style> div.container { display: grid; grid-template-columns: 100px 20px auto; grid-template-rows: auto; margin-left: auto; margin-right: auto; } div.header { grid-column-start: 1; grid-column-end: 5; grid-row-start: 1; grid-row-end: 5; background-color: white; width: 100px; border: 1px solid #000000; } div.fouth { grid-column-end: 4; grid-row-start: 3; grid-row-end; 3; background-color: Silver; width: 100px; height: 30px; border: 1px solid #000000; display: flex; justify-content: center; align-items: center; } div.middle { grid-column-start: 3; grid-column-end: 5; grid-row-start: 1; grid-row-end; 1; background-color: Silver; width: 100px; height: 30px; border: 1p

Our ColdFusion application is based on a page with all the menu options that calls the selected pages within a frame.How can we display details of the page called in the browser tab : the standard <title> tag is not shown (as it is within a frame).Ideally display the title, but the URL or any other unique identifying value will do. Code extracts : In the Frame called “main” we initially show the welcome page, and when the relevant menu button is clicked, the Java script  function replaces the contents of the “main” frame with the new page. <FRAMESET …>                <FRAME SRC="../menuContents.cfm" NAME="Contents" … >                <FRAME SRC="../welcome.cfm" NAME="main" …></FRAMESET><noframes></noframes> <td><input name="image" type="image" onClick="power('xxx.