Apici in evento onChange

[chipdb]

Così può andare?

<%    
    Tit = replace(Request.QueryString("Tit"), "'", "''")

    sql = "SELECT  "
    sql = sql & " Tit "
    sql = sql & " FROM "
    sql = sql & " tbl "
    sql = sql & " ORDER BY "
    sql = sql & " Tit asc"
     
    Set rec = Conn.execute(sql)
%>
                     
<select size="1" name="Tit" onChange="window.document.location='pag.asp?Tit='+this.options[this.selectedIndex].value;">
<option>Seleziona Tit</option>

<%
while not rec.eof
    if rec("Tit") = Tit then
%>
    <option value="<%=rec("Tit")%>" selected><%=rec("Tit")%></option>
<% 
    else
%>
    <option value="<%=rec("Tit")%>"><%=rec("Tit")%></option>
<%
    end if
    rec.MoveNext
wend

rec.Close
set rec = Nothing
%>

</select>