Arrays

[Eugene Anthony]

<%
openDB()

call updateDB("usp_retrieveOptions",rs)

if not rs.eof AND (UBOUND(Arr)) < CInt(rs("rc")) - 1 then
%>
<tr>
<td width="66">Options</td>
<td width="137">
<select name="select1" class="TextField1">
<%
i = 0

do while not rs.eof

if rs(0) <> Arr(i) then
response.write "<option value=" & rs(0) & ">" & rs(1)
end if

rs.movenext

loop
%>
</select>


I am facing problem is this part:

if rs(0) <> Arr(i) then
response.write "<option value=" & rs(0) & ">" & rs(1)
end if

There is a set of values stored in Arr(). Now if if rs(0) <> Arr()
display in the combo box.

How is it done?

Your help is kindly appreciated.


Eugene Anthony