CodingForums.com

CodingForums.com (http://www.codingforums.com/index.php)
-   ASP.NET (http://www.codingforums.com/forumdisplay.php?f=40)
-   -   <a href problem... help pls (http://www.codingforums.com/showthread.php?t=69857)

chris2 10-09-2005 01:04 PM

<a href problem... help pls
 
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/produc....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 ?

Cipher 10-09-2005 01:51 PM

if the ID Column DataType is Integer, do not use single quote '', make it like this:
sql = "Select * FROM urunler WHERE urunID= " & id & " "


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.