Problem I have some pretty basic Regex that scans the output of a HTML file (the whole document source) and […]
Tag: coldfusion
Generating JSON from a query
Problem I am trying to generate JSON from a query. All this seems to be too much grinding it out. […]
replaceWithCallback() UDF
Problem As explained in my blog article… I was looking up the docs for Javascript’s String replace() function the other […]
Running a master query and a query of queries
Problem The following is code I’m running to FIRST, SECOND, THIRD and so on until SEVENTH with a master query […]
Reading Excel (93-97) sheet with more than 65536 rows using cfspreadsheet
Problem I have a process that reads multiple sheets from an Excel file, then inserts the data into a database […]
Using Stored Procedures in ColdFusion / Lucee
Problem This is how I write all my database interactions now in Lucee: storedproc procedure=’OrderDetail.WhereOrderHeaderID’ { procparam value=session.Usr.UsrID; procparam value=url.OrderHeaderID; […]
Converting a list to an array when list has quotes and embedded comma
Problem This function converts a list to an array when list has quotes and embedded comma: array function convertRow(required string […]
Converting a list to an array when list has quotes and embedded comma
Problem This function converts a list to an array when list has quotes and embedded comma: array function convertRow(required string […]
A couple of basic string parsing functions
Problem I have an app that does a fair bit of text-parsing based on free-form user inputs. In this, I […]