Avatar billede styrelse Nybegynder
29. november 1999 - 10:03 Der er 10 kommentarer og
1 løsning

Ændring af søge script

Hi ho

Jeg har et søge script jeg behøver lidt hjælp til at ændre.

Hvordan får jeg <html> & <body> over selve asp koden?

Her er koden:

<%

  Response.Expires = 0
  Response.AddHeader "Pragma", "NO-CACHE"
  Session.Timeout=120

  Path = "C:\aida\"
  DBName = "news2.mdb"

  set Conn = server.createobject("ADODB.Connection")
  Conn.Open "DBQ=" & Path & DBName & ";DefaultDir=" & Path & ";Driver={Microsoft Access Driver (*.mdb)}"

  if Request.Form("valg") = "Afgørelse truffet af" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[truffet af] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Journal nr." then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Journal] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Afgørelsesdato" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Afgoerelsesdato] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Udsendelsesdato" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Udsendelsesdato] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Meddelelse nr." then
    SQL = "SELECT * FROM [SM] WHERE [SM].[meddelelse] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Meddelelse om" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Om] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Lov" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Lov] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if

if Request.Form("valg") = "Bekendtgørelse" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[bekendtgoerelse] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if

if Request.Form("valg") = "Resume" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Resume] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Sagsfremstilling" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[sagsfremstilling] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Afgørelse" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[afgoerelse] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  set Result = Conn.Execute(SQL)
 
  if Result.Eof then
    Response.Write "<table width=400><tr><td><span class=normaltext>Din søgning gav desværre intet resultat!</p>Prøv med en bredere søgning!</SPAN>"
  else
    Response.Write "<table width=400 border=0 cellpadding=5 cellspacing=0><tr><td bgcolor=#C2B26A><span class=normaltext>Din søgning gav følgende resultat (sorteret efter afgørelsesdato):</SPAN></p></td></tr></table>"
    Response.Write "<div align=""left""><table border=""0"" width=""400"" bgcolor=#EFEAD6> <tr>"
    do while not Result.Eof

   
      Response.Write "</td><td width=""300"">" & "<span class=normaltext><b>Journal nr.:</b> " & Result("Journal") & "</SPAN></td></tr>"
      Response.Write "</td><td width=""300"">" & "<span class=normaltext><b>Afgørelsesdato:</b> " & Result("Afgoerelsesdato") & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext><b>Meddelelse om:</b> " & Result("Om") & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext><b>Lov:</b> " & Result("Lov") & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext><a href=sm.asp?ID=" & Result("ID") & ">" & "Læs SM" & "</a>" & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""0"">&nbsp</p></td></tr>"
      Result.Movenext
      i = i + 1
   
    if i > 1 then
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext>" & "Søgningen gav " & i & " resultater." & "</SPAN></td></tr>"
    else
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext>" & "Søgningen gav " & i & " resultat." & "</SPAN></td></tr>"
    end if
loop
    Response.Write "<tr><td width=""300""><span class=normaltext>" & "<form method=GET action=search_sm.htm id=form1 name=form1>" & "<input type=submit value=""Ny Søgning"" name="">" & "</form></SPAN></td></tr>"
    Response.Write "</tr></table></div>"

  end if
%>

<html>

<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style.css"></head>

<body bgcolor="#FFFFFF">
</body>
</html>
Avatar billede erikjacobsen Ekspert
29. november 1999 - 10:14 #1
Flyt linierne:
<html>

                    <head>
                    <title></title>
                    <link rel="stylesheet" type="text/css" href="style.css"></head>

                    <body bgcolor="#FFFFFF">

op mellem

  Session.Timeout=120
%>
...indsættes her ...
<%
      Path = "C:\aida\"
Avatar billede pingo Nybegynder
29. november 1999 - 10:16 #2
<html>

<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style.css"></head>

<body bgcolor="#FFFFFF">

