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
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
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
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 !!
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>
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
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.