-
Close Search
From ColdFusion 11 onwards, you may use THIS.DATASOURCES in Application.cfc – or, equivalenty, the Datasources attribute in Application.cfm – to create a datasource. ( Application.cfc is the recommended file to use, so we shall not consider Application.cfm in what follows. )
THIS.DATASOURCES is a struct. So, how do know which keys it contains? The purpose of this blog post is to answer that question. .
Can anyone give a simple example of how to config a NoSQL database for mongodb.
Calling ProcessSAMLResponse() on SAML AuthN Response results in “Possible replay attack occurred as there is no login/logout information associated with this request” exception.
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 […]
