[thelist] Weird SELECT DISTINCT error

[Casey]

Thanks everyone for your feedback.  MUCH appreciated.  Sometimes just asking 
the question will clear your head enough to see the
problem.


function BuildDrop(tableName,table,pid)
sql = "SELECT DISTINCT " & tableName & " FROM " & table & "WHERE Producer_ID
= " & pid & " AND Active_Code = 1"
set rs= Conn.execute(sql)
do while not rs.eof
temp = ("<option value='" & rs(0) & "'>" & rs(1) & "</option>")
rs.movenext
loop
BuildDrop = temp
end function

The obvious problem... rsPolicy(1)

Casey