bardware

<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

> 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

<!---
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

> 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

[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

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

bardware

https://www.mssqltips.com/sqlservertutorial/277/index-scans-and-table-scans/
https://www.mssqltips.com/sqlservertip/2602/collecting-and-storing-poor-performing-sql-server-queries-for-analysis/
https://www.mytecbits.com/microsoft/sql-server/what-are-extended-events
https://helpx.adobe.com/coldfusion/developing-applications/the-cfml-programming-language/extending-coldfusion-pages-with-cfml-scripting/using-closures.html#ClosureinColdFusion

bardware

<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"
)>

bardware

<!---
http://teratech.com/is-lucee-cfml-now-better-than-adobe-coldfusion/
--->
<cfscript>
  data={
    boolean:true,
    stringTrue:'true',
    stringYes:'yes',
    number:5,
    stringFive:'5'

bardware

<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 "~"