<%

  Response.Expires = 0
  Response.AddHeader "Pragma", "NO-CACHE"
  Session.Timeout=120

  Path = "C:\aida\"
  DBName = "news2.mdb"

  set Conn = server.createobject("ADODB.Connection")
  Conn.Open "DBQ=" & Path & DBName & ";DefaultDir=" & Path & ";Driver={Microsoft Access Driver (*.mdb)}"

  if Request.Form("valg") = "Afgørelse truffet af" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[truffet af] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Journal nr." then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Journal] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Afgørelsesdato" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Afgoerelsesdato] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Udsendelsesdato" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Udsendelsesdato] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Meddelelse nr." then
    SQL = "SELECT * FROM [SM] WHERE [SM].[meddelelse] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Meddelelse om" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Om] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Lov" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Lov] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if

if Request.Form("valg") = "Bekendtgørelse" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[bekendtgoerelse] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if

if Request.Form("valg") = "Resume" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Resume] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Sagsfremstilling" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[sagsfremstilling] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Afgørelse" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[afgoerelse] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  set Result = Conn.Execute(SQL)
 
  if Result.Eof then
    Response.Write "<table width=400><tr><td><span class=normaltext>Din søgning gav desværre intet resultat!</p>Prøv med en bredere søgning!</SPAN>"
  else
    Response.Write "<table width=400 border=0 cellpadding=5 cellspacing=0><tr><td bgcolor=#C2B26A><span class=normaltext>Din søgning gav følgende resultat (sorteret efter afgørelsesdato):</SPAN></p></td></tr></table>"
    Response.Write "<div align=""left""><table border=""0"" width=""400"" bgcolor=#EFEAD6> <tr>"
    do while not Result.Eof

   
      Response.Write "</td><td width=""300"">" & "<span class=normaltext><b>Journal nr.:</b> " & Result("Journal") & "</SPAN></td></tr>"
      Response.Write "</td><td width=""300"">" & "<span class=normaltext><b>Afgørelsesdato:</b> " & Result("Afgoerelsesdato") & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext><b>Meddelelse om:</b> " & Result("Om") & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext><b>Lov:</b> " & Result("Lov") & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext><a href=sm.asp?ID=" & Result("ID") & ">" & "Læs SM" & "</a>" & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""0"">&nbsp</p></td></tr>"
      Result.Movenext
      i = i + 1
   
    if i > 1 then
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext>" & "Søgningen gav " & i & " resultater." & "</SPAN></td></tr>"
    else
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext>" & "Søgningen gav " & i & " resultat." & "</SPAN></td></tr>"
    end if
loop
    Response.Write "<tr><td width=""300""><span class=normaltext>" & "<form method=GET action=search_sm.htm id=form1 name=form1>" & "<input type=submit value=""Ny Søgning"" name="">" & "</form></SPAN></td></tr>"
    Response.Write "</tr></table></div>"

  end if
%>

</body>
</html>

Er det det du mener?
Avatar billede pingo Nybegynder
29. november 1999 - 10:18 #3
Btw - du har andre spørgsmål liggende som du ikke har fået gjort noget ved længe!

http://www.eksperten.dk/spm.asp?id=5471

http://www.eksperten.dk/spm.asp?id=5060

Kan du ikke gøre noget ved dem!
Avatar billede erikjacobsen Ekspert
29. november 1999 - 10:21 #4
Pingo, pingo, man må ikke lave HTML-kode, før man skriver
til headeren! Derfor må <HTML>..etc ikke flyttes helt op i
toppen - selv om det er fristende !!
Avatar billede pingo Nybegynder
29. november 1999 - 10:33 #5
Nej - det ved jeg - beklager -jeg havde ikke set de response ting. Sådan her så!
<%
  Response.Expires = 0
  Response.AddHeader "Pragma", "NO-CACHE"
  Session.Timeout=120
%>
<html>

<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style.css"></head>

<body bgcolor="#FFFFFF">

<%
  Path = "C:\aida\"
  DBName = "news2.mdb"

  set Conn = server.createobject("ADODB.Connection")
  Conn.Open "DBQ=" & Path & DBName & ";DefaultDir=" & Path & ";Driver={Microsoft Access Driver (*.mdb)}"

  if Request.Form("valg") = "Afgørelse truffet af" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[truffet af] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Journal nr." then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Journal] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Afgørelsesdato" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Afgoerelsesdato] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Udsendelsesdato" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Udsendelsesdato] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Meddelelse nr." then
    SQL = "SELECT * FROM [SM] WHERE [SM].[meddelelse] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Meddelelse om" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Om] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Lov" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Lov] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if

