Ver Mensaje Individual
  #4 (permalink)  
Antiguo 06/09/2012, 07:51
elielbeck
 
Fecha de Ingreso: marzo-2008
Mensajes: 228
Antigüedad: 14 años, 8 meses
Puntos: 12
Respuesta: Problema con buscador ASP (no da resultados)

index2.asp (part 2)

Código:
  <tr>
    <td background="img/property_back.jpg"><table width="955">
      <tr>
        <td width="378" valign="top"><form id="Search" name="Search" method="post" action="search_property.asp">
            <br />
            <table width="331" align="center" background="img/transparent.png">
              <tr>
                <td height="29" colspan="2"><div align="center"><span class="style21">Search for your property here</span>:</div></td>
              </tr>
              
              <tr>
                <td class="style9"><div align="right" class="style20">Ref:</div></td>
                <td><select name="Ref" class="style3" id="Ref">
                  <option value="Total">All</option>
                  <%
While (NOT Ref.EOF)
%>
                  <option value="<%=(Ref.Fields.Item("Ref").Value)%>"><%=(Ref.Fields.Item("Ref").Value)%></option>
                  <%
  Ref.MoveNext()
Wend
If (Ref.CursorType > 0) Then
  Ref.MoveFirst
Else
  Ref.Requery
End If
%>
                </select></td>
              </tr>
              <tr>
                <td width="135" class="style9"><div align="right" class="style18">New or Resale:</div></td>
                <td width="184"><label>
                <select name="New_resale" class="style3" id="New_resale">
                  <option value="Total">All</option>
                  <option value="New Property">New Property</option>
                  <option value="Resale Property">Resale Property</option>
                    </select>
                </label></td>
              </tr>
              <tr>
                <td class="style3"><div align="right" class="style20">Location:</div></td>
                <td><label>
                    <select name="Town" class="style3" id="Town">
                      <option value="Total" <%If (Not isNull((Town.Fields.Item("Town").Value))) Then If ("Total" = CStr((Town.Fields.Item("Town").Value))) Then Response.Write("selected=""selected""") : Response.Write("")%>>All</option>
                      <%
While (NOT Town.EOF)
%><option value="<%=(Town.Fields.Item("Town").Value)%>" <%If (Not isNull((Town.Fields.Item("Town").Value))) Then If (CStr(Town.Fields.Item("Town").Value) = CStr((Town.Fields.Item("Town").Value))) Then Response.Write("selected=""selected""") : Response.Write("")%> ><%=(Town.Fields.Item("Town").Value)%></option>
                      <%
  Town.MoveNext()
Wend
If (Town.CursorType > 0) Then
  Town.MoveFirst
Else
  Town.Requery
End If
%>
                    </select>
                    <div align="left"></div>
                  </label></td>
              </tr>
              <tr>
                <td class="style3"><div align="right" class="style20">Property type:</div></td>
                <td><label>
                    <select name="Type_English" class="style3" id="Type_English">
                      <option value="Total">Alll</option>
                      <option value="Apartment">Apartment</option>
                      <option value="Bungalow">Bungalow</option>
                      <option value="Townhouse">Townhouse</option>
                      <option value="Villa">Villa</option>
                      <option value="Duplex">Duplex</option>
                      <option value="Business premises">Business premises</option>
                      <option value="Plot Land">Plot Land</option>
                    </select>
                    <div align="left"></div>
                  </label></td>
              </tr>
              <tr>
                <td class="style3"><div align="right" class="style20">Bedrooms:</div></td>
                <td><div align="left">
                  <select name="Bedrooms" class="style3" id="Bedrooms">
                    <option value="Total">All</option>
                    <option value="1">1</option>
                    <option value="2">2</option>
                    <option value="3">3</option>
                    <option value="4">4</option>
                    <option value="5">5</option>
                    <option value="6">6</option>
                    <option value="7">7</option>
                    <option value="8">8</option>
                    <option value="9">9</option>
                    <option value="10">10</option>
                      </select>
                </div></td>
              </tr>
              <tr>
                <td class="style3"><div align="right" class="style20">Bathrooms:</div></td>
                <td><div align="left">
                    <select name="Bathrooms" class="style3" id="Bathrooms">
                      <option value="Total">All</option>
                      <option value="1">1</option>
                      <option value="2">2</option>
                      <option value="3">3</option>
                      <option value="4">4</option>
                      <option value="5">5</option>
                      <option value="6">6</option>
                      <option value="7">7</option>
                      <option value="8">8</option>
                      <option value="9">9</option>
                      <option value="10">10</option>
                    </select>
                </div></td>
              </tr>
              <tr>
                <td height="22" class="style3"><div align="right" class="style20">Max. Price:</div></td>
                <td><div align="left">
                    <label>
                    <select name="Price" id="Price">
                      <option value="Total">All</option>
                      <option value="50000">50.000 &euro;</option>
                      <option value="60000">60.000 &euro;</option>
                      <option value="70000">70.000 &euro;</option>
                      <option value="80000">80.000 &euro;</option>
                      <option value="90000">90.000 &euro;</option>
                      <option value="100000">100.000 &euro;</option>
                      <option value="120000">120.000 &euro;</option>
                      <option value="140000">140.000 &euro;</option>
                      <option value="160000">160.000 &euro;</option>
                      <option value="180000">180.000 &euro;</option>
                      <option value="200000">200.000 &euro;</option>
                      <option value="240000">240.000 &euro;</option>
                      <option value="260000">260.000 &euro;</option>
                      <option value="280000">280.000 &euro;</option>
                      <option value="300000">300.000 &euro;</option>
                      <option value="350000">350.000 &euro;</option>
                      <option value="400000">400.000 &euro;</option>
                      <option value="450000">450.000 &euro;</option>
                      <option value="500000">500.000 &euro;</option>
                      <option value="600000">600.000 &euro;</option>
                      <option value="700000">700.000 &euro;</option>
                      <option value="800000">800.000 &euro;</option>
                      <option value="900000">900.000 &euro;</option>
                      <option value="1000000">1.000.000 &euro;</option>
                      <option value="1500000">1.500.000 &euro;</option>
                      <option value="2000000">2.000.000 &euro;</option>
                      <option value="3000000">3.000.000 &euro;</option>
                      <option value="4000000">4.000.000 &euro;</option>
                      <option value="5000000">5.000.000 &euro;</option>
                    </select>
                    </label>
                </div></td>
              </tr>
              <tr>
                <td height="50">&nbsp;</td>
                <td><label>
                    <span class="style3">
                    <input name="Send" type="submit" class="style4" id="Send" value="Search" />
                    </span>
                    <div align="right" class="style3"></div>
                  </label></td>
              </tr>
            </table>
        </form></td>
        <td width="565" height="400" valign="top">&nbsp;</td>
      </tr>
    </table></td>
  </tr>