

I found some very strange behaviour of ColdFusion’s query component. When you use this component to build a query of query (QoQ) of another ColdFusion Query and use order by on several colums, the last column in the order by list is added to the selected output. This appears to happen in CF9, 10, 11 and 2016, but not in Lucee. /* Create an unsorted CF-query */ unsorted = QueryNew(“col1,col2,col3,col4″,”VarChar,VarChar,Integer,VarChar”); for (a=10;a gte 1;a–){ QueryAddRow(unsorted); QuerySetCell(unsorted,”col1″,”col1 #a#”); QuerySetCell(unsorted,”col2″,”col2 #a#”); QuerySetCell(unsorted,”col3″,”#a#”); […]
Prosis is a top notch enterprise resource planning (ERP) system fully built in ColdFusion. It is designed from the ground up to serve small, medium or large organizations, Prosis helps you to take charge of your information problem and automate your operations across budget, program and project planning, human resources, supply chain, stock control, asset control, sales, work-order services and financials. Equipped with a powerful workflow definition framework, Prosis is capable of modelling business processes through a collection of structured steps, […]
Communication between applications or services have become more common in today’s applications, and one very popular open-standard file format is JSON (Java Script Object Notation). This is a human-readable data interchange text that represents complex data or objects formed by attribute-value pairs. Sometimes you will need to create or edit a .json file in your IDE and the more complex the object, the more difficult is to read it if it is not properly formatted, to assist you in this […]
Just got notification of a new Coldfusion Meetup meeting coming up December 14th at noon eastern. The topic is “Protect your CFML Apps with FuseGuard 3” and given by Pete Freitag. More details can be found here: https://www.meetup.com/coldfusionmeetup/events/245685781/. The Meetup is managed by Charlie Arehart and I’d recommend joining up if you’re not currently a member. He always finds good topics and presenters. More information on it can be found here: https://www.meetup.com/coldfusionmeetup.
Since ColdFusion 10, the CF Administrator has a feature for applying updates to their installed ColdFusion version. This process is generally very easy, but sometimes people face challenges, and there are several resources that can help you find the updates as well as better understand the update process and resolve problems with it, as I discuss here.
Have you needed to convert a CFFUNCTION to a script equivalent function or CFC method, and wondered how you would specify the things which had been attributes to the tag, such as OUTPUT, ROLES, RETURNFORMAT (added in CF8), or RESTPATH (added in CF10), to name just a few? It’s just not obvious. The quick answer is that you specify them AFTER the closing parenthesis which surrounds any arguments to the function. So, for example: public numeric testMethod (numeric arg1) returnFormat=”json” […]
Hi All, I was just wondering who else out there has experience with sonarqube / cflint or other automated code quality checking tools ? Cheers Gareth.
Originally posted at https://www.coldfusionmuse.com/index.cfm/2017/11/27/ColdFusion-MailSpoolService-Performance In my last article about the Adobe ColdFusion MailSpoolService I mentioned that I was going to try to get specifics on expected performance in the Standard Edition vs Enterprise edition of the MailSpoolService. Adobe has not respond to my requests with actual data. While attending the ColdFusion Summit 2017 I tried to get a clear answer from any of the Adobe ColdFusion engineering team members that were at the conference. They didn’t know the answer. Because I […]
I installed ColdBox with CommandBox, but when I try to run it on my localhost ColdFusion server (not in CommandBox), I get various mapping errors. Are there some standard tweaks I can make to get this to work? I will provide more specific errors if you want, but I figure since I’m not doing anything custom yet and just using one of the out-of-the-box templates, I thought I should get some more general advice first. This is a Microsoft Windows […]
Think you have a good handle on the many things that were new in ColdFusion 2016, or do you think there were only a couple of new features? In this post, I point you to a couple dozen resources which highlight both its major and minor features, as well as its updates since the initial release, and still more resources on the new release. Though CF2016 has been out since Feb 2016, there are many folks who may have only […]
number2TextConverter.cfc This is a component that takes a number as an argument and returns a string representation of that number. It can convert numbers in the range from 1 to 999999999. Clone or download from GitHub // Create an object c = new number2TextConverter(); // Change language c.setLanguage(‘spanish’); // Change the currency c.setCurrency( ‘MX’ ); // Converting just the number result = c.convert( 1999 ); // mil novecientos noventa y nueve // Converting the number and adding the currency at […]
CF Summit 2017 was a lot of fun, lots of new faces, and good to meet friends, old and new alike. I really enjoyed the ColdBox 2 day training, RESTFul Training Bootcamp. I also enjoyed, Pete Freitag’s Hands On CFML Security Workshop. It was fun, and terrifying at the same time. My session on 3 ways to test your ColdFusion API went well, lots of interest, and lots of discussion after the class. I am sharing my slides in this post, […]