This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<cfscript> | |
qryPers = QueryNew( | |
'pn_id,vor name,nach name', | |
'integer,varchar,varchar', | |
[ | |
{ pn_id = 2, 'vor name' = 'L', "nach name" = "y" }, | |
{ pn_id = 1, 'vor name' = 'A', "nach name" = "b" } | |
] | |
); | |
qryPersSort = QueryExecute( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE `tweets` ( | |
`tweet_id` bigint(11) NOT NULL, | |
`in_reply_to_status_id` bigint(11) NOT NULL, | |
`in_reply_to_user_id` bigint(11) NOT NULL, | |
`timestamp` varchar(100) COLLATE utf8mb4_german2_ci NOT NULL, | |
`source` varchar(4000) COLLATE utf8mb4_german2_ci NOT NULL, | |
`text` varchar(4000) COLLATE utf8mb4_german2_ci DEFAULT NULL, | |
`retweeted_status_id` bigint(11) DEFAULT NULL, | |
`retweeted_status_user_id` bigint(11) DEFAULT NULL, | |
`retweeted_status_timestamp` bigint(11) DEFAULT NULL, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Show hidden characters
{ | |
"parser" : "espree", | |
"env" : { | |
"browser" : true, | |
"jquery" : true | |
}, | |
"rules" : { | |
"no-alert" : "off", | |
"no-array-constructor" : "warn", | |
"no-bitwise" : "off", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
gem update --system | |
gem update | |
# gem sources --clear-all | |
# gem sources --update | |
# gem install sass --version 3.4.25 | |
# gem uninstall |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!--- https://medium.com/@gokulraj/esapis-encodeforhtml-vs-encodeforhtmlattribute-79958c07ba0d ---> | |
<cfset str = "HFW int. 18/2015"> | |
<cfset stru = { | |
strHTMLEditFormat = HTMLEditFormat(str), | |
strEncodeForHTML = EncodeForHTML(str), | |
strEncodeForHTMLAttribute = EncodeForHTMLAttribute(str), | |
strEncodeForJavaScript = EncodeForJavaScript(str), | |
str = str | |
}> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<cffunction name="fktA" returntype="string"> | |
<cfargument name="struExcludeCols" type="struct"> | |
<cfset local.strLst = "Listel1,Listel2,Listel3"> | |
<cfscript> | |
local.columnNames = ListFilter( | |
strLst, | |
function( strCol ) { | |
return not StructKeyExists( Arguments.struExcludeCols, strCol ); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!--- https://commons.apache.org/proper/commons-csv/apidocs/org/apache/commons/csv/package-summary.html ---> | |
<cfset oCSV = createobject( "java", "org.apache.commons.csv.CSVFormat" )> | |
<cfset oParserObj = createobject( "java", "org.apache.commons.csv.CSVParser" )> | |
<cfdump var="#oParserObj#" expand="false"> | |
<cfset oIOFile = createobject( "java", "java.io.File" ).init( expandpath( "./CLIENTIMPORT.csv" ) )> | |
<cfset oCharset = createobject( "java", "java.nio.charset.StandardCharsets" )> | |
<cfset oFormat = oCSV.EXCEL.withDelimiter( "|").withFirstRecordAsHeader().withQuote(javacast("char","")).withRecordSeparator("\r\n")> | |
<cfdump var="#oIOFile#" expand="false"> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<cfset dNow = Now()> | |
<cfset dateTimeVar = #dateTimeFormat( dNow, "yyyy.MM.dd HH:nn:ss" )# /> | |
<cfdump var="#dNow#"> | |
<cfdump var="#dateTimeVar#"> | |
<cfoutput> | |
#parseDateTime( dateTimeVar, "yyyy.MM.dd HH:mm:ss" )# | |
#parseDateTime( dateTimeVar, "yyyy.MM.dd HH:nn:ss" )# | |
</cfoutput> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<cfcomponent> | |
<cfset this.name = Hash( GetCurrentTemplatePath() )> | |
<cfset this.webroot = GetDirectoryFromPath(GetCurrentTemplatePath())> | |
</cfcomponent> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"extends": ["plugin:prettier/recommended"], | |
"rules": { | |
"newline-after-var": "error" | |
} | |
} |