ColdFusion

Hi there,When creating a line chart of type JPG or PNG, incorrect $ITEMLABEL$ are passed to the javascript code specified in the url attribute if there are more than 10 data points in the x axis. Just submited a bug report along with sample code to reproduce the problem. https://tracker.adobe.com/#/view/CF-4209142 Thought I may post here to in case someone has a better work around.  Cheers

Salivations!I'm working with a service provider that stores .wav audio files that my application needs to retrieve. I make a service call which returns a URL to the audio file I need. I then attempt to use cfhttp to retrieve the file, and run into problems. The URL looks something like:https://site.com/retriever/replay?audio:format=portable&encryption=None&primaryinum=xxx&transactionid=xxx&token=xxxxx  <cfhttp url="#thisFileUrl#" getAsBinary = "no" method="GET" throwOnError="no" useragent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36 Edg/90.0.818.62" timeout="15" file="myFile.wav" path="C:\inetpub\wwwroot\ccAudio4_client\" > <cfhttpparam type="header" name="Connection" value="keep-alive" /> <!---<cfhttpparam type="Header" name="Accept" value="audio/wav;audio/x-wav;image/svg+xml">---> </cfhttp> When I do not include the

Hello we use Coldfusion 10 and I'm having issues with a form and having it be grayed out until a check box is selected. Here's a small part of the field I'm trying to do. What an I missing? <form action="TransactD.cfm" Target="body" method="post"><input type="hidden" name="Receiveall" value="1"><input type="submit" value="Receive all" disabled class="rabutton" onClick="this.form.submit();"> <input type="checkbox" name="checkbox-0" class="rabutton"></form><script id="jsbin-javascript">$(".rabutton").on("change", function(e){if($(".rabutton").attr("checked")){$(".submit").button("enable");} else {$(".submit").button("disable");}});</script> Any help would be great thanks.

Language learning web site needs some repairs and changes. Cold Fusion and PHP. I need a long time worker and quotes for work done. Thanks Brian

Hello,We are working with an application in which CF REST services are being developed, however, we have noticed that ColdFusion 2018 Enterprise is generating documentation using the Swagger Specification version 1.2. Is there a ColdFusion Server update that allows the swagger documentation to be generated according to the Swagger Specification version 2.0 or 3.0? Or some other solution to solve the situation.

