SysBlog » Coldfusion

ColdFusion/MSSQL – new line and LIKE

SysBlog — Tue, 24 Mar 2026 11:52:41 +0000


SELECT id, ownership
					FROM tbl_test
					WHERE 

				lang = 
				and 

				(
					REPLACE(REPLACE(ownership, CHAR(13), ''), CHAR(10), '') like 
					OR
					REPLACE(REPLACE(ownership, CHAR(13), ''), CHAR(10), '') like 
					OR
					REPLACE(REPLACE(ownership, CHAR(13), ''), CHAR(10), '') like 
					OR
					REPLACE(REPLACE(ownership, CHAR(13), ''), CHAR(10), '') = 

					)

Coldfusion – remove duplicates from array using struct

SysBlog — Thu, 28 Nov 2024 10:18:50 +0000

Coldfusion – inline if else

SysBlog — Wed, 05 Jun 2024 12:22:05 +0000

ColdFusion – send email using cfscript

SysBlog — Sat, 01 Jun 2024 07:46:09 +0000


// Create an instance of the mail object
mail=new mail();

// Set it's properties
mail.setSubject( "Sample Email" );
mail.setTo( "to@example.com" );
mail.setFrom( "from@example.com" );
mail.setCC( "cc@example.com" );
mail.setBCC( "bcc@example.com" );

// Add an attachment
mail.addParam( file="C:\foo.txt" );

// Add email body content in text and HTML formats
mail.addPart( type="text", charset="utf-8", wraptext="72", body="This is a test message." );
mail.addPart( type="html", charset="utf-8", body="This is a test message." );

// Send the email
mail.send();

source: https://stackoverflow.com/questions/8423276/how-do-you-send-an-email-with-an-attachment-using-cfscript-in-cf9

ColdFusion – OutOfMemoryError – GC overhead limit exceeded

SysBlog — Sun, 28 Jan 2024 10:03:52 +0000

“This error essentially means that you need to add more memory, or reconfigure your garbage collection arguments. You can suppress this error by adding -XX:-UseGCOverheadLimit to your JVM startup arguments”

Note to self – don’t do it! It will block your entire windows virtual machine! Already seen and done!!!

source:

https://www.petefreitag.com/blog/outofmemoryerror-gc-overhead/

ColdFusion – csv file BOM Header problem CF2023

SysBlog — Thu, 04 Jan 2024 15:15:50 +0000

I’m running cf2023 on windows and I’m having a weird problem with basic functionality that was working normally on the cf2016 version I was using earlier.
Every attempt to generate a csv file in which the Croatian characters will be displayed correctly has so far been unsuccessful.

I tried changing the JVM arguments and adding -Dfile.encoding=UTF8 but it didn’t help.

BOM header problem – adding #CHR(65279)# to the beginning of the csv content helped.

source: https://community.adobe.com/t5/coldfusion-discussions/adding-utf-8-bom-byte-order-mark-to-file-output/m-p/11745053

Coldfusion – queryOfQueries union – not elegant but effective :)

SysBlog — Fri, 09 Apr 2021 10:52:39 +0000



 
 
 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 UNION

 

 SELECT * FROM currencyList.#key#.query

ColdFusion – queryOfqueries union – elegant

SysBlog — Fri, 09 Apr 2021 10:50:53 +0000

private any function combineQuery(qA, qB) {
 var qry1Result = arguments.qA;
 var qry2Result = arguments.qB;
 var qoqResult = '';

// create new query object
 var qoq = new Query();

// set attribute of new query object to be a query result with arbortrary name

qoq.setAttributes(QoQsrcTableA = qry1Result);
 qoq.setAttributes(QoQsrcTableB = qry2Result);

// use previously set attribute as table name for QoQ andset dbtype = query
 qoqResult = qoq.execute(sql="select * from QoQsrcTableA union select * from QoQsrcTableB", dbtype="query");

// return result
 return qoqResult.getResult();

}

source: https://coldfusion.adobe.com/2017/10/unioning-queries-using-query-of-query/

ColdFusion – get file name before cffile upload

SysBlog — Wed, 17 Feb 2021 17:22:52 +0000

source: http://www.stillnetstudios.com/get-filename-before-calling-cffile/

Coldfusion – get PDF page count

SysBlog — Tue, 19 May 2020 09:23:04 +0000