Det gik helt gale nu :-) Men her er koden, selvom den fylder. Så håber jeg at det giver noget:
<%@ Language=VBScript %>
<% Option Explicit %>
<%
Dim objConn
Set objConn = Server.CreateObject(\"ADODB.Connection\")
objConn.ConnectionString = \"DSN=skoler.dsn\"
objConn.Open
%>
<!--#include virtual=\"/adovbs.inc\"-->
<HTML>
<BODY bgcolor=\"#C0C0C0\">
<%
Dim objRS
Dim rs(23), SkoleNavn
Dim Field
Dim i
\' Henter værdien fra s.htm
SkoleNavn = Trim(Request.Form(\"Keyword\"))
Response.Write \"<BR><CENTER><table width=\'60%\' border=\'0\'><tr><td width=\'40%\'><STRONG>Søgeordet er: </STRONG></td>\" & \"<td width=\'40%\'><STRONG>\" & SkoleNavn & \"</STRONG</td></tr></table></CENTER>\"
Set objRS = Server.CreateObject (\"ADODB.Recordset\")
objRS.Open \"skoler\", objConn, , , adCmdTable
If objRS.EOF Then
Response.write \"Beklager, databasen er tom\"
Else
Do While Not objRS.EOF
i = 1
If SkoleNavn = (objRs.Fields(i).Value) Then
Call Skriv
End If
objRS.MoveNext
Loop
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
End If
Sub skriv
Dim email
Response.Write \"<BR><BR><CENTER><table width=\'60%\' border=\'1\'>\"
Response.Write \"<tr><td><STRONG>Skolens nummer </STRONG></td>\" & \"<td><STRONG>\" & (objRS.Fields(0).Value & \"</STRONG></td></tr>\")
Response.Write \"<tr><td><STRONG>Skolens navn </STRONG></td>\" & \"<td><STRONG>\" & (objRS.Fields(1).Value & \"</STRONG></td></tr>\")
Response.Write \"<tr><td><STRONG>Adresse1 </STRONG></td>\" & \"<td><STRONG>\" & (objRS.Fields(2).Value & \"</STRONG></td></tr>\")
Response.Write \"<tr><td><STRONG>Adresse2 </STRONG></td>\" & \"<td><STRONG>\" & (objRS.Fields(3).Value & \"</STRONG></td></tr>\")
Response.Write \"<tr><td><STRONG>Postnr & By </STRONG></td>\" & \"<td><STRONG>\" & (objRS.Fields(4).Value & \" \" & (objRS.Fields(5).Value & \"</STRONG></td></tr>\"))
Response.Write \"<tr><td><STRONG>Telefon </STRONG></td>\" & \"<td><STRONG>\" & (objRS.Fields(6).Value & \"</STRONG></td></tr>\")
Response.Write \"<tr><td><STRONG>Fax </STRONG></td>\" & \"<td><STRONG>\" & (objRS.Fields(7).Value & \"</STRONG></td></tr>\")
Response.Write \"<tr><td><STRONG>Leder </STRONG></td>\" & \"<td><STRONG>\" & (objRS.Fields(10).Value & \"</STRONG></td></tr>\")
Response.Write \"<tr><td><STRONG>Kontaktperson </STRONG></td>\" & \"<td><STRONG>\" & (objRS.Fields(11).Value & \"</STRONG></td></tr>\")
email = (objRS.Fields(21).Value)
if email = \"\" Then
email = chr(32)
Response.Write \"<tr><td><STRONG>E-mail </STRONG></td>\" & \"<td><STRONG>\" & email & \"</STRONG></td></tr>\"
end if
Response.Write \"</table></CENTER>\"
End Sub
%>
<BR><BR>
<CENTER>
<a href=\"
http://192.168.0.210/s.asp\"><strong>Ny søgning </strong></a>
<a href=\"
http://192.168.0.210/skoler.asp\"><strong> Eller tilbage til hjemmesiden</strong></a>
</CENTER>
</BODY>
</HTML>