16. juli 2000 - 02:45Der er
6 kommentarer og 1 løsning
Forskellig efter antal...
Hvis jeg får mere end et hit pr søgning, hvordan skal jeg så kalde den rigtige tekststreng?
AntalSQL = "SELECT COUNT(*) AS ANTAL FROM ForsArtikel WHERE" AntalSQL = AntalSQL & " (Overskrift LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Billede LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Dato LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Teaser LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Forfatter LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Artikel LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Navn LIKE '%" & strKeyword & "%')"
set RsAntal = myConn.Execute(AntalSQL) Dim Antal Antal = RsAntal("ANTAL")
If strANTAL > 1 Then strANTAL = "Der blev fundet <b>" & ANTAL & "</b> aktikler med søgeordet <b>" & strKeyword & "</b>" Else strANTAL = "Der blev fundet <b>1</b> artikel med søgeordet <b>" & strKeyword & "</b>" End If
AntalSQL = "SELECT COUNT(*) AS ANTAL FROM ForsArtikel WHERE" AntalSQL = AntalSQL & " (Overskrift LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Billede LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Dato LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Teaser LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Forfatter LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Artikel LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Navn LIKE '%" & strKeyword & "%')"
set RsAntal = myConn.Execute(AntalSQL) Dim Antal Antal = RsAntal("ANTAL")
rsAntal.close set rsAntal = Nothing
strSQL = "SELECT ID, Overskrift, Billede, Dato, Teaser, Forfatter, Navn, Artikel FROM ForsArtikel WHERE" strSQL = strSQL & " (Overskrift LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Billede LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Dato LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Teaser LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Forfatter LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Navn LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Artikel LIKE '%" & strKeyword & "%')" strSQL = strSQL & " ORDER BY Dato DESC;"
Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then If Len(strKeyword) <> 0 Then Response.Write "<br><table align='center' border='0' width='550' cellspacing='1' cellpadding='0'>" Response.Write "<tr><td class='nyhedblack' align=left valign=top>Der blev fundet <b>" & ANTAL & "</b> artikler der indeholdt søgeordet: <b>" & strKeyword & "</b><br><br></td></tr>" Response.Write "</table>" End If Response.Write "<table align='center' border='0' width='550' cellspacing='1' cellpadding='0'>" Do While Not rs.EOF Response.Write "<tr><td height='15'><a href='VisArtikel.asp?ID=" & rs("ID") & "'>" & rs("Overskrift") & "</a></td></tr>" Response.Write "<tr><td class='nyhedblack' height='15'>Skrevet af <a class='smallblack' href='VisInfo.asp?ID=" & rs("Forfatter") & "'>" & rs("Navn") & "</a></td></tr>" Response.Write "<tr><td class='nyhedblack' height='15'>Lagt online d. " & rs("Dato") & "<hr noshade></td></tr>" rs.MoveNext Loop Response.Write "</table>" Else Response.Write "<br><br><p>Der er ikke fundet noget på denne søgning</p>" End If
AntalSQL = "SELECT COUNT(*) AS ANTAL FROM ForsArtikel WHERE" AntalSQL = AntalSQL & " (Overskrift LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Billede LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Dato LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Teaser LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Forfatter LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Artikel LIKE '%" & strKeyword & "%')" AntalSQL = AntalSQL & " OR (Navn LIKE '%" & strKeyword & "%')"
set RsAntal = myConn.Execute(AntalSQL) Dim Antal Antal = RsAntal("ANTAL")
rsAntal.close set rsAntal = Nothing
strSQL = "SELECT ID, Overskrift, Billede, Dato, Teaser, Forfatter, Navn, Artikel FROM ForsArtikel WHERE" strSQL = strSQL & " (Overskrift LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Billede LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Dato LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Teaser LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Forfatter LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Navn LIKE '%" & strKeyword & "%')" strSQL = strSQL & " OR (Artikel LIKE '%" & strKeyword & "%')" strSQL = strSQL & " ORDER BY Dato DESC;"
Set rs = myConn.Execute(strSQL) If Not (rs.BOF Or rs.EOF) Then If Len(strKeyword) <> 0 Then Response.Write "<br><table align='center' border='0' width='550' cellspacing='1' cellpadding='0'>" Response.Write "<tr><td class='nyhedblack' align=left valign=top>Der blev fundet <b>" & ANTAL & "</b>" if Antal = 1 then Response.write " artikel " else Response.write " artikler " end if Response.Write "der indeholdt søgeordet: <b>" & strKeyword & "</b><br><br></td></tr>" Response.Write "</table>" End If Response.Write "<table align='center' border='0' width='550' cellspacing='1' cellpadding='0'>" Do While Not rs.EOF Response.Write "<tr><td height='15'><a href='VisArtikel.asp?ID=" & rs("ID") & "'>" & rs("Overskrift") & "</a></td></tr>" Response.Write "<tr><td class='nyhedblack' height='15'>Skrevet af <a class='smallblack' href='VisInfo.asp?ID=" & rs("Forfatter") & "'>" & rs("Navn") & "</a></td></tr>" Response.Write "<tr><td class='nyhedblack' height='15'>Lagt online d. " & rs("Dato") & "<hr noshade></td></tr>" rs.MoveNext Loop Response.Write "</table>" Else Response.Write "<br><br><p>Der er ikke fundet noget på denne søgning</p>" End If
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.