Accessing particular records in a recordset

[catalystunderx]

<table border="1" align="center">
<tr>
<td><strong><font size="1" face="Arial, Helvetica, sans-serif">ORDER NUMBER</font></strong></td>
<td><strong><font size="1" face="Arial, Helvetica, sans-serif">PRODUCT NUMBER</font></strong></td>
<td><strong><font size="1" face="Arial, Helvetica, sans-serif">PRICE</font></strong></td>
<td><strong><font size="1" face="Arial, Helvetica, sans-serif">QUANTITY</font></strong></td>
<td><strong><font size="1" face="Arial, Helvetica, sans-serif">SIZE</font></strong></td>
<td><strong><font size="1" face="Arial, Helvetica, sans-serif">COLOUR</font></strong></td>
</tr>
<% While ((Repeat1__numRows <> 0) AND (NOT rsOrderDetails.EOF)) %>
<tr>
<td><font size="1" face="Arial, Helvetica, sans-serif"><%=(rsOrderDetails.Fields.Item("OrderID").Value)%></font></td>
<td><font size="1" face="Arial, Helvetica, sans-serif"><a href="javascript:OpenProduct()"><%=(rsOrderDetails.Fields.Item("ProductID").Value)%></a></font></td>
<td><font size="1" face="Arial, Helvetica, sans-serif"><%=(rsOrderDetails.Fields.Item("UnitPrice").Value)%></font></td>
<td><font size="1" face="Arial, Helvetica, sans-serif"><%=(rsOrderDetails.Fields.Item("Quantity").Value)%></font></td>
<td><font size="1" face="Arial, Helvetica, sans-serif"><%=(rsOrderDetails.Fields.Item("ProductSize").Value)%></font></td>
<td><font size="1" face="Arial, Helvetica, sans-serif"><%=(rsOrderDetails.Fields.Item("Colour").Value)%></font></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsOrderDetails.MoveNext()
Wend
%>
</table>

i want the user to be able to view the details of each particular record in a pop up window by sending the value of product id via url. but once the repeat region has finished it returns the held value to the first record. how can i change which record in the recordset i am getting my value from?

 

[MatDavies]

you may want to try this in the ASP forum.....


If you can keep your head while those around you are losing theirs, you obviously haven't grasped the seriousness of the situation