if Request.Form("valg") = "Bekendtgørelse" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[bekendtgoerelse] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if

if Request.Form("valg") = "Resume" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[Resume] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Sagsfremstilling" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[sagsfremstilling] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  if Request.Form("valg") = "Afgørelse" then
    SQL = "SELECT * FROM [SM] WHERE [SM].[afgoerelse] LIKE '%" & Request.Form("search") & "%' ORDER BY [SM].[Afgoerelsesdato]"
  end if
 
  set Result = Conn.Execute(SQL)
 
  if Result.Eof then
    Response.Write "<table width=400><tr><td><span class=normaltext>Din søgning gav desværre intet resultat!</p>Prøv med en bredere søgning!</SPAN>"
  else
    Response.Write "<table width=400 border=0 cellpadding=5 cellspacing=0><tr><td bgcolor=#C2B26A><span class=normaltext>Din søgning gav følgende resultat (sorteret efter afgørelsesdato):</SPAN></p></td></tr></table>"
    Response.Write "<div align=""left""><table border=""0"" width=""400"" bgcolor=#EFEAD6> <tr>"
    do while not Result.Eof

   
      Response.Write "</td><td width=""300"">" & "<span class=normaltext><b>Journal nr.:</b> " & Result("Journal") & "</SPAN></td></tr>"
      Response.Write "</td><td width=""300"">" & "<span class=normaltext><b>Afgørelsesdato:</b> " & Result("Afgoerelsesdato") & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext><b>Meddelelse om:</b> " & Result("Om") & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext><b>Lov:</b> " & Result("Lov") & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext><a href=sm.asp?ID=" & Result("ID") & ">" & "Læs SM" & "</a>" & "</SPAN></td></tr>"
      Response.Write "<tr><td width=""0"">&nbsp</p></td></tr>"
      Result.Movenext
      i = i + 1
   
    if i > 1 then
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext>" & "Søgningen gav " & i & " resultater." & "</SPAN></td></tr>"
    else
      Response.Write "<tr><td width=""300"">" & "<span class=normaltext>" & "Søgningen gav " & i & " resultat." & "</SPAN></td></tr>"
    end if
loop
    Response.Write "<tr><td width=""300""><span class=normaltext>" & "<form method=GET action=search_sm.htm id=form1 name=form1>" & "<input type=submit value=""Ny Søgning"" name="">" & "</form></SPAN></td></tr>"
    Response.Write "</tr></table></div>"

  end if
%>

</body>
</html>
Avatar billede styrelse Nybegynder
29. november 1999 - 10:34 #6
erikjacobsen>>Er det sådan du mener?

<%

  Response.Expires = 0
  Response.AddHeader "Pragma", "NO-CACHE"
  Session.Timeout=120
%>
 
<html>

<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style.css"></head>

<body bgcolor="#FFFFFF">
 
<%
  Path = "C:\aida\"
  DBName = "news2.mdb"
Avatar billede pingo Nybegynder
29. november 1999 - 10:35 #7
styrelse: ja - korrekt..
Avatar billede styrelse Nybegynder
29. november 1999 - 10:40 #8
pingo>>Selv om dit svar også var rigtigt, kom erikjacobsen jo først. Så derfor
Avatar billede erikjacobsen Ekspert
29. november 1999 - 10:43 #9
:-))
Avatar billede pingo Nybegynder
29. november 1999 - 10:55 #10
styrelse: ok - men kan du ikke afslutte det sidste af de 2 uafsluttede spg.
Avatar billede pingo Nybegynder
29. november 1999 - 13:49 #11
Styrelse:

kan du ikke gøre noget ved den her:

http://www.eksperten.dk/spm.asp?id=5471
Avatar billede Ny bruger Nybegynder

Din løsning...

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.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester