this one is for SQL
vrecordsi.asp?row=<%=(serverinfo.Fields.Item("ID") .Value)%>
this one is for PHP
vrecordplyr.php?Row=<?php echo $row_lname_search['ID']; ?>

what is the command for ACCESS DB??

have some colums on a page =
view Record,server name, ip, model, serial

when i hit view record (show me more details of the server), i want it to open a new page (I have this working) and show me the complete details of that server record, I have the view record working, but it only shows me the first record's details no matter what view record(different servers) i click on....


%>
<tr>
<td width="1%"></td>
<td width="15%"><font color="#000000"><a href="vrecordsi.asp?row=<%=(serverinfo.Fields.Item ("ID").Value)%>">View Record</a></font></td>
<td width="20%"><font color="#000000"><%=(serverinfo.Fields.Item("Server _Name").Value)%></font></td>
<td width="15%"><font color="#000000"><%=(serverinfo.Fields.Item("Domain ").Value)%></font></td>
<td width="15%"><font color="#000000"><%=(serverinfo.Fields.Item("Locati on").Value)%></font></td>
<td width="14%"><font color="#000000"><%=(serverinfo.Fields.Item("IP").V alue)%></font></td>
<td width="18%"><%=(serverinfo.Fields.Item("Function") .Value)%></td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
serverinfo.MoveNext()
Wend
%>

just the same depending on if you are running PHP or ASP with Access

I have the view record working, but it only shows me the first record's details no matter what view record(different servers) i click on....

Well, if you pass a record ID and extract records for that, there will be only one record.

chrishist

understood..

i'm trying to figure out the code to pass each record and not just the first record...?

you don't pass any id to the query to show all records. the query to extract the records then has no WHERE clause.