<%
Dim objDBF, objR
Set objDBF = Server.CreateObject("ADODB.Connection")
objDBF.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=D:\Websites\LocalUser\w199597\www\db\politikk.mdb"
objDBF.Open
'kopierer innholdet i tabellen medlemmer til objR
Set objR = Server.CreateObject("ADODB.Recordset")
objR.Open "Select * FROM politikk order by navn", objDBF
Response.Write("")
Set objR = objDBF.Execute("Select navn, tekst from politikk where tekst not like '.' and alfabet like 'c' or tekst not like '.' and alfabet like 'd' order by navn")
Do While Not objR.EOF
Response.Write("")
Response.Write("" & objR("navn") & " | ")
Response.Write("" & objR("tekst") & " | ")
Response.Write("")
Response.Write(" ")
objR.MoveNext()
Loop
Response.Write(" ")
%>
|