I have a asp page that I did sometime ago that sets a hyperlink onto a database field as follows:

Response.Write "<TR bgcolor='"&bg&"'><TD><a href=""ContractOperator.asp?objOpID=" & oRS("Operator") & """>" & oRS("Operator") & " </a></TD>" _
&"<TD>" & objChassis & "</TD>" _
&"<TD>" & objMake & "</TD>" _
&"<TD>" & objType & "</TD>" _
&"<TD>" & objEngine & "</TD>"

I am in the process of creating new pages and have coded as follows:

<TD width="25%" align="center"><%= oRs("Operator") %></TD>
<TD width="25%" align="center"><%= oRs("REG NO") %></TD>
<TD width="25%" align="center"><%= oRs("Depot Based") %></TD>
<TD width="25%" align="center"><%= oRs("CONT TYPE") %></TD>
<TD width="25%" align="center"><%= oRs("START DATE") %></TD>
<TD width="25%" align="center"><%= oRs("EXPIRY DATE") %></TD>

What I cannot seem to get my head focused on is how to put the hyperlink into the second set of code

I hope that makes sense, its probably simple and I am missing something very easy - hope someone can help

Thanks very much

PP :)

Hii PP!!
i think u r trying do like;
<TD width="25%" align="center">
<a href="ContractOperator.asp?objOpID=<%=oRS("Operato r")%>">
 <%= oRs("Operator") %>
</a></TD>

HOpe this will help you

Cheers :)

vinod

Hi vinod
Thank you very much for the assistance worked very well
Regards
PP