-
Close Search
I had a customer reach out to me last week about moving their session storage to Redis, so I decided to play around a bit with it. I’d never really had the need to utilize Redis or any of the other caches, as the companies I’d worked with used the local CF cache or other solutions. So I saw this as an opportunity to play and learn. To start, it is dead simple to get yourself a Redis instance going. […]
On March 24th, 2022 the Hawaii ColdFusion User Group will be having a meeting with Mark Takata on Moving your Legacy ColdFusion application to Modern CFML. The meeting will be online at – https://hawaiicoldfusionusergroup.adobeconnect.com/legacy/ We’ve all seen old legacy code in our ColdFusion applications. How do you move that legacy code to modern CFML with easier maintenance and deployment, fewer bugs, and streamlined code? Why Move to Modern CFML Most of us understand that moving our legacy applications to modern CFML […]
If you remember, in the last part of this blog series we tackled writing to a DynamoDB. This week, we’re tackling the editable table structures that will let us do a little ETL and massaging to our data before we push it to the dynamoDB. To make this work, we’ll be using the HTMX JS library, a lightweight, easy to use JavaScript toolset. You can find it here: https://htmx.org/ So what does this library do? In short, it allows you […]
I just wanted to share something rather minor that I observed: the CF “downloads” page–which offers downloads for things RELATED to CF but not CF itself–has been moved to “within” the CF docs. It used to be offered at https://www.adobe.com/support/coldfusion/downloads.html, but that now redirects to https://helpx.adobe.com/coldfusion/kb/coldfusion-downloads.html. There’s no change to the content of the page, though you’ll notice now that there’s a left nav bar with all the other pages of the CF docs. See the screenshot below. That may […]
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 […]
