-
Close Search
Part 1: Building a data import workflow using Cloud datasources and CFML Connecting & interacting with DynamoDB on AWS We’re going to kind of go backwards here with this web series, but I wanted to make sure we build out our scaffolding before we get into the meat of the actual code. As a reminder, we’ll be building a system which pulls data from a Google Sheet using BaseQL to generate a GraphQL endpoint (read-only) which will feed a page […]
How do you round down a large number so that you can display it easier. How I got stuck on a what turned out to be a simple solution.
I/O Exception: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targe
Alrighty! So this is going to be the first post introducing a little project I’m going to be building up and sharing the code to on Github for folks to use if they would like. I’ve actually had this workflow requirement come up several times in my development career, so I’m going to assume it is something the community might find useful. The App Essentially, the app will take a non-db datasource (in our case, Google Sheets), import that sheet […]
Start with New Excel file Rename sheet1 to “interview” Save as “xlsx” named “testMaster” Save as “xls” name “oldExcel” Run CF below, then open each. “xls” will autocalc cells properly. “xlxs” WILL NOT- Cells display as “0” although formula is correctly embedded and does calc with keystroke “cntrl-alt-f9” <cfset DummyID = randrange(12345,99999)> <cfset excelFileToUse = “dldExcel.xls”> <cfset excelFileToUse = “d:testMaster.xlsx”> <cfset fileExt = listLast(excelFileToUse,”.”)> <cfset CompanyLink = “HYPERLINK(“”http://localhost/customers/customer.cfm?customerID=156″”,””My Company””)”> <cfset contactLink = “HYPERLINK(“”http://localhost//customers/customer.cfm?customerID=156″”,””Johnny Walker””)”> <cfset quoteLink = “HYPERLINK(“”http://localhost/quotes/oldquote.cfm?quoteID=15263″”,””15626″”)”> <!— Read […]
I’ve been a CFML developer for a long time, as have a lot of you. But everyone can always learn something new. There’s also a new generation of devs hungry for resources to learn about CMFL, figure out how to move over their existing knowledge, or just get certified as they search for their first ColdFusion position. I get a lot of questions about where to go for CFML knowledge, so I thought I might compile a few things here, […]
Last time I posted, I added a write functionality to my already existing talks on reading from Airtable APIs using GraphQL by integrating with the BaseQL plugin. There’s been some cool updates there and I wanted to share them, as they potentially open up an amazing and exciting new arena for using ColdFusion to write sites that leverage low-code/no-code sources for data. One big piece of news coming from BaseQL is that you no longer need to have a pro […]
HELP!!!! Upgraded CF to 2021 from 10.0. Up to date on CF patches (#3). The following was working for YEARS until we updated CF. NO CODE WAS CHANGED FOR UPGRADE, WE ASSUMED CODE SHOULD REMAIN SAME. IN CF, open spreadsheet USE “SpreadsheetSetCellFormula” to set formula in given cell Write spreadsheet Open sheet in Excel. NO CF calculations are auto-calculated (Again, this was working perfectly for years). In Excel, we see the CF formula properly. ONLY solution is for user to […]
During the last CFSummit (2021) I did a talk on leveraging Airtable’s API using the BaseQL plugin to perform CRUD operations using GraphQL. You can find the talk here: All Videos – ColdFusion (adobe.com) Except, as a couple folks pointed out, I actually just showed how to do R operations, no C U or D, as my time was a bit short. I’d figured extrapolating from my talk would be fairly trivial. As it turns out… not so much, there’s […]
As you all know, the Log4J exploit situation has continued to evolve, and our security team has just released the latest recommendations for dealing with the latest know issues. Read the tech note here: https://helpx.adobe.com/coldfusion/kb/log4j-2-17-0-vulnerability-coldfusion.html Folks who have already updated their Log4J versions to 2.17.1 are at the recommended level. However, please note that even though Log4J 2.17.0 was found to have a potential attack vector, our security team did not find any exploitable attack vector or mechanism with Adobe […]
The big news a few weeks back was the announcement by Microsoft that they now had a fully featured VS Code IDE that runs completely in the browser. This was exciting news for folks who liked the idea of being able to code anywhere, whether on a Chromebook or an iPad or their Tesla display (maybe, honestly haven’t tried that one). In any case, the excitement and hype quickly gave way to the dreaded “but” as limitations on what this […]
