Selelect distinct
Hvorfor går det galt når jeg prøver at udskrive et felt min min DB, der ikke er brugt i SQL'en???Min kode er:
<HTML>
<HEAD>
<TITLE>Services - MEDIALOG A/S</TITLE>
<style>
<!--
A:link {color:#00000; }
A:vlink {color:#00000; }
A:hover {color:#909090; }
A:link {text-decoration:none}
A:visited {text-decoration:none}
-->
</style>
</HEAD>
<BODY BGCOLOR="#FFFFFF" link="#000000" vlink="#000000" alink="#000000" text="#000000" background="../pics/headers/back_line.JPG">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="450" colspan="3" height="30"> </td>
</tr>
<tr>
<td width="50"> </td>
<td width="400">
<table width="470" border="0" cellspacing="0" cellpadding="0" align="left">
<tr>
<td><font face="Verdana, Arial, Helvetica, sans-serif" size="1">
</font></td>
</tr>
<tr>
<td>
<p> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><font size="2" face="Arial, Helvetica, sans-serif" color="#666666"><img src="../Assets/Images/Headers/pixel.gif" width="10" height="20"><img src="../Assets/Images/Headers/search.gif" height="20" ></font></font><font size="2" face="Arial, Helvetica, sans-serif" color="#666666"><img src="../Assets/Images/Headers/pixel.gif" width="152" height="20"></font><img src="../Assets/Images/Headers/right.gif" width="13" height="20"></font>
<blockquote>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2" ><%
Const adOpenKeySet = 1
Const adLockReadOnly = 1
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "Select DISTINCT DOCUMENT From WINDEX Where WORD Like '%" & Request.Querystring("SEARCH") & "%' OR TITLE Like '%" & Request.Querystring("SEARCH") & "%'"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("contents.mdb")
rs.Open strSQL, strDSN, adOpenKeySet, adLockReadOnly %>
<% If RS.EOF and RS.BOF then %>
<br><br><br><br><font color="#000000"> Your search for <b>"<% =Request.Querystring("SEARCH")%>"</b> didn't return any results.</font>
<% else %>
<%
If Not (rs.BOF Or rs.EOF) Then
rs.PageSize = 5
rs.AbsolutePage = intPage
intRecCount = rs.PageSize
intPageCount = rs.PageCount
Response.Write "<p>Page " & intPage & " of " & intPageCount & "</p>"
Response.Write "<p>Your search returned " & rs.Recordcount & " results</p><b>"
Do While Not rs.EOF And intRecCount > 0 %><img src="../Assets/Images/Headers/pixel.gif" width="3" height="3" align="absmiddle"> <a href="../pages/<%= rs("DOCUMENT")%>"><%= rs("TITLE") %></a>
<br><br>
<%
intRecCount = intRecCount - 1
rs.MoveNext
Loop
End If
rs.Close
Set rs = Nothing
%>
</b>
<%
Response.Write "<p>Go to page: <br><font size=""1"">"
For intNum = 1 To intPageCount
%>
<a href="paging.asp?search=<% =Request.Querystring("SEARCH")%>&page=<% =intNum %>"><% =intNum %>    </a></b>
<% Next
Response.Write "<p>"
If intPage > 1 Then %>
<a href="paging.asp?search=<% =Request.Querystring("SEARCH")%>&page=<% =intPage - 1 %>"><< Previous </a>
<%
Else
Response.Write "<< Previous "
End If
Response.Write " "
If intRecCount = 0 And intPage > 0 Then
%>
<a href="paging.asp?search=<% =Request.Querystring("SEARCH")%>&page=<% =intPage + 1 %>"> Next >></a>
<%
Else
Response.Write " Next >>"
End If
End If
%>
</blockquote>
</td>
</tr>
</table>
</td>
<td> </td>
</tr>
</table>
<table width="400" cellpadding="0" cellspacing="0" border="0">
<tr>
<td colspan="4" valign="bottom" height="30"> </td>
</tr>
<tr align="left">
<td colspan="4" valign="bottom" height="30">
<p>
<center>
<p align="left"> <font size="1" face="Arial, Geneva">Copyright ©
1999 <a href="mailto:mail@medialog.dk"
target="_parent">Medialog A/S</a> </font>
</center>
</td>
</tr>
</table>
<p> </p>
</BODY>
</HTML>
Men den virker kun når det jeg "DISTINCTER" på er det samme som det jeg vil skrive ud.
Ovenstående ville alstå kun virke hvis jeg skrev:
;<a href="../pages/<%= rs("DOCUMENT")%>"><%= rs("DOCUMENT") %></a>
