ASP中，如何从数据库中找到数据并且以链接形式显示在屏幕上？

Set rs = Server.CreateObject("Adodb.RecordSet")
sql = "SELECT EFGH FROM ABCD"
rs.open sql, conn, 1, 1
do while not rs.not
response.write "<a href=""#"">" & rs(0) & "</a>"
rs.movenext
loop
rs.close
rs = null