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:
<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)
DIM mySQL, objRS
mySQL = "SELECT * FROM Movies WHERE MovieID=" &MovieID& ""
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.CursorType = 1
objRS.Open mySQL, objConn
can anyone advise?