TryCF Gist

trycf-gist-1708293529285-771d7de7-6c67-8e99-6829-02bac97ed66d.cfm

<cfscript>

cache_time = createTimeSpan(1,0,0,0);

function foo(args) cachedwithin=cache_time{
    return args;
}

writeDump( foo('test') );


/*
queryExecute(
	sql: "
		SELECT *
		FROM table
		WHERE param1 = :param1
		AND param2 = :param2
	",
	params: {
		param1 = {value = "antani", cfsqltype = "varchar"},
		param2 = {value = 2, cfsqltype = "integer"}
	},
	options: { cachedwithin: cache_time } // <----- this works!
);
/* 
		
</cfscript>