Hi I am a university student and am having some major problems with asp and sql for my final year project I have 3 weeks to finish it and am very stuck.

does anyone know how to write the code to call a hyper link from a database this may seem pretty simple to some but its like brain surgery to me if anyone can help me I would be very greatful

thanks

carl

response.write "<a href=" & chr(34) & "url" & chr(34) & ">Anchor text</a>"

or did you mean something else ???

well, assuming you are using ADO, here's an example to pull links and link text from a table containing links. we'll call it the [links_table], and we'll order the results in ABC order ascending

<%
 on error resume next
 
 dim conn, rs
 set conn = server.createobject("adodb.connection")
 
 if err.number <> 0 then
   ' error while opening connection, redirect to error.asp and display message
   set conn = nothing
   response.redirect "error.asp?error="& escape(err.description)
 end if
 
 conn.cursorLocation = 3   ' so we have access to connection.recordCount
 conn.open dsnConnection
 
 set rs = conn.execute("SELECT link_text, url FROM links_table ORDER BY link_text ASC")
 do while not rs.eof
   response.write "<a href="""& rs("url") &""">"& rs("link_text") &"</a><br>"
   rs.moveNext
 loop
 
 conn.close
 set conn = nothing
 set rs = nothing
%>