PDA

View Full Version : <a href problem... help pls


chris2
10-09-2005, 02:03 PM
my default.asp codes
<%
dosyayolu = Server.MapPath("urunler.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dosyayolu

Set rs=conn.Execute("select*from urunler order by urunID Asc")

dim sayac
sayac = 4
Do until rs.EOF

if sayac= 4 then
Response.Write "<tr>"
sayac = 0
end if
Response.Write "<td>"
Response.Write "<table align=left cellpadding=2 "
Response.Write "cellspacing=0><tbody>"
Response.Write "<tr>"
Response.Write "<td align=center><A HREF=""productDETAIL.asp?urunID=" & rs("urunID") & """><IMG src="&rs("urunRESIM")&" width=130 height=140></A></td>"
Response.write "</tr>"
Response.Write "<tr>"
Response.Write "<td align=center>"&rs("urunADI")&"</td>"
Response.write "</tr>"
Response.Write "<tr>"
Response.Write "<td align=center>"&rs("urunFIYATI")&"</td>"
Response.write "</tr>"
Response.Write "</tbody></table><p>"
Response.Write "</td>"
if sayac= 4 then
Response.Write "</tr>"
end if


rs.MoveNext
sayac = sayac + 1
Loop

rs.Close()
Set rs = nothing
%>

and this is my productDETAIL.asp codes
<%
id = Request.QueryString("urunID")
dosyayolu = Server.MapPath("urunler.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dosyayolu
Set rs = Server.CreateObject("Adodb.Recordset")
sql = "Select * FROM urunler WHERE urunID= '" & id & "' "
%>

default.asp page is working correctly but when i click a product link

http://www.cemoflower.com/asp/productDETAIL.asp?urunID=63

it's loading but the page is empty. No picture no error only blank.

How can i show the choosen products to productDETAIL.asp page ?

Freon22
10-09-2005, 05:47 PM
Your first page looks good, nice job. But when I click one of your picture links, this is the error I get from the loading page.
http://www.cemoflower.com/asp/

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/asp/urunDETAY.asp, line 12
So your trouble is in your recordset, can you show more of your code?