Response.write 在具有相同记录集的多个位置 [英] Response.write in multiple place with same recordset

问题描述

我有两个 div

                    <div class="selection mini">
                        <select name="selfromYear">
                            <option selected disabled>From</option>
                            <option>1956</option>
                            <option>1986</option>
                        </select>
                    </div>
                    <div class="selection mini">
                        <select name="selToYear">
                            <option selected disabled>To</option>
                            <option>1956</option>
                            <option>1986</option>
                        </select>
                    </div>

我想用相同的字段填充它们

And I want to fill them with same fields

                        <div class="selection mini">
                            <select name="seltoYear">
                                <option selected disabled>To</option>
                                    <%
                                        Set rs =  rs.NextRecordset
                                            do while not rs.EOF 
                                                    Response.Write "<option>" & rs.Fields(0) & "</option>" & vbCrLf
                                                    rs.MoveNext 
                                            loop
                                    %>
                            </select>
                        </div>
                        <div class="selection mini">
                            <select name="selfromYear">
                                <option selected disabled>From</option>
                                    <%
                                            do while not rs.EOF 
                                                    Response.Write "<option>" & rs.Fields(0) & "</option>" & vbCrLf
                                                    rs.MoveNext 
                                            loop
                                    %>
                            </select>
                        </div>

但只能先填充.

推荐答案

如果do while循环不行，你可以试试用简单的for循环

if its not working by do while loop, you may try using simple for loop

For i as integer=0 to rs.rows.count
Response.Write("<option>"+rs.rows(i).value+"</option>")
Next

这篇关于Response.write 在具有相同记录集的多个位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！