hyperlink

pab006 · December 8th, 2003, 09:19 AM

Ive created a search option that allows a user to search for specific records, and have displayed the search results in a table. Each record has a unique number. How do i make this table, so that a user can click on the record number, and be displayed with further information stored about this record, Like a hyperlink

many thanks

planoie · December 8th, 2003, 01:44 PM

You need to write out a hyperlink tag with the record ID in the querystring of the URL and create a page that will show more detail:

<a href="recordDetail.asp?recordID=<%=recordset("reco rdIDField")%>">Click for more detail</a>

Peter
------------------------------------------------------
Work smarter, not harder.

pab006 · December 10th, 2003, 05:22 AM

thank you

schaar · December 17th, 2003, 09:39 AM

im also trying to figure this out (yeah im new!), so what would the detail page look like. cos mine isnt working. i dont understand the WHERE bit i think.

here's my code for my hyperlinks:

Code:

<a href="filmsdetail.asp?MovieID=<%=objRS("MovieID")%>"><%=objRS("Title")%> (<%=objRS("Jaar")%>)</a><br>

and then i have my detail page looking like this:
(this part isnt working yet)

Code:

<%
DIM mySQL, objRS
mySQL = "SELECT * FROM Movies WHERE MovieID=" &MovieID& "" 
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.CursorType = 1
objRS.Open mySQL, objConn

%>

<P><%=objRS("Title")%> (<%=objRS("Jaar")%>)<br><br>

can anyone advise?

stu9820 · December 17th, 2003, 10:30 AM

You want to pull the movieID out of the URL QueryString.

You need to add this: Request.QueryString("MovieID")

Dim myNewVariable
myNewVariable = Request.QueryString("MovieID")
'Response.write(myNewVariable) ' for testing

<%
DIM mySQL, objRS
mySQL = "SELECT * FROM Movies WHERE MovieID=" & myNewVariable & ""
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.CursorType = 1
objRS.Open mySQL, objConn

%>

schaar · December 17th, 2003, 10:33 AM

thanx. its working!!
brilliant :D