ASP id sorunu

yozgatlı · 19 Temmuz 2006

PHP:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta content="Araba, oto, haber, arabam, ikinci el, 2.el, otomobil, araç, haberler, haber, otomotiv, fiyat, haber, bilgi, kullanilmis, 0km, fiyatlari, test sürüsü, alim, satim, otomobil kredisi, otomobil sigortasi, marka, model, model yili, satilik, ilan, sahibinden, galeri, galericiler, ücretsiz, bedava, Audi, mercedes, bmw, opel, ferrari, alfa romeo, amc, anadol, aston martin, bmc, cadillack, modifiye, tuning, klasik, clasik, clasic, otomobil, araba, araç, ticari araç, is makinesi, ziraii, daewoo, daf, kamyon, tir, otobüs, gaz, gmc, hummer, huyundai, hyundai, hunday, reno, mazda, mitsubishi, susuki, kawasaki, kavasaki, kavazaki, japon, yerli, yabanci, american, amerikan, volvo, vw, wv, wolkswagen, volkswagen, toyota, tofas, fiat, fiyat, tata, dizel turbo, süper, benzinli, subaru, porsche, porsh, nissan, maserati, lexus, lada, kia, dacia, infiniti, pihinifarina, citroen, sitroen, oldsmobile, formula1, f1, grand prix" name="keywords">
<title>:::::::::: TÜRKIYE' nin En Büyük Bölgesel Otomobil Pazari www.cukurovaotopazari.com 
::::::::::</title>
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif}
.style2 {font-size: 9px}
.style3 {font-size: 11px}
.style6 {font-size: 10px}
.style7 {
	font-size: 14px;
	font-weight: bold;
}
.style8 {font-size: 12px; font-weight: bold; }
.style9 {font-family: Arial, Helvetica, sans-serif; font-size: 9px; }
.style36 {font-size: 12px}
.style45 {font-size: 10px; font-weight: bold; }
.style50 {font-size: 11px; font-weight: bold; }
.style63 {
	font-size: 12;
	font-weight: bold;
}
.style64 {
	font-size: 12px;
	font-weight: bold;
	font-family: Arial, Helvetica, sans-serif;
	color: #000000;
}
.style68 {font-weight: bold}
.style69 {font-weight: bold}
.style70 {
	font-size: 12px;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-weight: bold;
}
.style74 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; }
-->
</style>
</head>

<body>
<%
Set ObjCon_ilet = Server.CreateObject("ADODB.Connection")
ObjCon_ilet.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/veritabanim.mdb")


Set ObjRs = Server.CreateObject("ADODB.Recordset")
StrSql = "Select * from kelimeler"
ObjRs.Open StrSql, ObjCon_ilet, 1, 3
%>

