My first ForgeBox ColdBox module manages the Lucee server admin scheduled tasks through a responsive Bootstrap 4 front-end UI.

QB tries to automatically figure out what ColdFusion SQL type to use for updates and inserts based on the actual value that is passed in for each column. Although that works for most of the cases, I ran into an issue where my value type was being wrongly inferred so I needed to figure out how to override it.

Making use of the preQBExecute() and postQBExecute() QB interception points I can capture the actual SQL getting generated and running against my database.