questo è alla fine ciò che volevo ottenere..
e sbattendo la testa ci sono riuscito..
spero che serva a qualcuno
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/oracle.asp" -->
<%
Dim tab_categorie
Dim tab_categorie_numRows
Dim sGruppo
Set sGruppo = Request.Querystring("formGruppo")
Set tab_categorie = Server.CreateObject("ADODB.Recordset")
tab_categorie.ActiveConnection = MM_oracle_STRING
tab_categorie.Source = "SELECT * FROM MSDN.TAB_CATEGORIE WHERE APPARTENENZA = '" & sGruppo & "'"
tab_categorie.CursorType = 0
tab_categorie.CursorLocation = 2
tab_categorie.LockType = 1
tab_categorie.Open()
tab_categorie_numRows = 0
%>
<html>
<head>
<title>dbmsdn</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<div align="center">
<table align="center" name="tSelezione">
<tr><td>
<form name="formGruppo" method="post" action="dbmsdn.asp">
<select name="selectGruppo" size="1" onChange="location.href='dbmsdn.asp?formGruppo='+this.options[this.selectedIndex].value;">
<option value="">Seleziona GRUPPO</option>
<option value="ARCHIV" <%if sGruppo = "ARCHIV" then Response.Write("selected")%>>Archive</option>
<option value="SDKDDK" <%if sGruppo = "SDKDDK" then Response.Write("selected")%>>Index,SDK,DDK</option>
<option value="SERVER" <%if sGruppo = "SERVER" then Response.Write("selected")%>>Servers</option>
<option value="DEVELO" <%if sGruppo = "DEVELO" then Response.Write("selected")%>>Developer Tools</option>
<option value="PLATFO" <%if sGruppo = "PLATFO" then Response.Write("selected")%>>Platforms</option>
<option value="APPLIC" <%if sGruppo = "APPLIC" then Response.Write("selected")%>>Applications</option>
<option value="LIBRAR" <%if sGruppo = "LIBRAR" then Response.Write("selected")%>>Library</option>
<option value="VARIE" <%if sGruppo = "VARIE" then Response.Write("selected")%>>Varie</option>
</select>
</form>
</td>
<!-- <form>
<input disabled type="text" value="<% Response.Write(sGruppo)%>">
</form>-->
<td >
<form name="formDescriz">
<select name="selectDescriz">
<%While (NOT tab_categorie.EOF)%>
<option value="<%=(tab_categorie.Fields.Item("ID_GRUPPO").Value)%>"><%=(tab_categorie.Fields.Item("DESCRIPTION").Value)%></option>
<%tab_categorie.MoveNext()
Wend
If (tab_categorie.CursorType > 0) Then
tab_categorie.MoveFirst
Else
tab_categorie.Requery
End If%>
</select>
</form>
</td></tr>
</table>
</div>
</body>
</html>
<%
tab_categorie.Close()
Set tab_categorie = Nothing
%>:
