Bulk Inserting Data

One of the operations that we do often is insert multiple rows into a database.  Your inclination is probably to just loop over a cfquery and do the inserts.  While this will work it creates some excess overhead.   Your code may look something like this: <cfloop array=”#users#” index=”u”> <cfquery name=”insertData”> insert into mytable (firstname, lastname, email) values ( <cfqueryparam cfsqltype=”cf_sql_varchar” value=”#u.firstname#”>, <cfqueryparam cfsqltype=”cf_sql_varchar” value=”#u.lastname#”>, <cfqueryparam cfsqltype=”cf_sql_varchar” value=”#u.email#”> ) </cfquery></cfloop> While this fundamentally works it can cause performance issues.  Depending on configuration, […]

API Manager Demonstrations and Key Elements

Check out my presentation from Summit 2017 API-Manager-Presentation-Summit-2017

Introducing CFConfig : A new way to manage your CF server’s configuration from the command line

We’re very excited to unveil a brand new project we’ve been working on called CFConfig.  It’s a command line tool that can help you manage the configuration for any CF server in a simple, portable, and automated fashion.  CFConfig is a CommandBox module that can be used to set, show, import, export, and diff configuration on Adobe CF and Lucee servers.  This project is still in an alpha state, but it ready for people to start kicking the tires and providing feedback. What it manages […]

More Modern CFML features

More Modern features in ColdFuison, what are these features? Here are some and examples for each: CFScript QueryExecute Member Functions Elvis Operator Colusures Map Reduce Filter Each First Class Functions Safe Navigator CFScript: Seems like first CFScript was implemented in CF 4.0 Tags seemed ok back then because pre CFC’s (CF Components) Used UDF’s and Custom Tags to reuse and separate code CF MX (6.0) brought about CFC’s so separation of code CFCs – you create methods, which are ColdFusion […]

How ColdFusion Enhances Web GIS Applications for Central San

Central San is a water resources agency that serves nearly 450,000 customers in our 145-square-mile service area. Founded in 1946, Central San collects and treats 30-50 million gallons of wastewater every day, and produces about 600 million gallons of recycled water for industrial uses and irrigation. We operate and maintain a large wastewater treatment plant, 19 pumping stations, and 1,500 miles of sewer collection pipelines. Central San began using Geographic Information System (GIS) technology in the mid-1990’s to replace the […]

Did you know that ColdFusion Builder 2016 is included with your purchase CF 2016?

I see people asking this occasionally, so it bears pointing out here in the portal: ColdFusion Builder 2016 is included with your purchase CF 2016. Let me quote one of the questions and answers from Adobe’s Frequently Asked Questions (FAQ) for ColdFusion Builder 2016: Is ColdFusion Builder 2016 included with Adobe ColdFusion 2016? Yes. ColdFusion Builder 2016 is included with both Adobe ColdFusion 2016 Enterprise Edition and Standard Edition. You get three licenses of ColdFusion Builder 2016 with Adobe ColdFusion […]

MyAcrobat.com is here

I’m excited to announce my beta release of myacrobat.com powered by ColdFusion 2016. If you need to add a signature field, stamp, redact, barcode, and properties without using Adobe Acrobat DC (PRO), then you need to check out myacrobat.com. MyAcrobat.com is free open source, please feel free to help us improve and add more features. https://myacrobat.com/

Tomcat Load Balancing Sample Worker.Properties File using Status Worker

{6/22/2021 Update – This example will no longer work as you now need 2 secrets for each worker, one for the connector and one for monitoring if using PMT – look for an updated example soon] If you want to load balance between 2 ore more servers in ColdFusion here is an example worker.properties file that will set it up.  You would edit for your local or remote servers.  This feature is part of Tomcat and can be used for […]

CF – Best for Healthcare Development

I’ve been using CF since 1997 and developing custom application for healthcare and all done with CF.    We use CF for its security, ease of use and CF quick support has been a part of our decision to continue to use CF.   Thanks CF Team and keep up the good work!

Sassy Sprites – Making sprites easy with SCSS/Sass

I hate sprites When talking about sprites, I often hear from people that they hate them. Unfortunately their biggest reason tends to be one which could be easily solved, the grueling task of setting the background position pixels for each icon. Before I go further, I do want to address that glyph based fonts are a great alternate to sprites, so use them when you can. For those times where fonts are not an option, I hope the information in […]

Handling Tomcat relative URLs and mixed case.

Recently I had an issue with the ColdFusion internal Tomcat server that bears repeating.  If you are using mixed case directory names and relative URLs to load your JS And CSS.  It is important to note that Tomcat will report the links as 404 unless you are using  Firefox.  Since I develop with Firefox, I didnt see this until we got to testing.  The exhibited behavior is a fully loaded ColdFusion page with all JS and CSS links reported as […]

Using Snippets in CF Builder

As a coder you will find yourself writing the same code over and over, or maybe copying an pasting blocks of code that is required in several files of your application; so you open the file that contains the code you want to replicate, then select and copy the text to finally open the destination document and paste the code. What if I could save that block somewhere in my favorite editor (CF Builder) and then invoke it whenever I […]