[akgun]

arkadaşlar bir formum var buradan yapılan secime göre submit edildiginde gelen degerlere göre veritabanında arama yapıcak..


form

PHP Code:

<form name="sablonForm" method="POST" action="default.ASP?pg=detayara" onSubmit="return CheckForm();">

<tr>
<td width="187" align="left" bgcolor="#F8F8F8"><b>KATEGORi</b></td>
<td width="355" bgcolor="#F8F8F8" align="left">


<b><font color="#FFFFFF"><%set kategorim=server.createobject("adodb.recordset")
kategorim_sql="select * from kategori where  id="&fRs("kat_kod")
kategorim.open kategorim_sql, db,1,3%></font><%=kategorim("isim")%></b><font color="#FFFFFF">
<input type="hidden" value="<%=kategorim("id")%>" name="mainkat"></td>


</tr>
<tr>
<td width="187" align="left" bgcolor="#F8F8F8"><b>ALT KATEGORi</b></td>
<td width="355" bgcolor="#F8F8F8" align="left">

        <select size="1" name="altkats" style="font-size: 8pt; font-family: Arial; color: #565656">
<%                while not frs.eof %>
            <option value="<%=frs("isim")%>"><%=frs("isim")%></option>
<%
                    frs.movenext
                wend
%>
        </select></td>
</tr>

<tr>
                                    <td colspan="2" bgcolor="#DFE2EC" align="left">
                                        <table  class="menutext" name="motortable" id="table1">
                                        <tr> 
                                          <td>Motor</td>
                                          <td>
                                            <input class="editbox" type="radio" name="motor" value="Al1" onclick="motorgoster();" >

                                            var</td>
                                          <td>
                                            <input class="editbox" type="radio" name="motor" value="Alma1" onclick="motorkapat();" checked>
                                            yok</td>
                                        </tr>
                                      </table>
                                      </td>
                                  </tr>

<tr> 
<td width="187" align="left" bgcolor="#DFE2EC">Motor Gücü</td>
<td width="355" bgcolor="#DFE2EC" align="left">

<select class="editbox" name="motorGucu" disabled size="1">

<option value="0.12">0.12</option>
<option value="0.18">0.18</option>
<option value="0.25">0.25</option>
<option value="0.37">0.37</option>
<option value="0.55">0.55</option>
<option value="0.75">0.75</option>
<option value="1.10">1.1</option>
<option value="1.50">1.5</option>

<option value="2.20">2.2</option>
<option value="3.00">3.0</option>
<option value="4.00">4.0</option>
<option value="5.50">5.5</option>
<option value="7.50">7.5</option>
<option value="11.00">11.0</option>
<option value="15.00">15.0</option>
<option value="18.50">18.5</option>
<option value="22.00">22.0</option>

<option value="30.00">30.0</option>
<option value="37.00">37.0</option>
<option value="45.00">45.0</option>
<option value="55.00">55.0</option>
<option value="75.00">75.0</option>
<option value="90.00">90.0</option>
 </select>&nbsp;kW
                                    
</td>
</tr>

<tr> 
                                    <td align="left" bgcolor="#DFE2EC">Çıkış Devri</td>
                                    <td bgcolor="#DFE2EC" align="left">
        <input class="editbox" type="text" name="cikisDevri" size="5" value="">
                                     &nbsp;d/d +- % 
                                      <input class="editbox" type="text" name="cikisTolerans" size="3" value="10"></td>
                                  </tr>
                                  <tr> 
                                    <td align="left" bgcolor="#DFE2EC">Motor Bağlanti 
                                    Ops.</td>

                                    <td bgcolor="#DFE2EC" align="left"> 
                                    <select class="editbox" name="motorBagOpsiyon" size="1">
                                        <option value="Direkt Akuple" selected >Direkt Akuple</option>                                      
                                        </select> </td>
                                  </tr>
                                  <tr> 
                                    <td align="left" bgcolor="#DFE2EC">Yük Sınıfı</td>

                                    <td bgcolor="#DFE2EC" align="left"> 
                                    <select class="editbox" name="yukSinifi" size="1">
                                        <option value="U" >Düzenli</option>
                                        <option value="M" >Orta Darbeli</option>
                                        <option value="H" >Ağır Darbeli</option>
                                      </select></td>

                                  </tr>
                                  <tr> 
                                    <td align="left" bgcolor="#DFE2EC">Günlük 
                                    Çalışma</td>
                                    <td bgcolor="#DFE2EC" align="left"> 
                                    <select class="editbox" name="calismaSaati" size="1">
                                        <option value="4">4</option>