I've been trying to access a list in SharePoint Online using the few examples of sample code found in this forum and elsewhere online.  I'm attempting to use Basic authentication with an account I created in our O365 tenant that does not require MFA or other device trust requirements.  I've changed the password after first logon and have successfully opened and viewed the list in a browser on my computer.When I try to connect using CFSharepoint from the ColdFusion Server, I always get a 403 Forbidden error.  I don't see any failed logon attempts in the Azure Active Directory logs.Cannot perform web service invocation getlistitems. The fault returned when invoking the web service operation is: AxisFault faultCode: {http://xml.apache.org/axis/}HTTP faultSubcode: faultString: (403)Forbidden faultActor: faultNode: faultDetail: {}:return code: 403 403 FORBIDDEN {http://xml.apache.org/axis/}HttpErrorCode:403 the code I'm trying is as follows:<cfset SPUsern

Hi, The iif() is returning boolean when json serialized it's returning string instead of boolean. Thanks. Tested on Adobe Coldfusion 2021. Here is the code:<cfscript>local.test = true;local.return = {"hasFeed" = iif(local.test,true,false)};writeoutput(serializejson(local.return));</cfscript> 

Where can I find Coldfusion2021 linux systemd system file or do we have to write at our end?

Suddenly getting java.lang.NullPointerException coldfusion.CfmServlet.init(http://CfmServlet.java:99) errors for ColdFusion 2021 server instances that are started using a Windows Service config using an Active Directory account rather than the Local System account.I have the sames setup on both CF2018 and 2021 servers and haven't seen this issue before. Seems to have started happening after a Windows Update and subsequent reboot. KB5001347. I did uninstall it, but that' didnt' resolve the issue. If I change the Windows Service login back to Local System, site performs as expected.Here's what is being returned by the server.HTTP Status 500 – Internal Server ErrorType Exception ReportMessage java.lang.NullPointerExceptionDescription The server encountered an unexpected condition that prevented it from fulfilling the request.Exceptionjavax.servlet.ServletException: java.lang.NullPointerException coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java

I have an ID (primary key) set as a BIGINT in SQL SERVER. I have a query with the following: WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_integer" value="#URL.id#"> I then got an invalid data type for it. I then tried: WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#URL.id#"> I still got an invalid data type for it. i then tried: WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_int" value="#URL.id#"> and it worked. The weird thing is cf_sql_int is not even listed as being accepted: http://www.adobe.com/livedocs/coldfusion/5.0/CFML_Reference/Tags79.htm Can some explain this to me.

I'm getting the following error trying to install CF 2021 on virtual Windows 10 (VirtualBox)."Invalid directory path for Coldfusion Home." The error happened when I clicked "Next" on the "ColdFusion Installation Directory". The directory I entered was "C:\ColdFusion2021". The directory definitely exists.

Have sourcetree open and functioning. Open CF Admin to download and install Server Update 1. As soon as I begin the update process, I noticed my sourcetree is now reporting an issue. Everything is still there. The folder, files, and .git file. I tried restarting both Sourcetree and my system.Any input would be greatly appreciated...

We're banging our heads on an issue - starting PDFg to use cfhtmltopdf - and I thought i'd post it here to see if anyone has had anything similar happen.  We're on CF2016 Standard (upgraded from CF11) on Windows 2012.  When the upgrade was done, about a year ago, we can see in the logs that the PDFg service was initially registered and working.  But, soon after, we started seeing this error message in the logs - "Error in setting up authentication for PDFg services".  We have done a lot of experimentation including observing the port activity in the background, and it just seems like CF is not really trying to enable and/or verify this service (perhaps because of an authentication issue).Anyone have any similar problems?  Any ideas what it might be?Nick

This is my test to create a pdf out of html:<cfhtmltopdf>this is a test <cfoutput>#now()#</cfoutput></cfhtmltopdf>and this is the error I get: Error occurred while generating PDF. Reason: Error occurred while handling request. and the stack trace:coldfusion.document.webkit.PDFgErrorHandler$ServiceManagerConversionException: Error occurred while generating PDF. at coldfusion.tagext.lang.HtmlToPdfTag.handleRetryError(HtmlToPdfTag.java:1509) at coldfusion.tagext.lang.HtmlToPdfTag.handlePDFgConversionRequest(HtmlToPdfTag.java:1471) at coldfusion.tagext.lang.HtmlToPdfTag.convertToPDF(HtmlToPdfTag.java:1413) at coldfusion.tagext.lang.HtmlToPdfTag.doEndTag(HtmlToPdfTag.java:1551) at cfmis_print_pdf2ecfm1817928483.runPage(C:\Users\daniel.mejia\Development\apps\local-intra.\backlog\mis_print_pdf.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag

I want to query for a condition that is case specific. WHEREANTGN_CD_SHT_DESC = 'C Antigen' Is not the same as WHEREANTGN_CD_SHT_DESC = 'c Antigen' These are red blood cell antigens.  The two listed above are often referred to as big C or little c. Can case be built into a query?  The field will always have the word Antigen at the end, and the first part if not always just one letter, for instance, it might be 'Fya Antigen'.  I am accessing our lab system and have no control over that table. Thank you

I was using the event handler onRESTRequest to log any REST request in my ColdFusion 2018 application. When I decided to upgrade it to ColdFusion 2021, I've got a surprise to receive an error informing that the event handler does not exist anymore!Could someone explain me the reason that made ColdFusion creators deciding to remove that TOO IMPORTANT function for us, CFers? Are they trying to push the new ColdFusion REST Manager resource at our throat? Could they respect website manages that host their application at a shared hosting service? What are they thinking about?

Did you know that, if you create a REST Function in your CFC File that returns a variables scope (no, you are not reading stuffs; it's really that way), then you call that function using CFHTTP, you should receive a RESTful diagnosis containing all its function and parameter features? No???? So, try it!By the way, trying to do it regularly (until upgrading my website to ColdFusion 2021), I've found a tiny issue. This issue is the 'displayName' key inside the 'Metadata' key that should be corrected. At this moment, the key has been naming to 'diAplayName' instead of  'diSplayName'. Could someone correct it, please?

Hello all - We have recently moved our dev team from our olf CF10 on RHEL6 to CF2021 on RHEL8.  One bit of code we cannot seem to get to function properly is a simple barcode PDF generation.  We have stripped down a test case as barebones as possible and cannot get it to work.   We have the ttf fonts registered in CF administrator (Free 3 of 9 Extended)We created a very simple CFR file in CF Report Builder, and ticked the box to embed the fontWe call the CFR file with <cfreport template="myreport.cfr" format="pdf">The PDF is generated, however it uses a default font instead of the barcode. If we use the deprecated cfdocument or cfimage tags, the font is happily embedded or renderd, so the font appears to be registered correctly in CF admin.  Also, our cfreport code works fine in CF10. While this simple test would be quite easy to reproduce with an external linunx based PDF generation program, our actual reports are quite complex a

Hello Team, Looking for some recommendations for best path to successfully move to CF 2021 on a new Windows 2019 Server. My  new Dev/UAT and Prod CF 2021  will be up and running in parallel to our current systems until cut over due to new MYSQL and Oracle server upgrades happening as well. After a fresh install of CF 2021 Ent, is there best way to copy/export configuration settings?  From a CF tasks, I know i can copy NEO*.xml files etc. I do have detail steps from V11 perspective which I am sure still apply from IIS work/copying code base/Certificate work/CF Admin work etc. Just wondering if anyone run into any gotchas during CF2021 install/known issues?  Many thanks Jose Duenas

Recently one of my CFHTTP calls stopped working, the authentication that was working on the calling page is no longer working. I verified with the owners of the page i'm calling that nothing has changed on their end.  I did some googling and found Charlie Arehart's post about CFHTTP issue might have to do with JVM and that JVM should be updated. My ColdFusion 2016 server is on Java version 1.8.0_112 and CF Update 5.  I know both the Java and CF need to be updated, long story short, we lost our server guy and we have no one to keep on top of updates.   Based off the article, I updated the server to Java 1.8.0_281. My CFHTTP issue still hasn't resolved but now I am receiving the following error from another CFHTTP call.  I tried a lower version of Java 1.8.0_271 and Java 1.8.0_121 but still seeing the same error. structCharset[empty string]ErrorDetailI/O Exception: sun.security.validator.ValidatorException: PKIX path building failed:

I am creating a simple spreadsheet from a query using CF Spreadsheet functions.  Code is below.  I know we're on an ancient version.  This is not my call.  Thankfully we will finally be upgrading in a couple of months. In the field OMS Num, we have an alphanumeric value which is always 4 characters.  Some of these are dropping the last character when adding to the row.  The value itself is complete all the way up to the point of spreadsheetaddrows.  If I put anything before or after it, it works fine.  I've tried SpreadsheetFormatColumn as well to no avail. I've experimenting putting other values before the last letter and the same thing happens.  So "12345D" becomes "13245"  "863D" becomes "863".  Any clues what's happening here and how to remedy it? Data:  "OMS" field365AUA66UA74705D - Converts to 705592AUK71985A216F - Converts to 216940C335F - Converts to 335337F - Converts to 337 Code snippet<Cfset q

Hello, in the Coldfusion user documentation under enhancements for cfpdf, there is this comment:  A sample xfdf file (cf_comment3_exported.xfdf) is attached to this pdf for your reference. You can click the attachment icon on the left pane in pdf and save the file. Is there any chance of getting the cf_comment3_exported.xfdf example file?  I've been trying to work with importing comments into a pdf, but so far with no luck.

Udpate 16 was working fine, after applying Update 17, ColdFusion Application Service no longer starts properly.  Browsers get 500 Internal Server Errorcoldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime service is not available. From the logs and cfstart console output:Mar 28, 2021 22:26:19 PM Error [localhost-startStop-1] - Unable to initialise Security service: java.lang.NoSuchFieldError: TRACE java.util.MissingResourceException: Can't find resource key "CFStartUpServlet.notInitialised" in base name coldfusion/server/j2ee/resource.properties Mar 28, 2021 10:26:19 PM org.apache.catalina.core.StandardContext loadOnStartup SEVERE: Servlet [ColdFusionStartUpServlet] in web application [] threw load() exception java.util.MissingResourceException: Can't find resource key "CFStartUpServlet.notInitialised" in base name coldfusion/server/j2ee/resource.propertiesAny ideas from this forum? 

Hi there,I am new to cfftp secure="yes" and  I keep getting invalid privatekey error and couldn't find anything when I google it.  I know the key is working as I can connect using filezilla.  So I had a look at the stack trace and google Jsch invalid privatekey and bam, found out I need to convert the key to "classic" OpenSSH format as per: https://stackoverflow.com/questions/53134212/invalid-privatekey-when-using-jsch Just putting this out there in case a newbie come across the same problem.

Q - My organization uses CF ORM and we are currently evaluating CF2021, contemplating an UG from CF2016, (which I understand includes an UG of Hibernate 4.2 to 5.2 in the process).While I've worked with CF for quite some time, I have not had much history with CF ORM over the years. We happen to have a legacy table named with a keyword in MS SQL Server and it apparently needs to be wrapped when CF2021 ORM performs TSQL operations. Understandable and confirmed and apparently Hibernate by default does not do so.Changing the name of the table is not a viable option at this time. How do we force Hibernate to wrap a keyword eg: [Case] ? I imagine we need eitherhibernate.globally_quoted_identifiers=true (where false is the default)and/orhibernate.auto_quote_keyword=true (where false is the default). From what I have researched, I have not been able to clarify if we need to create a .hbmxml file whereas these settings are apparently not available within ormsettings...and/or