删除

发布于 2024-09-27 02:35:11 字数 1161 浏览 0 评论 0原文

我在更新表单“id=”tak_id”' 中有一个下拉列表，是从查询“takType”填充的。下拉框有“短信、聊天、推文”三个选项，具有三个不同的值“001,002,003”。

字段中的 SELECTED 值重复两次。如何使 SELECTED 值仅出现一次？

代码如下，

<cfselect name="tak_id" id="tak_id">
    <cfoutput query="takType">
                      <option >select one</option>
                      <option value="#takType.tak_id#" <cfif takType.tak_id IS tak_id > selected </cfif> > 
                      <cfswitch expression="#takType.tak_id#">
                           <cfcase value="01">SMS </cfcase>
                           <cfcase value="02">chat </cfcase>
                           <cfcase value="03">tweet </cfcase>
                      </cfswitch>
                     </option>
                      <option value="01" >SMS</option>
                      <option value="02" >chat</option>
                      <option value="03" >tweet</option>
    </cfoutput>
    </cfselect>
                </td>                        
            </tr>

非常感谢弗朗西斯

原文

I have an drop down in an Update form ‘id=”tak_id”’ being populated from an query”takType”. The drop down box has three options “sms, chat, tweet” with three different values”001,002,003”.

The SELECTED value in the field is being repeated twice.How can I make the SELECTED value appear only once?

The code is below

<cfselect name="tak_id" id="tak_id">
    <cfoutput query="takType">
                      <option >select one</option>
                      <option value="#takType.tak_id#" <cfif takType.tak_id IS tak_id > selected </cfif> > 
                      <cfswitch expression="#takType.tak_id#">
                           <cfcase value="01">SMS </cfcase>
                           <cfcase value="02">chat </cfcase>
                           <cfcase value="03">tweet </cfcase>
                      </cfswitch>
                     </option>
                      <option value="01" >SMS</option>
                      <option value="02" >chat</option>
                      <option value="03" >tweet</option>
    </cfoutput>
    </cfselect>
                </td>                        
            </tr>

thanks a lot
Fransis

分享到QQ

分享到微博

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

发布评论

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

找回味觉 2024-10-04 02:35:11

为什么不将 cfif 语句移至三个硬编码选项中的每一个中？

<cfoutput query="takType">
                  <option >select one</option>

                  <option value="01" <cfif takType.tak_id IS "01" >selected</cfif>>SMS</option>
                  <option value="02" <cfif takType.tak_id IS "02" >selected</cfif>>chat</option>
                  <option value="03" <cfif takType.tak_id IS "03" >selected</cfif>>tweet</option>
</cfoutput>
</cfselect>

Why not move the cfif statement into each of the three hard coded options?

<cfoutput query="takType">
                  <option >select one</option>

                  <option value="01" <cfif takType.tak_id IS "01" >selected</cfif>>SMS</option>
                  <option value="02" <cfif takType.tak_id IS "02" >selected</cfif>>chat</option>
                  <option value="03" <cfif takType.tak_id IS "03" >selected</cfif>>tweet</option>
</cfoutput>
</cfselect>

回复收藏 0 原文

围归者 2024-10-04 02:35:11

我认为您的意思是仅将 cfoutputs 包裹在第一组周围，并删除底部的硬编码三个。像这样：

<cfselect name="tak_id" id="tak_id"> 
  <option >select one</option>
  <cfoutput query="takType">
  <option value="#takType.tak_id#" <cfif takType.tak_id IS tak_id > selected </cfif> >
  <cfswitch expression="#takType.tak_id#">
    <cfcase value="01">
    SMS
    </cfcase>
    <cfcase value="02">
    chat
    </cfcase>
    <cfcase value="03">
    tweet
    </cfcase>
  </cfswitch>
  </option>
  </cfoutput>
 </cfselect>

不过，可能有助于查看该查询的转储，因为这依赖于数据库中的这三个查询。

I think you mean to wrap the cfoutputs around the first group only and remove the hard coded three at the bottom. Like this:

<cfselect name="tak_id" id="tak_id"> 
  <option >select one</option>
  <cfoutput query="takType">
  <option value="#takType.tak_id#" <cfif takType.tak_id IS tak_id > selected </cfif> >
  <cfswitch expression="#takType.tak_id#">
    <cfcase value="01">
    SMS
    </cfcase>
    <cfcase value="02">
    chat
    </cfcase>
    <cfcase value="03">
    tweet
    </cfcase>
  </cfswitch>
  </option>
  </cfoutput>
 </cfselect>

Might help to see a dump of that query though, since this relies on those three being in the database.

回复收藏 0 原文

~没有更多了~