<%
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 'f' 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(" ")
%>
|