Skip to content

Instantly share code, notes, and snippets.

<cfscript>
checkFields = ["test1", "test2"]
temp = hashasSuspiciousInput(checkFields);
writeoutput(temp);
public boolean function hasSuspiciousInput( required array checkFields ) {
var suspiciousInput = false;
var sqlPatterns = getSQLInjecionPatterns();
cfloop( array=arguments.checkFields, index="fieldValue" ){
if( fieldValue.trim().len() > 0 ) {
cfloop( array=sqlPatterns, index="pattern" ){
<cfscript>
checkFields = ["test1", "test2"]
temp = hashasSuspiciousInput(checkFields);
public boolean function hasSuspiciousInput( required array checkFields ) {
var suspiciousInput = false;
var sqlPatterns = getSQLInjecionPatterns();
cfloop( array=arguments.checkFields, index="fieldValue" ){
if( fieldValue.trim().len() > 0 ) {
cfloop( array=sqlPatterns, index="pattern" ){
if( reFindNoCase(pattern, fieldValue) ) {
<cfscript>
checkFields = ["test1", "test2"]
temp = hashasSuspiciousInput();
public boolean function hasSuspiciousInput( required array checkFields ) {
var suspiciousInput = false;
var sqlPatterns = getSQLInjecionPatterns();
cfloop( array=arguments.checkFields, index="fieldValue" ){
if( fieldValue.trim().len() > 0 ) {
cfloop( array=sqlPatterns, index="pattern" ){
if( reFindNoCase(pattern, fieldValue) ) {
<cfjava handle = "instance">
public class Car{
public String model;
public int year;
public Car(String carModel, int carYear){
this.model = carModel;
this.year = carYear;
}
<cfjava handle = "instance">
public class car{
public String model;
public int year;
public car(String carModel, int carYear){
this.model = carModel;
this.year = carYear;
}
<cfscript>
//query
myQuery = queryNew("id,name,amount,revenue","Integer,Varchar,Integer,Integer",
[
{id=1,name="One",amount=15,revenue=35},
{id=2,name=JavaCast("null", ""),amount=18,revenue=41},
{id=3,name="Three",amount=32,revenue=73}
]);
writeOutput("The new query is:");
writeDump(myQuery);
<cfset dt = ParseDateTime('2026-02-02', 'yyyy-mm-dd')>
<cfset res = dateCompare(dt, '2026-02-02', 'd')>
<Cfoutput>#res#</Cfoutput>
<cfif res gt 0>
<Cfoutput>hola</Cfoutput>
</cfif>
<cfset dt = ParseDateTime('2026/02/02', 'yyyy-mm-dd')>
<cfset dateCompare(dt, now(), 'd')>
<cfset dt = ParseDateTime('2026/02/02', 'yyyy-mm-dd')>
<cfset dateCompare(dt, now(), 'd') lte 0 >
<cfscript>
dateCompare(dt, now(), 'd') lte 0
</cfscript>