create dynamic hyperlink from database field

I would like to create a page of hyperlinks that are constructed from the contents of a database field. When the user clicks the link they are taken to a page that will display all fields from that particular record.

I already have the page structures in place. There are two pages, one with the links and the other to display the record.

I have this so far.

<a href="<%response.write rs.Fields("JobDescName")%>"><%response.write rs.Fields("JobDescName")%></a>

The hyperlink would say something like:
Supervisor - Widget Department.

The page it would go to is
http://..../JobDescription.asp(whatever code is necessary to pull the fields from that record).

Any help would be appreciated.

Thanks,
blodefood

How do you know what page to link to? You could add a url column in your db and store the url there. If JobDescName is a valid url it looks like you code should be ok.

JobDescName is a field in the table. The page is JobDescription.asp