[thelist] Weird SELECT DISTINCT error
Casey
aspnet at thecrookstons.com
Fri Dec 16 07:12:18 CST 2005
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
More information about the thelist
mailing list