StackOverflow Q - 49452518

ColdFusion:

<cfcomponent output="false">
    <!---  Get YARDS dataset based on SITE  --->
    <cffunction name="getYards" access="remote" returntype="array" >
        <cfargument name="Site" type="string" required="true" />

        <cfset var rs_Yards = "">
        <cfset var response = []>

        <!--- simulate your cfquery --->
        <cfset rs_Yards = QueryNew("")>
        <cfset queryAddColumn(rs_Yards, "Yard", ["X-745-C ","X-745-C5","X-745-E ","X-745-G "])>

        <cfloop query="rs_Yards">
            <cfset arrayAppend(response, { "yard": rs_Yards.yard })>
        </cfloop>

        <cfreturn response />
        </cffunction>
</cfcomponent>

HTML:
$(document).ready(function() {
    $("#SITE").change(function() {
        $("#YARD").empty();
        $.ajax({
            type: "GET",
            url: "AjaxFunctions.cfc?method=getYards&returnformat=JSON",
            data: {Site: $("#SITE").val()},
            dataType: "json",
            success: function(data) {
                $.each(data, function() {
                     $("#YARD").append($("<option></option>").val(this.yard).text(this.yard));
                });
            }
        });
    });
});