<option value="8" selected >8</option><option value="16">16</option>

<option value="24">24</option>
                                      </select>&nbsp;saat</td>
                                  </tr>
                                  <tr> 
                                    <td align="left" bgcolor="#DFE2EC">start-stop sayısı</td>
                                    <td bgcolor="#DFE2EC" align="left"> <select class="editbox" name="startStopSayisi">

                                        <option value="0-100" selected >0-100</option><option value="101-200">101-200</option>
<option value="201-300">201-300</option>
<option value="301-400">301-400</option>
<option value="401-600">401-600</option>
<option value="601-800">601-800</option>
<option value="801-1000">801-1000</option>
<option value="1001-1500">1001-1500</option>
                                      </select> saatte</td>

                                  </tr>
                                  <tr> 
                                    <td colspan="2" bgcolor="#DFE2EC" align="left">
                                        <table  class="menutext" name="radyalTable">
                                        <tr> 
                                          <td>Çıkış radyal yük</td>
                                          <td><input class="editbox" type="radio" name="radyalYuk" value="Al" onclick="RadyalGoster();" >

                                            izle</td>
                                          <td>
                                            <input class="editbox" type="radio" name="radyalYuk" value="Alma" onclick="RadyalKapat();">
                                            izleme</td>
                                        </tr>
                                      </table>
                                      </td>
                                  </tr>
                                  <tr> 
                                    <td align="left" bgcolor="#DFE2EC">Bağlantı Tipi</td>

                                    <td bgcolor="#DFE2EC" align="left"> 
                                    <select class="editbox" name="baglantiTipi" disabled size="1">
                                        <option value="Elastik Kaplin" >Elastik 
                                        Kaplin</option>
                                        <option value="Düz Dişli" >Düz 
                                        Dişli</option>
                                        <option value="Zincir Dişli" >Zincir 
                                        Dişli</option>
                                        <option value="Trigger Kayış" >Trigger 
                                        Kayış</option>

                                        <option value="V Kayış" >V 
                                        Kayış</option>
                                        <option value="Gerdirme Kayış" >Gerdirme 
                                        Kayış</option>
                                      </select> </td>
                                  </tr>
                                  <tr> 
                                    <td align="left" bgcolor="#DFE2EC">Bağlantı Çapı</td>

                                    <td bgcolor="#DFE2EC" align="left"><input class="editbox" type="text" name="baglantiCapi" size="5" value="" disabled>&nbsp;mm</td>
                                  </tr>
                                  <tr> 
                                    <td colspan="2" align="left" bgcolor="#DFE2EC">
                                    <input type="submit" value="<%=ara1%>" name="B2" style="font-family: Arial; font-size: 8pt; color: #FFFFFF; border: 1px solid #CCE2EE; background-color: #707DA9; float:right">
                                    </td>
                                  </tr>

                                </form> 


sorguyu beceremedim

nasıl yapmalıyım

aşagıdaki gibi yaptıgımda motorgücüne bakarak seçilen degerdeki ürünleri listeliyor..
ancak 1 den fazla seçenek var ve bir çok ürünün motorgücü aynı fakat degerleri farklı
hatta motorgücü kapalı ise onu önemsemiyecek diger alanlara göre uygun olan verileri listeleyecek..

bana bi çıkış gösterin lütfen artık kusacagım yapamadım...

SORGU

PHP Code:

Set db = server.CreateObject("ADODB.Connection")
db.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("../db/mega_vtdb2006.mdb")
Set rs = server.CreateObject("ADODB.Recordset")

SQL = "SELECT * FROM urun where motorgucu like '%"& motorgucu &"%' " 

rs.Open SQL,db,1,3
if rs.eof then 


[emresumer]

Bir emlak sitesi için aratma yapmak için aşağıdaki kodu kullanmıştım. Genel olarak bu mantık işe yarar

PHP Code:

KirSatt=Request.form("kirsat")
Tur=Request.form("tur")
Ilce=Request.form("ilce")
Fiyat1=Request.form("fiyat1")
Fiyat2=Request.form("fiyat2")
dim kosul
kosul = " where "
if KirSatt <> "" then
kosul = kosul & " KirSat like '" & KirSatt & "' "
end if
if Tur <> "" then
kosul = kosul & " and Tur = " & Tur & " "
end if
if Ilce <> "" then
kosul = kosul & " and Ilce = " & Ilce & " "
end if
if Fiyat1 <> "" then
kosul = kosul & " and Fiyat > " & Fiyat1 & " "
end if
if Fiyat2 <> "" then
kosul = kosul & " and Fiyat < " & Fiyat2 & " "
end if


