绑定3 cfselect会产生错误。

Question

我有三个选择框:州，区，学校。如果我没有这所学校的话，前两个很棒，但学校实际上是最重要的部分。没有学校，选择一切都很好。在学校信箱里，我得到了一个错误：

绑定失败，元素未找到: pid

CFC

<cfcomponent>
    <cfset THIS.dsn="whatever">

    <cffunction name="getDistricts" access="remote" returntype="query">
        <cfargument name="state" required="yes" hint="The districts are in this state." />
        <cfstoredproc datasource="#THIS.dsn#" procedure="getSchoolAndDistrict" returncode="yes">
            <cfprocparam cfsqltype="cf_sql_varchar" dbvarname="@mstate" value="#arguments.state#" type="in">
            <cfprocresult resultset="1" name="districts">
        </cfstoredproc>
        <cfreturn districts>
    </cffunction>


    <cffunction name="getSchools" access="remote" returntype="query">
        <cfargument name="state" required="yes" hint="The districts are in this state." />
        <cfargument name="pid" required="yes" hint="The district pid." />
        <cfstoredproc datasource="#THIS.dsn#" procedure="getSchoolAndDistrict" returncode="yes">
            <cfprocparam cfsqltype="cf_sql_varchar" dbvarname="@mstate" value="#arguments.state#" type="in">
            <cfprocparam cfsqltype="cf_sql_varchar" dbvarname="@pid" value="#arguments.pid#" type="in">
            <cfprocresult resultset="2" name="schools">
        </cfstoredproc>
        <cfreturn schools>
    </cffunction>

</cfcomponent>

CFM

<cfoutput>
<cfform action="#CGI.PATH_INFO#" name="testdistricts" method="post">

    <cfselect name="states" query="states" 
         queryPosition="below"  
         display="state" value="state">
        <option value="">State</option>
    </cfselect>
    &nbsp;
    <cfselect name="districts" 
         bind="cfc:cfcs.getDistricts.getDistricts({states})" 
         queryPosition="below" 
         display="name" value="pid" bindonload="no">
        <option value="">District</option></cfselect>
    &nbsp;
    <cfselect name="schools" 
          bind="cfc:cfcs.getDistricts.getSchools({pid})" 
          queryPosition="below" 
          display="name" value="pid" bindonload="no">

        <option value="">School</option>
    </cfselect>
    <br> <br>

    <cfinput type="submit" name="submit" value="Submit">
</cfform>
</cfoutput>

Answer 1

您的问题是，学校选择被绑定到所选选项的值，而不是绑定到地区控制本身.

    <cfform action="#CGI.PATH_INFO#" name="testdistricts" method="post">

    <cfselect name="states" query="states" 
         queryPosition="below"  
         display="state" value="state">
        <option value="">State</option>
    </cfselect>
    &nbsp;
    <cfselect name="districts" 
         bind="cfc:cfcs.getDistricts.getDistricts({states})" 
         queryPosition="below" 
         display="name" value="pid" bindonload="no">
        <option value="">District</option></cfselect>
    &nbsp;
    <cfselect name="schools" 
          bind="cfc:cfcs.getDistricts.getSchools({districts})" 
          queryPosition="below" 
          display="name" value="pid" bindonload="no">

        <option value="">School</option>
    </cfselect>
    <br> <br>

    <cfinput type="submit" name="submit" value="Submit">
</cfform>

这就是你的问题所在

bind="cfc:cfcs.getDistricts.getSchools({districts})"