1

i'm very new to this. can anyone help me understand how to get the "option value" in a ado loop? thanks so much!

<div class="modal-body">
    <p>Select Member 
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
        <select class="js-select">
            <script>
                var objConnection = new ActiveXObject("adodb.connection");
                var strConn = "driver={sql server};server=localhost;database=mydatabase";
                objConnection.Open(strConn);
                var rs = new ActiveXObject("ADODB.Recordset");
                var strQuery = "SELECT ID, Member FROM tblMembers order by Member";
                rs.Open(strQuery, objConnection);
                rs.MoveFirst();
                while (!rs.EOF)
                    <Option value={
                    document.write(rs.fields(0));>
                    document.write(rs.fields(1));
                    rs.movenext();
                    }</Option>
                rs.close;
                objConnection.close;
            </script>
        </select>
    </p>
</div>
Skwal
  • 2,160
  • 2
  • 20
  • 30
Camille Rivera
  • 11
  • 3
  • See [Adding options to a – Alex K. Dec 05 '17 at 19:10
  • sorry i'm looking at the thread and i can't follow how it would get the rs.field value. can you please elaborate? tyvm! – Camille Rivera Dec 05 '17 at 19:24
  • @Skal. thanks for closing the div. i forgot to include it. – Camille Rivera Dec 05 '17 at 19:28

0 Answers0