Ciao Raga, vi posto il codice che ho fatto per la selezione da combobox popolate dal database per la ricerca di immobili:
solo che ho alcuni problemi... forse sta nell'sql..
dovrei estrarre da una tabella database da 4 select ...
vi posto il codice:

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Nuova pagina 1</title>
</head>

<body>



</p>
<form BOTID="0" METHOD="GET" ACTION="risultati.asp">
<table BORDER="0">
<tr>
<td>PROVINCIA</td>
<td><select size="1" name="provincia">
<option value="%">SELEZIONA</option>
<option>BERGAMO</option>
</select></td>
</tr>
<tr>
<td>LOCALITA</td>
<td><select size="1" name="localita">
<option value="%">SELEZIONA</option>
<option>ZOGNO</option>
<option>BERGAMO</option>
</select></td>
</tr>
<tr>
<td>TIPOLOGIA</td>
<td><select size="1" name="tipologia">
<option value="%">SELEZIONA</option>
<option>APPARTAMENTO</option>
<option>VILLA</option>
</select></td>
</tr>
<tr>
<td>CONTRATTO</td>
<td><select size="1" name="contratto">
<option value="%">SELEZIONA</option>
<option>AFFITTO</option>
<option>VENDITA</option>
</select></td>
</tr>
</table>


<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP" CLIENTSIDE
SuggestedExt="asp" PREVIEW=" " -->


</p>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td></td>
<td>PROVINCIA</td>
<td>LOCALITA</td>
<td>TIPOLOGIA</td>
<td>LOCALI</td>
<td>CONTRATTO</td>
<td>PREZZO €</td>
<td>DESCRIZIONE</td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="ID_IMMOB,PROVINCIA,LOCALITA,TIPOLOGIA ,LOCALI,CONTRATTO,PREZZO,DESCRIZIONE"
s-columntypes="3,202,202,202,202,202,6,202" s-dataconnection="Database"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="PROVINCIA"
s-menuvalue="PROVINCIA" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-ListFormat="0" b-makeform="FALSE" s-recordsource
s-displaycolumns="PROVINCIA,LOCALITA,TIPOLOGIA,LOCAL I,CONTRATTO,PREZZO,DESCRIZIONE"
s-criteria s-order
s-sql="SELECT * FROM immobili WHERE (PROVINCIA = '::PROVINCIA::' OR LOCALITA = '::LOCALITA::' OR TIPOLOGIA = '::TIPOLOGIA::' OR CONTRATTO = '::CONTRATTO::')"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="PROVINCIA=&amp;amp;LOCALITA=&amp;am p;TIPOLOGIA=&amp;amp;CONTRATTO="
s-NoRecordsFound="Nessun record restituito." i-MaxRecords="256"
i-GroupSize="5" BOTID="0" u-dblib="_fpclass/fpdblib.inc"
u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc"
tag="TBODY"
local_preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;Per visualizzare l'anteprima di un'area risultati database è necessario accedere alla pagina connettendosi al server Web tramite browser. La riga seguente verrà ripetuta per ciascun record restituito dalla query.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;"
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;Inizio dell'area risultati database. Per visualizzare correttamente l'area risultati database è necessario accedere alla pagina connettendosi al server Web tramite browser. Il Web corrente è memorizzato nella rete o in un disco locale.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;"
b-WasTableFormat="TRUE" b-ReplaceDatabaseRegion="FALSE" -->
<%
fp_sQry="SELECT * FROM immobili WHERE (PROVINCIA = '::PROVINCIA::' OR LOCALITA = '::LOCALITA::' OR TIPOLOGIA = '::TIPOLOGIA::' OR CONTRATTO = '::CONTRATTO::')"
fp_sDefault="PROVINCIA=&LOCALITA=&TIPOLOGIA=&CONTR ATTO="
fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">Nessun record restituito.</td></tr>"
fp_sDataConn="Database"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="PROVINCIA"
fp_sMenuValue="PROVINCIA"
fp_iDisplayCols=7
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


<tr>
<td></td>
<td><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="ID_IMMOB,PROVINCIA,LOCALITA,TIPOLOGIA ,LOCALI,CONTRATTO,PREZZO,DESCRIZIONE"
s-column="PROVINCIA" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;PROVINCIA&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;PROVINCIA&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"PROVINCIA")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="12207" endspan -->
</td>
<td><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="ID_IMMOB,PROVINCIA,LOCALITA,TIPOLOGIA ,LOCALI,CONTRATTO,PREZZO,DESCRIZIONE"
s-column="LOCALITA" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;LOCALITA&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;LOCALITA&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"LOCALITA")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="10211" endspan -->
</td>
<td><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="ID_IMMOB,PROVINCIA,LOCALITA,TIPOLOGIA ,LOCALI,CONTRATTO,PREZZO,DESCRIZIONE"
s-column="TIPOLOGIA" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;TIPOLOGIA&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;TIPOLOGIA&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"TIPOLOGIA")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="11382" endspan -->
</td>
<td><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="ID_IMMOB,PROVINCIA,LOCALITA,TIPOLOGIA ,LOCALI,CONTRATTO,PREZZO,DESCRIZIONE"
s-column="LOCALI" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;LOCALI&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;LOCALI&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"LOCALI")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="11362" endspan -->
</td>
<td><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="ID_IMMOB,PROVINCIA,LOCALITA,TIPOLOGIA ,LOCALI,CONTRATTO,PREZZO,DESCRIZIONE"
s-column="CONTRATTO" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;CONTRATTO&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;CONTRATTO&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"CONTRATTO")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="12438" endspan -->
</td>
<td><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="ID_IMMOB,PROVINCIA,LOCALITA,TIPOLOGIA ,LOCALI,CONTRATTO,PREZZO,DESCRIZIONE"
s-column="PREZZO" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;PREZZO&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;PREZZO&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"PREZZO")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="12158" endspan -->
</td>
<td><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="ID_IMMOB,PROVINCIA,LOCALITA,TIPOLOGIA ,LOCALI,CONTRATTO,PREZZO,DESCRIZIONE"
s-column="DESCRIZIONE" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;DESCRIZIONE&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;DESCRIZIONE&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" --><%=FP_FieldVal(fp_rs,"DESCRIZIONE")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="17859" endspan -->
</td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5"
clientside tag="TBODY"
local_preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;Fine dell'area risultati database.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64&gt;&lt;FORM&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt; [1/5]&lt;/NOBR&gt;&lt;/FORM&gt;&lt;/td&gt;&lt;/tr&gt;"
preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; align=&quot;left&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;Fine dell'area risultati database.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot; |&lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &lt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt; &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot; &gt;| &quot;&gt; [1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" -->

</tbody>
</table>

</body>

</html>

ora: fiunziona tutto solo che se un capo da select box viene bypassato dall'utente nn mi funziona...come si fa? inoltre: qual'è il valore da aggiungere alla select box per TUTTI?

Particamente è un modulo di ricerca per un agenzia immobiliare..
tipo: www.esseviimmobili.it