Søgning i DB
Er der en som kan hjælpe mig med at få dette til at virke ??<% if soeg = "Søgning" then %>
<table width="95%" cellspacing="0" cellpadding="0" bordercolor="black" bgcolor="white" style=" border: 1 solid;">
<tr>
<td color="black" bgcolor="black"><font color="white" size="2" face="verdana"><b>Source-Type: <%=showwhat%></b></font>
</td>
<td bgcolor="black" class="me" style="color:white"></td>
</tr>
<tr>
<td height="10"></td>
</tr>
<%
strSoegeord = Trim(Request.Form("soegeord"))
strSoegeord = Replace(strKeyword,"'","'")
ShowSource "SELECT * FROM Scripts WHERE"
ShowSource = ShowSource & " (Navn LIKE '%" & strSoegeord & "%')"
ShowSource = ShowSource & " OR (Beskrivelse LIKE '%" & strSoegeord & "%')"
Set rs = Connect.Execute(ShowSource)
Select Case month(Showsource("Dato"))
case 1 maaned = " jan. "
case 2 maaned = " feb. "
case 3 maaned = " mar. "
case 4 maaned = " apr. "
case 5 maaned = " maj "
case 6 maaned = " jun. "
case 7 maaned = " jul. "
case 8 maaned = " aug. "
case 9 maaned = " sep. "
case 10 maaned = " okt. "
case 11 maaned = " nov. "
case 12 maaned = " dec. "
end select
%>
<%Do While Not RS.EOF %>
<tr>
<td class="me" valign="top" style="border-bottom: 1px solid rgb(0,0,0)">
<a href="<%=rs("URL")%>" target="<%=rs("Target")%>" class="scripts"><b><%=rs("Navn")%></b></a>
<% if not (DateDiff("d", rs("opdateret"), Now)) > 2 then
response.write " <font color=red><i><b>NY!</b></i></font><br>"
else
response.write ""
end if%>
<br>
<%=rs("Beskrivelse")%>
<br>
<br>
</td>
<td class="me" valign="top" width="200" style="border-bottom: 1px solid rgb(0,0,0); border-left: 1px solid rgb(220,220,220)">
Uploadet af: <a href="../control/viewprofile.asp?mode=view&showwho=<%=rs("Uploader")%>" class="scripts"><b><%=rs("Uploader")%></b></a><br>
Type: <b><%=rs("Type")%></b><br><small>
<% datoen = rs("Opdateret")%>
Opdateret: <%Response.Write day(rs("Dato")) & maaned & year(rs("Dato"))%> </small>
<br>
</small>
<%
rs.Movenext
loop
%>
<%end if %>
