<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%
CULTURE = "ita"
%>
<html>
<head>
<title><%=TITOLO_BROWSER%></title>
<script LANGUAGE="JavaScript" src="../../../../script/rollover.js" type="text/javascript"></script>
<link rel="stylesheet" href="../../../../style/style.css" type="text/css">
</head>
<body>
<div class="sfondo">
<a name=top></a>
<script LANGUAGE="JavaScript" type="text/javascript">
<!--
precaricaImmagini(
'images/menu/<%=CULTURE%>/profilo_off.gif',
'images/menu/<%=CULTURE%>/profilo_on.gif',
'images/menu/<%=CULTURE%>/dove_off.gif',
'images/menu/<%=CULTURE%>/dove_on.gif',
'images/menu/<%=CULTURE%>/noventa_on.gif',
'images/menu/<%=CULTURE%>/noventa_off.gif',
'images/menu/<%=CULTURE%>/albignasego_off.gif',
'images/menu/<%=CULTURE%>/albignasego_on.gif',
'images/menu/<%=CULTURE%>/fiesso_off.gif',
'images/menu/<%=CULTURE%>/fiesso_on.gif',
'images/menu/<%=CULTURE%>/selvazzano_off.gif',
'images/menu/<%=CULTURE%>/selvazzano_on.gif',
'images/menu/<%=CULTURE%>/roncaglia_off.gif',
'images/menu/<%=CULTURE%>/roncaglia_on.gif',
'images/menu/<%=CULTURE%>/lavora_off.gif',
'images/menu/<%=CULTURE%>/lavora_on.gif',
'images/menu/<%=CULTURE%>/contatti_off.gif',
'images/menu/<%=CULTURE%>/contatti_on.gif');
//-->
</script>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="26">
[img]images/home/dot.gif[/img]</td>
<td width="190" align="left" valign="top">
[img]images/home/dot.gif[/img]</td>
<td align="left" valign="top" width="382">
<table width="382" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>[img]images/dot.gif[/img]</td>
</tr>
<tr>
<td>[img]images/linea_or_tit.gif[/img]</td>
</tr>
<tr>
<td align="left" valign="middle">
<h1>[img]images/home/dot.gif[/img]RICERCA</h1>
</td>
</tr>
<tr>
<td>[img]images/linea_or_tit.gif[/img]</td>
</tr>
</table>
</td>
<td>[img]images/dot_blu.gif[/img]</td>
<td width="100%" align="left" valign="top" background="images/foto_dx.jpg"></td>
</tr>
</table>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="26">[img]images/trasparente.gif[/img]</td>
<td width="154" align="left" valign="top">
<table width="154" border="0" cellspacing="0" cellpadding="2">
<tr>
<td align="left" valign="top">
</td>
</tr>
</table>
</td>
<td width="11" align="left" valign="top" bgcolor="#328ECD">[img]images/angolo.gif[/img]
[img]images/trasparente.gif[/img]</td>
<td width="407" align="left" valign="top">
<table width="407" border="0" cellspacing="0" cellpadding="12">
<tr>
<td class="txt" align="center">
<%
If Request.QueryString("action") = "search" Then
F_LOCALITA = Request.Form("localita")
F_CHIAVE = Request.Form("chiave")
End If
%>
<table style="border:1px solid #328ECD;" width="80%">
<tr>
<td colspan="2">
Ricerca immobile</p></td>
</tr>
<tr>
<form action="ricerca.asp?action=search" method="post">
<td>
Località:</p></td>
<td>
<select name="localita">
<option value="1" <% If int(F_LOCALITA) = 1 Then %>selected<% End If %>>noventa</option>
<option value="2" <% If int(F_LOCALITA) = 2 Then %>selected<% End If %>>roncaglia</option>
<option value="3" <% If int(F_LOCALITA) = 3 Then %>selected<% End If %>>albignasego</option>
<option value="4" <% If int(F_LOCALITA) = 4 Then %>selected<% End If %>>fiesso</option>
<option value="5" <% If int(F_LOCALITA) = 5 Then %>selected<% End If %>>selvazzano</option>
<option value="6" <% If int(F_LOCALITA) = 6 Then %>selected<% End If %>>limena</option>
<option value="7" <% If int(F_LOCALITA) = 7 Then %>selected<% End If %>>vigodarzere</option>
<option value="8" <% If int(F_LOCALITA) = 8 Then %>selected<% End If %>>pianiga</option>
<option value="9" <% If int(F_LOCALITA) = 9 Then %>selected<% End If %>>mestrino</option>
<option value="10" <% If int(F_LOCALITA) = 10 Then %>selected<% End If %>>noale</option>
<option value="11" <% If int(F_LOCALITA) = 11 Then %>selected<% End If %>>trebaseleghe</option>
</select>
</td>
</tr>
<tr>
<td>
Parola chiave:</p></td><td><input type="text" name="chiave" value="<%=F_CHIAVE%>" size="30"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Cerca"></td>
</tr>
</form>
</table>
<% If Request.QueryString("action") = "search" Then %>
<%
page = Request.QueryString("page")
if page = "" then
page = 1
end if
page = int(page)
perpage = 5
Set Rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM immobili where tipo ='"& F_LOCALITA &"' AND (BREVE_DESCRIZIONE_ITA LIKE '%"& F_CHIAVE &"%' OR DESCRIZIONE_ITA LIKE '%"& F_CHIAVE &"%') ORDER BY id DESC"
Rs.Open sql, Conn, 1, 3
if Rs.RecordCount <> 0 then
If page = "" then
page = (rs.PageCount)
End if
Rs.PageSize = perpage
Rs.AbsolutePage = page
For i = 1 to perpage
If Not Rs.EOF then
if Rs("id") < 10 then
%>
<table width="382" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"></td>
</tr>
<tr>
<td align="left" valign="top">
<table width="362" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" bgcolor="#CCCCCC">[img]images/trasparente.gif[/img]</td>
</tr>
<tr>
<td bgcolor="#CCCCCC" width="1">[img]images/trasparente.gif[/img]</td>
<td width="110" align="center" valign="middle" bgcolor="#EBEBEB"><img <%if Rs("foto1") <> "null" then%> src="cgi-bin/upload/<%=Rs("foto1")%> <%else%> src="images/nofoto.gif <%end if%>" width="98" height="73" class="icone"></td>
<td bgcolor="#CCCCCC" width="1">[img]images/trasparente.gif[/img]</td>
<td width="249" bgcolor="#EBEBEB" align="left" valign="top">
<table width="249" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="249" border="0" cellspacing="0" cellpadding="5">
<tr>
<td class="txt" height="25">[img]images/quadratino.gif[/img]<%=Rs("localita_"&CULTURE)%></td>
</tr>
<tr>
<td height="42" class="txt" align="left" valign="top"><%=Rs("breve_descrizione_"&CULTURE)%> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="249" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="159" class="txt"><%=Rs("prezzo")%></td>
<td align="right" width="90">
">[img]images/<%=CULTURE%>/dettagli.gif[/img]</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td bgcolor="#CCCCCC" width="1">[img]images/trasparente.gif[/img]</td>
</tr>
<tr>
<td colspan="5" bgcolor="#CCCCCC">[img]images/trasparente.gif[/img]</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" valign="top"></td>
</tr>
</table>
<%
else
%>
<table width="382" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"></td>
</tr>
<tr>
<td align="left" valign="top">
<table width="362" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" bgcolor="#CCCCCC">[img]images/trasparente.gif[/img]</td>
</tr>
<tr>
<td bgcolor="#CCCCCC" width="1">[img]images/trasparente.gif[/img]</td>
<td width="110" align="center" valign="middle" bgcolor="#EBEBEB">[img]cgi-bin/upload/<%=Rs([/img]" width="98" height="73" class="icone"></td>
<td bgcolor="#CCCCCC" width="1">[img]images/trasparente.gif[/img]</td>
<td width="249" bgcolor="#EBEBEB" align="left" valign="top">
<table width="249" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="249" border="0" cellspacing="0" cellpadding="5">
<tr>
<td class="txt" height="25">[img]images/quadratino.gif[/img]<%=Rs("localita_"&CULTURE)%></td>
</tr>
<tr>
<td height="42" class="txt" align="left" valign="top"><%=Rs("breve_descrizione_"&CULTURE)%> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="249" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="159" class="txt"><%=Rs("prezzo")%></td>
<td align="right" valign="bottom" width="90">
">[img]images/<%=CULTURE%>/dettagli.gif[/img]</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td bgcolor="#CCCCCC" width="1">[img]images/trasparente.gif[/img]</td>
</tr>
<tr>
<td colspan="5" bgcolor="#CCCCCC">[img]images/trasparente.gif[/img]</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="left" valign="top"></td>
</tr>
</table>
<%
end if
Rs.MoveNext
end if
next
Response.Write "<tr><td align='center' valign='top'>
Pagine: "
For pag= 1 to rs.PageCount
if page = pag then
Response.Write pag & ""
else
Response.Write "
" & pag & ""
end if
Next
Response.Write "</td></tr>"
else
Response.Write "
<p align='center'>Nessun record soddisfa la ricerca.</p>"
end if
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
%>
<% End If %>
</td>
</tr>
</table>
</td>
<td width="2" align="left" valign="top" bgcolor="#328ECD">[img]images/trasparente.gif[/img]</td>
</tr>
<tr>
<td width="26"></td>
<td width="154" align="left" valign="top"></td>
<td width="11" align="left" valign="top" bgcolor="#328ECD">[img]images/trasparente.gif[/img]</td>
<td width="407" align="left" valign="bottom">[img]images/bottom.gif[/img]</td>
<td width="2" align="left" valign="top" bgcolor="#328ECD">[img]images/trasparente.gif[/img]</td>
</tr>
</table>
</div>
</body>
</html>