Something like this should work: SQL_query = "SELECT * FROM tablename" RS.Open SQL_query, conn, 3 <a target=_new HREF='<%=RS("URL")%>'><%=RS("name")%></A>
Forum Rules