ColdFusion 查询下拉列表

发布于 2024-12-20 07:54:24 字数 722 浏览 3 评论 0原文

是否可以用查询结果填充下拉列表？例如，使用以下输出：Peps Company - AL 即（公司和州）用连字符分隔。

编辑：抱歉遗漏了代码。只有一个数据源。

<cfquery name="CompanyInfo" datasource=>
SELECT  company, state
FROM    clients
WHERE   serv_billing = 1 
AND     status = 'Active' 
ORDER BY Company
</cfquery>


<FORM METHOD="POST" ACTION="nextpage.cfm">
    <SELECT name="company">
      <CFOUTPUT QUERY="CompanyInfo">
        <OPTION value="#CompanyInfo.company#">#CompanyInfo.company# - #CompanyInfo.state#</OPTION>
      </CFOUTPUT>
    </SELECT>
    <INPUT TYPE="submit" VALUE="Submit Company">
</FORM>

这段代码会给我所需的下拉列表项格式，即 Peps - AL 吗？

？

原文

Is it possible to populate a dropdown list with query results? For example with this output: Peps Company - AL ie (Company and State) separated with a hyphen.

Edit: Sorry for leaving out code. There is only one datasource.

<cfquery name="CompanyInfo" datasource=>
SELECT  company, state
FROM    clients
WHERE   serv_billing = 1 
AND     status = 'Active' 
ORDER BY Company
</cfquery>


<FORM METHOD="POST" ACTION="nextpage.cfm">
    <SELECT name="company">
      <CFOUTPUT QUERY="CompanyInfo">
        <OPTION value="#CompanyInfo.company#">#CompanyInfo.company# - #CompanyInfo.state#</OPTION>
      </CFOUTPUT>
    </SELECT>
    <INPUT TYPE="submit" VALUE="Submit Company">
</FORM>

Would this code give me the desired format for the dropdown list items ie Peps - AL?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

少女情怀诗 2024-12-27 07:54:24

答案是肯定的。这段代码正是这样做的。

行不通吗？你有问题吗，或者..？我觉得很奇怪，你没有简单地尝试一下，因为你似乎已经有了可以做你想做的事情的代码。

回复收藏 0 原文

〆凄凉。 2024-12-27 07:54:24

Seybsen 的答案在技术上是正确的，但是，我会强迫您遵循最佳实践并执行单个循环，而不是迭代将主查询的每一行结果返回到数据库：

<CFQUERY name="qCompanies" datasource="yourdsn">
  SELECT companies.id, companies.company, states.state_code
  FROM companies
  INNER JOIN states ON (companies.state_id = states.state_id)
</CFQUERY>

<SELECT name="company">
  <CFOUTPUT QUERY="qCompanies">
    <OPTION value="#qCompanies.id#">#qCompanies.company# - #qCompanies.state_code#</OPTION>
  </CFOUTPUT>
</SELECT>

Seybsen's answer is technically correct, however, I would compel you to follow best practices and perform a single loop, rather than iterative returns to the database on each row result of the main query:

<CFQUERY name="qCompanies" datasource="yourdsn">
  SELECT companies.id, companies.company, states.state_code
  FROM companies
  INNER JOIN states ON (companies.state_id = states.state_id)
</CFQUERY>

<SELECT name="company">
  <CFOUTPUT QUERY="qCompanies">
    <OPTION value="#qCompanies.id#">#qCompanies.company# - #qCompanies.state_code#</OPTION>
  </CFOUTPUT>
</SELECT>

回复收藏 0 原文

泪之魂 2024-12-27 07:54:24

你可以用 cfloop 来做到这一点，如下所示：

 <cfquery name="CompanyInfo" datasource="yourdsn">
  SELECT company, state
  FROM clients
  WHERE serv_billing = 1 AND status = 'Active' 
  Order by Company
</cfquery>

<FORM METHOD="POST" ACTION="nextpage.cfm">
  <SELECT name="company">
    <CFLOOP QUERY="CompanyInfo">
       <OPTION value="#CompanyInfo.company#">#CompanyInfo.company# - #CompanyInfo.state#</OPTION>
    </CFLOOP>
 </SELECT>
 <INPUT TYPE="submit" VALUE="Submit Company">
</FORM>

You can do it with cfloop like this:

 <cfquery name="CompanyInfo" datasource="yourdsn">
  SELECT company, state
  FROM clients
  WHERE serv_billing = 1 AND status = 'Active' 
  Order by Company
</cfquery>

<FORM METHOD="POST" ACTION="nextpage.cfm">
  <SELECT name="company">
    <CFLOOP QUERY="CompanyInfo">
       <OPTION value="#CompanyInfo.company#">#CompanyInfo.company# - #CompanyInfo.state#</OPTION>
    </CFLOOP>
 </SELECT>
 <INPUT TYPE="submit" VALUE="Submit Company">
</FORM>

回复收藏 0 原文

~没有更多了~