Skip to content

Instantly share code, notes, and snippets.

Avatar

Bernhard Döbler bardware

View GitHub Profile
@bardware
bardware / qOq_JOIN.cfm
Created Nov 5, 2019
JOIN inColdFusion QoQ
View qOq_JOIN.cfm
<cfset q1=QueryNew(
"Date,User,Col1,Col2,Col3",
"varchar,varchar,integer,integer,integer",
[
{
Date = "08/2019",
User = "Sam",
Col1 = 1,
Col2 = 2,
Col3 = 3
@bardware
bardware / error.log
Created Jul 30, 2019
Trying to start CF 9 with jre1.8.0_172
View error.log
> start server-cf9.json --trace --console
✓ | Starting Server
|------------------------------
| Looking for server JSON file by convention: D:\Webs\CF9.001\server-cf9.json
| webroot defaulted to location of server's JSON file: D:\Webs\CF9.001\
| start server in - D:\Webs\CF9.001\
| server name - cf9001
| server config file - D:\Webs\CF9.001\server-cf9.json
| WAR/zip archive already installed.
| ******************************************
@bardware
bardware / index.cfm
Created Mar 14, 2019
Invalid CFML construct found on line 23 at column 36. ColdFusion was looking at the following text: Function
View index.cfm
<!---
Invalid CFML construct found on line 23 at column 36.
ColdFusion was looking at the following text:
Function
The CFML compiler was processing:
An expression beginning with callStack, on line 23, column 23.This message is usually caused by a problem in the expressions structure.
A cfset tag beginning on line 23, column 6.
@bardware
bardware / 20180312_box_error.txt
Created Mar 12, 2019
Error trying to set a mailserver
View 20180312_box_error.txt
> cfconfig set mailServers=127.0.0.1 to=myserver
ERROR (4.6.0+00003)
invalid call of the function setMailServers, first Argument (mailServers) is of invalid type, can't cast String [127.0.0.1] to a value of type [array]
the function is located at [C:\Users\xxx\.CommandBox\cfml\modules\commandbox-cfconfig\modules\cfconfig-services\models\providers\Adobe9.cfc]
\modules\commandbox-cfconfig\commands\cfconfig\set.cfc: line 59
57: error( "[#property#] is not a valid property" );
58: }
59: oConfig[ 'set#property#' ]( arguments[ property ] )
60: .write( toDetails.path );
@bardware
bardware / server.out.txt
Created Mar 1, 2019
Errors when trying to use CF 9 under Commandbox 4.5
View server.out.txt
[INFO ] runwar.server: Starting RunWAR 3.8.1-SNAPSHOT
[INFO ] runwar.server: Starting background cf9001 [adobe 9.0.2+282541] from: /C:/Users/bd/.CommandBox/lib/runwar-3.8.1-SNAPSHOT.jar
[INFO ] runwar.context: Starting in background -
[INFO ] runwar.server: Starting RunWAR 3.8.1-SNAPSHOT
[INFO ] runwar.server: Adding additional lib dir of: C:\Users\bd\.CommandBox\server\FA53F12C9565C5F09E80F00AED307624-cf9001\adobe-9.0.2.282541\WEB-INF/lib
[INFO ] runwar.server: ******************************************************************************
[INFO ] runwar.server: Starting - port:53699 stop-port:53700 warpath:file:/D:/Webs/CF9.001/
[INFO ] runwar.server: context: / - version: 3.8.1-SNAPSHOT
[INFO ] runwar.server: web-dirs: D:\Webs\CF9.001
[INFO ] runwar.server: Log Directory: C:\Users\bd\.CommandBox\server\FA53F12C9565C5F09E80F00AED307624-cf9001\adobe-9.0.2.282541\logs
@bardware
bardware / clear_pac.sh
Created Mar 1, 2019
Clear pacman cache
View clear_pac.sh
You can also define how many recent versions you want to keep. To retain only one past version use:
# paccache -rk1
Add the u switch to limit the action of paccache to uninstalled packages. For example to remove all cached versions of uninstalled packages, use the following:
# paccache -ruk0
View tz.001.cfm
<cfset oZoneId = createObject( "java", "java.time.ZoneId")>
<cfset oInstant = createObject( "java", "java.time.Instant")>
<cfset oTextStyle = createObject( "java", "java.time.format.TextStyle")>
<cfset oLocale = createObject( "java", "java.util.Locale").init( getLocale() )>
<cfset qryTZ = queryNew(
"offset,zone,region,displayfull,displayfullstdo,displaynarrow,displaynarrowstdo,displayshort,displayshortstdo,displayfulloffset,displayshortoffset",
"Integer,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar,VarChar"
)>
View datatypes_lucee_acf.cfm
<!---
http://teratech.com/is-lucee-cfml-now-better-than-adobe-coldfusion/
--->
<cfscript>
data={
boolean:true,
stringTrue:'true',
stringYes:'yes',
number:5,
stringFive:'5'
@bardware
bardware / EncodeRFC3986.cfm
Last active Jul 20, 2018 — forked from Leigh-/EncodeRFC3986.cfm
Comparison of EncodeForURL, URLEncodedFormat and EncodeRFC3986 (UDF)
View EncodeRFC3986.cfm
<cfscript>
/**
* URI encoding per RFC 3986, which has treats the following as unreserved: ALPHA / DIGIT / "-" / "." / "_" / "~"
* @text Text to encode
* @returns URI encoded text
*/
public function encodeRFC3986(required string text) {
// Requires CF10+
Local.encoded = encodeForURL(arguments.text);
// Reverse encoding of tilde "~"