<i><b>Originally posted by : wasissn (wasissn@hotmail.com)</b></i><br /><br />Hi there. i have a database with authors, titles and topics. if someone choses a title from the start-up page, he gets every detailed information outta database about this title, row by row and with an information head row. works perfect! now i wanna display the main topics of the chosen title: wherever my database has a "1" instead of <Null>, the head row name of my databases main topics should be displayed. How can i filter these informations within my asp-code that only calls some simple data by ID?<br />To avoid several questions for a better understanding i already post my code so far of the "window.asp" site:<br /><br /><%@ LANGUAGE="VBSCRIPT" %><br /><% <br />Option Explicit<br /><br />Dim objConn <br />Dim objRS<br /> <br />Dim strSQL <br />Dim strConnection <br />Dim i <br /><br /><br /><br /><br />Dim strID<br />strID = Request.QueryString ("ID")<br /><br />Set objConn = Server.CreateObject("ADODB.Connection")<br />Set objRS = Server.CreateObject("ADODB.Recordset")<br /><br /><br /><br />strConnection = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("VirtualLibrary.mdb")<br /><br />objConn.Open strConnection<br /><br /><br />strSQL = "SELECT * FROM TEXTE WHERE ID = "&strID<br /><br />set objRS = objConn.Execute (strSQL)<br /><br /><br />if (objRS.BOF and objRS.EOF) then<br /> response.write "No records found"<br /> response.end<br />End if<br />%><br /><br /><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><br /><br /><HTML><br /><HEAD><br /> <TITLE>Window</TITLE><br /></HEAD><br /><BODY><br /><br /><style TYPE="text/css"><br /> A:hover {COLOR: #ff0000 ;}<br /> body,td {font-family: Arial, helvetica, sans-serif;font-size:10pt; font-weight:bold;}<br /> .NavigationOben {font-size:9pt;}<br /> .NavigationObenLink {color:"#003366"; font-weight:bold;}<br /> h3 {color:"#003366";}<br /> a {text-decoration:none; font-weight:bold; color:"#003366";font-size:10pt;}<br /> .NavigationOver {CURSOR: hand}<br /> p,li,ul {font-size:10pt;}<br /> </style><br /><br /></head><br /><script><br />focus()<br /></script><br /><%<br /><br /><br /> <br /> objRS.MoveFirst<br /> Do While Not objRS.EOF<br />%><br /><br /><br /><body bgcolor="#FFFFFF" link="#003366" vlink="#003366" alink="#003366"><br /><table border="0" cellspacing="2" cellpadding="3" width="384"><br /><br /><tr><br /><td valign="middle" align="left" background="window.gif"><br /><font color="#003366">Institution</font><br /></td></tr><br /><br /> <TR><br /> <TD><% =objRS("Institution") %></TD></TR><br /> <TR><br /> <td width="15"><br></TD></TR><br /> <br /><tr><br /><td valign="top" align="left"><br /> <br /><p> </p><br /></td></tr><br /><br /><tr><br /><td valign="middle" align="left" background="window.gif"><br /><font color="#003366">Author</font><br /></td></tr><br /><br /> <TR><br /> <TD><% =objRS("Autor") %></TD></TR><br /> <TR><br /> <td width="15"><br></td></TR><br /><br /><tr><br /><td valign="top" align="left"><br /> <br /><p> </p><br /></td></tr><br /><br /><tr><br /><td valign="middle" align="left" background="window.gif"><br /><font color="#003366">Title</font><br /></td></tr><br /><br /> <TR><br /> <TD><% =objRS("Titel") %></TD></TR><br /> <TR><br /> <td width="15"><br></td></TR><br /> <br /><tr><br /><td valign="top" align="left"><br /> <br /><p> </p><br /></td></tr><br /><br /><tr><br /><td valign="middle" align="left" background="window.gif"><br /><font color="#003366">URL</font><br /></td></tr><br /><br /> <TR><br /> <TD><a href = "<% =objRS("URL")%>"><% =objRS("URL")%></a></TR><br /> <TR><br /> <td width="15"><br></td></TR><br /> <br /><tr><br /><td valign="top" align="left"><br /> <br /><p> </p><br /></td></tr><br /><br /><tr><br /><td valign="middle" align="left" background="window.gif"><br /><font color="#003366">FileName</font><br /></td></tr><br /><br /> <TR><br /> <TD><% =objRS("Dateiname") %></TD></TR><br /> <TR><br /> <td width="15"><br></td></TR><br /> <br /><tr><br /><td valign="top" align="left"><br /> <br /><p> </p><br /></td></tr><br /><br /><tr><br /><td valign="middle" align="left" background="window.gif"><br /><font color="#003366">Abstract</font><br /></td></tr><br /><br /> <TR><br /> <TD><% =objRS("abstract") %></TD></TR><br /> <TR><br /> <td width="15"><br></td></TR><br /> <br /><tr><br /><td valign="top" align="left"><br /> <br /><p> </p><br /></td></tr><br /><br /><tr><br /><td valign="middle" align="left" background="window.gif"><br /><font color="#003366">Year</font><br /></td></tr><br /><br /> <TR><br /> <TD><% =objRS("Jahr") %></TD></TR><br /> <TR><br /> <td width="15"><br></td></TR><br /> <br /><tr><br /><td valign="top" align="left"><br /> <br /><p> </p><br /></td></tr><br /><br /><TR><br /><td valign="middle" align="left" background="window.gif"><br /><font color="#003366">Main Topics</font><br /></td></TR><br /><br /><br />*************************************************<br />IS IT POSSIBLE TO INCLUDE THE CODE HERE? AND WHICH?<br />*************************************************<br /><br /><br /><br /><tr><br /><td valign="top" align="left"><br /> <br /><p> </p><br /></td></tr><br /><br /> <br /><%<br /> <br /> objRS.MoveNext<br /> Loop<br /><br /> objRS.Close<br /> set objRS = Nothing<br /> objConn.Close<br /> set objConn = Nothing<br /> <br /><br /><br /> <br />%><br /></TABLE><br /><br /><br /></BODY><br /></HTML><br /><br /><br /><br /><br />Thank you very much for every answer!