sample.cfc

private struct function myFunction() {
	var qryData = queryExecute(
		"SELECT TOP 1 CAST( coreDate as date ) AS lastCoreDate, *
		FROM coreData
		WHERE coreDate IS NOT NULL
		AND (
			    (
				    subID = :subID
				    AND coreName = :coreName
			    ) OR (
				coreName = :coreName
				AND corelocation = :coreLocation
			    )
		    )
        ORDER BY coreId DESC
		",
		{
			subID: arguments.subID,
			coreName: arguments.coreName,
			coreLocation: arguments.coreLocation
		}
	);
    return qryData;
	
}