[zanchi]

HI, I have some problem when I'm trying to access data from 1 page to another using the ProductID.

First Page - This one seems to be OK

<a href="mobilephonesdetails.asp?Productid=<%= rs.Fields("ProductID").Value %>"><%= rs.Fields("Model").Value %>

I want that the previous link for example mobilephonesdetails.asp?ProductID=2

will be displayed to another page. I already have the following code:

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("technocom.mdb"))
 
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT ProductID, Logo, Model, Image1, Brand FROM Products WHERE productID=[COLOR="DarkOrange"]2[/COLOR]", conn
%>
  
</p>
<table border="0" cellpadding="10" cellspacing="10"> 
 
<tr>
  <td width="151"><img src="<%= rs.Fields("Image1").Value %>" width="139" height="184"></td>
  <td width="152">&nbsp;</td>
  </tr> 
</table> 
<% 
' Close our recordset and connection and dispose of the objects 
rs.Close 
set rs = Nothing 
conn.Close 
set conn = Nothing 
%> 

maybe im missing something but im not exactly sure what the problem that you are trying to resolve??

[blake]

I'm not sure if I understand...

I think you're looking for a way to pass a query string on to another page, right?

Page 1:

<a href="file.asp?id=<%=someAspVariable%>">Go to Page 2</a>

Page 2:

<%
dim inID
inID = request.querystring("id")

if inID = "" then
'nothing was entered
else
'received a querystring
response.write(inID) 'this writes out the ID in 'someAspVariable' from page1
end if
%>

Hope this helped... If not, please explain again what you're looking for...

[zanchi]

Yes that helped a little bit but now I need something that display data from the database with that productID chosen from previous page.

Thanks

[Yeroon]

Pass the ID of the previous page in the querystring too:


Page 1:

<a href="file.asp?id=<%=someAspVariable%>&previouspag e=<%=CurrentProductID%>">Go to Page 2</a>

Page 2:

<%
dim inID, prevID
inID = request.querystring("id")
prevID = request.querystring("previouspage")
if inID = "" then
'nothing was entered
else
'received a querystring
<a href="file.asp?id=<%=prevID%>">Go Back to Page 1</a>
end if
%>