<table width="956" height="1434" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="19" colspan="3" class="style1">
    <!--#include file="basinc.asp" --></td>
  </tr>
  <tr>
    <td width="204" align="center" valign="top" bgcolor="#F7F9FD" class="style1">
    <!--#include file="otoinc.asp"--></td>
    <td width="539" height="1381" align="center" valign="top" bgcolor="#F7F9FD" class="style1">
    <a href="uyeler.asp"></a>
    <table width="543" height="68" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="18" align="center" valign="top" width="24">
        <img src="eleman/soltit.gif" width="24" height="24" /></td>
        <td height="18" colspan="4" align="center" background="eleman/tit01.gif" width="467">
        <div align="center">
          <strong>ARACIN MARKASI </strong>
        </div>
        </td>
        <td width="25" align="center" valign="top">
        <img src="eleman/sagtit.gif" width="24" height="24" /></td>
      </tr>
      <tr>
        <td width="24" height="20" align="center" valign="top" background="eleman/solbar.gif" rowspan="25"> </td>
        <td align="center" rowspan="25" valign="top" width="214">
        <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="538%" id="AutoNumber1" height="95">
          <tr>
            <td width="100%" height="95"> </td>
          </tr>
        </table>
        </td>
        <td align="left" colspan="3" width="280">
        Satıcı Bilgileri</td>
        <td width="25" align="center" valign="top" background="eleman/sagbar.gif" rowspan="25"> </td>
      </tr>
      <tr>
        <td align="left" width="128">
        Satıcı</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("satici")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        GSM</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("gsm")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Telefon</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("tel")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        E-mail</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("email")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        İl</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("il")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Adresi</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("adres")%></td>
      </tr>
      <tr>
        <td align="left" colspan="3" width="280">
        Araç Bilgileri</td>
      </tr>
      <tr>
        <td align="left" width="128">
        Kategori</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("katagori")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Marka</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("marka")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Model</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("model")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Model Uzantısı</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("modeluz")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Model Yılı</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("modelyili")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Yakit Tipi</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("yakittip")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Vites Tipi</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("vitestip")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Kasa Tipi</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("kasatip")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Renk</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("renk")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Kilometre</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("km")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Motor Hacmi (cc)</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("hacim")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Beygir Gücü (hp)</td>
        <td align="left" width="152" colspan="2">
         <%=ObjRs("guc")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Plaka</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("plaka")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Sahip Sayısı</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("sahip")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        Fiyat</td>
        <td align="left" width="79">
         <%=ObjRs("fiyat")%></td>
        <td align="left" width="73">
         <%=ObjRs("birim")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        İlan Tarihi</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("tarih")%></td>
      </tr>
      <tr>
        <td align="left" width="128">
        EK</td>
        <td colspan="2" align="left" width="152">
         <%=ObjRs("ek")%></td>
      </tr>
      <tr>
        <td height="24" align="center" valign="top" width="24">
        <img src="eleman/altssoltit.gif" width="24" height="24" /></td>
        <td colspan="4" align="center" valign="top" background="eleman/tit01.gif" width="467"> </td>
        <td height="24" align="center" valign="top" width="25">
        <img src="eleman/altsagtit.gif" width="24" height="24" /></td>
      </tr>
    </table>
   
    <p> </p>
    <p> </p>
    <p> </p>
    </td>
    <td width="221" height="1381" align="center" valign="top" bgcolor="#F7F9FD" class="style1">
    <table width="174" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="174" colspan="3" align="center" bgcolor="#F7F9FD">
        <!--#include file="rekinc.asp"--></td>
      </tr>
    </table>
    </td>
  </tr>
</table>
<!--#include file="altinc.asp"-->

</body>

</html>

veritabanından veri çekmek için "sahis.asp?kelime_id=53 - 54 - 55" şeklinde giriyorun ama hangi id numarasını yazarsam yazayım herzaman veritabanının ilk satırındaki verileri veriyor.Kodlar yukarıdadır. Nerde hata yapıyorum. Teşekkür ederim

trextra · 19 Temmuz 2006

<%
Set ObjCon_ilet = Server.CreateObject("ADODB.Connection")
ObjCon_ilet.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/veritabanim.mdb")

Set ObjRs = Server.CreateObject("ADODB.Recordset")
StrSql = "Select * from kelimeler"
ObjRs.Open StrSql, ObjCon_ilet, 1, 3
%>

Bu kodda herhangi biryerde id ile işlem yaptırmıyorsun. Doğal olarak en üstteki kayıtı çıkartırıyor. Kelime ID alanının ID diye kayıtlı olduğunu varsayıyorum. Şunu deneyebilirsin.

<%
Set ObjCon_ilet = Server.CreateObject("ADODB.Connection")
ObjCon_ilet.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/veritabanim.mdb")

Kelime_ID = Request.QueryString("kelime_id")

Set ObjRs = Server.CreateObject("ADODB.Recordset")
StrSql = "Select * from kelimeler Where ID = " & Kelime_ID
ObjRs.Open StrSql, ObjCon_ilet, 1, 3
%>

yozgatlı · 19 Temmuz 2006

PHP:

