情况:你有二个清单,都有多个值.
例如,在supplicants清单中有7个名字,approvers清单中有3名字.
Supplicants清单中是" Hal,Betty,Joe,Chris,Phil,Sue,Moira"
Approvers清单中是" Anne,Steve,Marianne".
你想让两个清单中的名字配对,如下情况:
Hal Anne
Hal Steve
Hal Marianne
Betty Anne
Betty Steve
… …

解决方案: 要在LOOP函数中嵌套另一个LOOP函数,看上去象是一个"套圈".

<cfset supplicants = "Hal,Betty,Joe,Chris,Phil,Sue,Moira">
<cfset approvers = "Anne,Steve,Marianne">

<cfoutput>

<cfloop list="#supplicants#" index="aSupplicant">
  <cfloop list="#approvers#" index="anApprover">
      <p>
        #aSupplicant#  #anApprover#
      </p>
  </cfloop>
</cfloop>

</cfoutput>

如果你需要把数据添加入数据库表中,你也可以用以下方式:
<cfset supplicants = "Hal,Betty,Joe,Chris,Phil,Sue,Moira">
<cfset approvers = "Anne,Steve,Marianne">

<cfoutput>

<cfloop list="#supplicants#" index="aSupplicant">
  <cfloop list="#approvers#" index="anApprover">
    <cfquery datasource="myDS">
      INSERT INTO myTable(supplicantName, approverName)
      VALUES('#aSupplicant#','#anApproveer#')
    </cfquery>
  </cfloop>
</cfloop>

</cfoutput>