Creating Links based on dataset returns

[karlmcauley]

Hello,

Basically i am trying to create a url from a set of data returned from a sql query displayed on a web page.

For example, the first query returns college courses by college teams. This info is displayed in a table. Now if i wanted to create a link based on each course code so that when the data is returned in the first query all course codes will be links to another page which enables the user to "drill-down" to student level and see all students on a particular course code.

Some code already:

dim theUrl
theUrl="course_drill_down.asp?Course=" & rsTemp("UICode")

<td align="center" valign=middle> <div align="center"><font size="1" face="Arial, Helvetica, sans-serif">
<a href=<%response.write theUrl%>><% = rsTemp("UICode") %></a></font></div></td>

This does not work as no course code is a link to the new page. Any suggestions??

[magus]

I usually using this code

<td align="center" valign=middle> <div align="center"><font size="1" face="Arial, Helvetica, sans-serif">
<a href="course_drill_down.asp?Course=<%= rsTemp("UICode") %>" ><%= rsTemp("UICode") %></a></font></div></td>

and hope this working as long as course_drill_down.asp exists