<!--#include file="ayarlar.asp"-->
<meta http-equiv="Content-Language" content="tr">
<link rel="stylesheet" href="includes/Style.css" type="text/css">
<style type="text/css">
<!--
.style1 {color: #000000}
.style3 {
	color: #000000;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-weight: bold;
}
.style4 {
	color: #000000;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
}
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; }
.style11 {color: #000000; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; }
-->
</style>
<body bgcolor="">
<center> </center>
<br>
<br>
<center>
<%
'Az önce kutucuğa yazılan yazıyı aldık.Hayrını Görek:)
marka = request("marka")
model = request("model")

'Kelime Yazılmamışsa Verilecek Uyarıyı Belirledik
if marka ="" or model ="" then
	Response.Write "<img src=eleman/uyar.gif border=0><br><br>"
	Response.Write "<b>Lütfen Boş Alan Bırakmayınız!<b><br><br>"
	Response.Write "<INPUT class=""buton"" TYPE=""button"" VALUE=""  << Geri  "" onClick=""history.go(-1)"">"
Else
'Veritabanı Bağlantısını Kurduk
Set BagMotor = Server.CreateObject("ADODB.Connection")
BagMotor.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(""&dbfolder&"")

'Hadi Kayıt Setimizi Oluşturalım
Set HanimisAranan = Server.CreateObject("ADODB.RecordSet")
SQL = "select * from kelimeler where marka like '%" & marka & "%' and model like '%" & model & "%' "
HanimisAranan.Open SQL,bagMotor,1,3

'Toplam Kayıt Sayısını Bulduk
Toplam_sonuc = HanimisAranan.RecordCount
%>
<center>
<table border="0" width="530" height="24" style="border-collapse: collapse" cellpadding="0" cellspacing="0">
  <tr>
  <td height="24" width="24"><span class="style1"><img src="eleman/soltit.gif" width="24" height="24"></span></td>
  <td width="651" height="24" background="eleman/tit01.gif"><div align="left"><span class="style3">Toplam 
    Sonuç Sayısı : <%=Toplam_sonuc%></span></div></td>
  <td height="24" width="24"><span class="style1"><img src="eleman/sagtit.gif" width="24" height="24"></span></td>
</tr></table>
</center>
<%
if HanimisAranan.Eof Then
	Response.Write "<img src=eleman/uyar.gif border=0><br><br>"
	Response.Write "<b>Aradığınız Kelimeye Uygun Sonuç Bulunamadı!<b><br><br>"
	Response.Write "<INPUT class=""buton"" TYPE=""button"" VALUE=""  << Geri  "" onClick=""history.go(-1)"">"
Else
%>
<br><br><center>
<table border="0" width="530" height="56" style="border-collapse: collapse" cellpadding="0" cellspacing="0">
<tr>
  <td width="25" height="12"><span class="style1"><img src="eleman/soltit.gif" width="24" height="24"></span></td>
  <td height="12" align="center" background="eleman/tit01.gif"><p align="left" class="style4">Marka</td>
  <td height="12" align="center" background="eleman/tit01.gif"><div align="left" class="style6"><span class="style1"> Model</span></div></td>
  <td align="center" background="eleman/tit01.gif"><div align="left" class="style6"><span class="style1"> Model Uz.</span></div></td>
  <td height="12" align="center" background="eleman/tit01.gif"><div align="left" class="style6">
      <div align="left"><span class="style1"> Yılı </span></div>
  </div></td>
  <td height="12" align="center" background="eleman/tit01.gif"><div align="left" class="style6"><span class="style1"> Renk</span></div></td>
  <td width="51" height="12" align="center" background="eleman/tit01.gif"><div align="left" class="style6"><span class="style1">İl</span></div></td>
  <td height="12" align="center" background="eleman/tit01.gif"><div align="left" class="style6"><span class="style1"> Fiyat</span></div></td>
  <td height="12" align="center" background="eleman/tit01.gif"><div align="left" class="style6"><span class="style1"> Fot.</span></div></td>
  <td width="66" height="12" align="center" background="eleman/tit01.gif"><div align="left" class="style6">
      <div align="center"><span class="style1"> Detay</span></div>
  </div></td>
  <td width="25" height="12"><span class="style1"><img src="eleman/sagtit.gif" width="24" height="24"></span></td>
</tr>
 <%
 'Simdi Sayfalatma Özelliği Koyuyoruz
 git = Request.QueryString("git")
			if git="" then 
			git = 1
			end if
			HanimisAranan.pagesize = 10
			HanimisAranan.absolutepage = git
			sayfa = HanimisAranan.pagecount
			for i=1 to HanimisAranan.pagesize
			if HanimisAranan.eof then exit for%>
 <tr>
  <td width="25" background="eleman/solbar.gif"><span class="style1"></span><span class="style1"></span><span class="style1"></span></td>
  <td height="1" width="71" align="center"><div align="left"><span class="style4"><%=HanimisAranan("marka")%> </span></div></td>
  <td width="52" height="1" align="center"><div align="left"><span class="style4"> <%=Left(HanimisAranan("model"),25)%></span></div></td>
  <td width="78" height="1" align="center"><div align="left"><span class="style4"><%=HanimisAranan("modeluz")%> </span></div></td>
  <td height="1" width="31" align="center"><div align="left"><span class="style4"><%=HanimisAranan("modelyili")%> </span></div></td>
  <td height="1" width="51" align="center"><div align="left"><span class="style4"><%=HanimisAranan("renk")%> </span></div></td>
  <td height="1" align="center"><div align="left"><span class="style4"><%=HanimisAranan("il")%> </span></div></td>
  <td height="1" width="59" align="center"><div align="left"><span class="style4"><%=HanimisAranan("fiyat")%> </span></div></td>
  <td height="1" width="21" align="center"><div align="center"><span class="style4"><%=HanimisAranan("fot")%> </span></div></td>
  <td height="1" align="center"><div align="center"><span class="style6"><span class="style1"> <a target="blank" title="<%=HanimisAranan("detay")%>" href="<%=HanimisAranan("link")%>"><%=HanimisAranan("detay")%></span></div></td>
  <td width="25" background="eleman/sagbar.gif"><span class="style1"></span><span class="style1"></span></td>
  </tr>
 <%
 HanimisAranan.MoveNext
 next
 %>
 <tr>
   <td width="25" background="eleman/solbar.gif"> </td>
  <td height="19" colspan="9"><div align="left"><span class="style11">Bulunan sayfa sayısı :
    <%
        for y=1 to sayfa 
		if git=y then
		response.write y
		else
		response.write "<b> <a href=""arabul.asp?git="&y&"&marka="&marka&""">"&y&"</a></b>"
		End if
		next
		%>
  </span></div></td>
  <td width="25" background="eleman/sagbar.gif"> </td>
 </tr>
 <tr>
   <td width="25" height="24"><img src="eleman/altssoltit.gif" width="24" height="24"></td>
   <td height="24" background="eleman/tit01.gif" colspan="9"> </td>
   <td width="25" height="24"><img src="eleman/altsagtit.gif" width="24" height="24"></td>
 </tr>
</table>
</center>

<%
end if
end if%></center>

kullandığımız iki asp dosyası var diğeride bu. sizin kodu girdik hata olarak

PHP:

Hata Tipi:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Sürücüsü] Çok az parametre. 1 bekleniyor.
/sahis.asp, line 55

trextra · 19 Temmuz 2006

Sizdeki ID alanı farklı olabilir. Tablodaki ID alanının ismini yazarsan buraya yardım edebiliriz.

yozgatlı · 19 Temmuz 2006

tablomuz bu

trextra · 19 Temmuz 2006

verdiğim kodda hiçbir değişiklik yapmadanmı eklediniz ?

yozgatlı · 19 Temmuz 2006

dediginiz gibi yaptık ama öyle hata verdi ben buraya eklenti olarak versem bakabilirmisiniz zaten 3 sayfadan oluşuyor.

trextra · 19 Temmuz 2006

Yok ben kelime_id yazan alanın ID olduğunu varsayarak yazmıştım onu. Şunu deneyin.

<%
Set ObjCon_ilet = Server.CreateObject("ADODB.Connection")
ObjCon_ilet.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/veritabanim.mdb")

Kelime_ID = Request.QueryString("kelime_id")

Set ObjRs = Server.CreateObject("ADODB.Recordset")
StrSql = "Select * from kelimeler Where kelime_id = " & Kelime_ID
ObjRs.Open StrSql, ObjCon_ilet, 1, 3
%>

yozgatlı · 19 Temmuz 2006

Çok teşekkür ediyorum. Sorunsuz çalışıyor.

trextra · 19 Temmuz 2006

Rica ederim. Kolay gelsin.

ASP id sorunu

0

0

0

0

0

0

0

0

0

0

Backlink ve Tanıtım Yazısı için iletişime geçmek için Skype Adresimiz: .cid.1580508955483fe5