June 21st, 2004, 10:55 AM
|
|
Contributing User
|
|
Join Date: Mar 2004
Posts: 31
Time spent in forums: 1 h 42 m 42 sec
Reputation Power: 5
|
|
Hyperlink asp text
I'm using the below code (which works).
Code:
<%
Dim cnnCourse
Dim strDBPath
Dim recCourse
strDBPath = Server.MapPath("database/source.mdb")
Set cnnCourse = Server.CreateObject("ADODB.Connection")
cnnCourse.Open "driver={Microsoft Access Driver (*.mdb)}; dbq=" & strDBPath & "; PWD=sdfsfsdf"
'cnnCourse.Properties("Jet OLEDB:Database Password") = "d9i65o"
Set recCourse = Server.CreateObject("ADODB.Recordset")
recCourse.ActiveConnection = cnnCourse
recCourse.Source = "SELECT * FROM course_details"
recCourse.CursorType = 2
recCourse.CursorLocation = 2
recCourse.LockType = 3
recCourse.Open()
do
if recCourse.eof = false then
response.write(recCourse.Fields.Item("Course_title").Value) & "<br>"
recCourse.MoveNext()
end if
loop until recCourse.eof = true
recCourse.close
set recCourse = nothing
%>
This code prints all the record names that are contained in the table. I wish to incase the outputed text so it acts as a hyperlink when clicked on. How do i add the href code to the asp??
Thanks for any help
Last edited by axe_man : June 21st, 2004 at 10:58 AM.
Reason: spelling
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
