twelverobots

<cfcomponent>
  <cffunction name="getUserByUsername" access="public" returntype="query" output="false">
		<cfargument name="username" type="string" required="true" />
		
		<cfset var getUser = "" />
		<cfquery name="getUser" datasource="blog-jason">
			SELECT *
			FROM USERS
			WHERE username = <cfqueryparam  value="#arguments.username#" cfsqltype="cf_sql_varchar" />
		</cfquery>

twelverobots

<!--- Create array of all numbers --->
<cfset aNumbers = [] />

<!--- Initialize Array with unmarked, except one --->
<cfset arraySet(aNumbers, 2, 1000, "unmarked") />
<cfset aNumbers[1] = "one" />

<!--- Loop over Array --->
<cfloop from="2" to="#arrayLen(aNumbers)#" index="numIndex">