Set Conn = server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & server.MapPath("veri.mdb")
set RS = server.createobject("adodb.recordset")
RS.open "select * from portfoy" & kosul& "Order by Id" , Conn,1,3 


[akgun]

böyle bir hata aldım

altkats=MRA serisi
cikisdevri=4.6
yuksinifi=U-Düzenli
motorgucu=0.12
baglantiCapi=
baglantitipi=
startStopSayisi=0-100
cikistolerans=10

Microsoft OLE DB Provider for ODBC Drivers hata '80040e14'

[Microsoft][ODBC Microsoft Access Sürücüsü] 'motorgucu like '0.12' and cikisdevri = <br> and yuksinifi = U-Düzenli and startStopSayisi = 0-100' sorgu ifadesi içindeki Sözdizimi hatas&yacute; (eksik i&thorn;leç)

/devamisler/oztekfen_website/www/arama1.ASP, line 99



SORGULAMA SAYFASI

PHP Code:

<style type="text/CSS">
.tdlnav1off {
    BORDER-TOP: #ffffff 1px solid; PADDING-LEFT: 10px; PADDING-BOTTOM: 2px; PADDING-TOP: 2px; BORDER-BOTTOM: #d5dadf 1px solid; BACKGROUND-COLOR: #e6ebf1
}
.tdlnav1on {
    BORDER-TOP: #ffffff 1px solid; PADDING-LEFT: 10px; PADDING-BOTTOM: 2px; CURSOR: pointer; PADDING-TOP: 2px; BORDER-BOTTOM: #d5dadf 1px solid; BACKGROUND-COLOR: #e0e8f2
}
.tdlnav2off {
    BORDER-TOP: #ffffff 1px solid; PADDING-LEFT: 10px; PADDING-BOTTOM: 2px; PADDING-TOP: 2px; BORDER-BOTTOM: #DFDFDF 1px solid; BACKGROUND-COLOR: #EFEFEF
}
.tdlnav2on {
    BORDER-TOP: #ffffff 1px solid; PADDING-LEFT: 10px; PADDING-BOTTOM: 2px; CURSOR: pointer; PADDING-TOP: 2px; BORDER-BOTTOM: #DFDFDF 1px solid; BACKGROUND-COLOR: #E8E8E8
}
</style>

<div align="center">
    <table border="0" cellpadding="0" width="90%" id="table1">
       <tr>
         <td>
         
<!-----<font face="Verdana" color="#707DA9" size="2">Aranan Degerler<br>
</font>--->
         
<% 
  
session.LCID=1055
session.codepage=1254

if session ("dil")="t" then
    sonek=""
else 
    sonek=session ("dil")
end if

baglanticapi=request("baglanticapi")
calismasaati=request("calismasaati")
yuksinifi=request("yuksinifi")
motorgucu=request("motorgucu")
baglantitipi=request("baglantitipi")
cikisdevri=request("cikisdevri")
startStopSayisi=request("startStopSayisi")
baglanticapi=request("baglanticapi")
cikisTolerans=request("cikisTolerans")
yuksinifi = Request.form("yuksinifi")
motorgucu = Request.form("motorgucu")

cikisTolerans=request.querystring("cikisTolerans")
cikisDevri=request.querystring("cikisDevri")&"<br>"
response.write "altkats=" & request("altkats")&"<br>"
response.write "cikisdevri=" & request("cikisdevri")&"<br>"
response.write "yuksinifi=" & request.form("yuksinifi")&"<br>"
response.write "motorgucu=" & request.form("motorgucu")&"<br>"
response.write "baglantiCapi=" & request.form("baglantiCapi")&"<br>"
response.write "baglantitipi=" & request.form("baglantitipi")&"<br>"
response.write "startStopSayisi=" & request.form("startStopSayisi")&"<br>"
response.write "cikistolerans=" & request.form("cikistolerans")&"<br>"

'****************************************** ARAMA KISIMI ********************************************************
'Set db = server.CreateObject("ADODB.Connection")
'db.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("../db/mega_vtdb2006.mdb")
'