Hej!
Får felmeddelandet "Too many fields defined" när jag
ska lista information från en Accessdatabas som i sin tur är länkad mot ett excelark.
Så här ser koden ut
...
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "flyg"
Alder = Session("Alder")
Farg = Session("Farg")
Fran = Session("Fran")
Till = Session("Till")
If Fran <>"" AND Alder="nya" Then
show="SELECT * from schema WHERE Datum BETWEEN '" & Fran & "' AND '" & Till &"' ORDER BY Datum,Avgang,Ankomst"
Set result = Connect.Execute(show)
Elseif Fran="" AND Alder="nya" Then
show="SELECT * from schema WHERE Datum >= Date() ORDER BY Datum,Avgang,Ankomst"
Set result = Connect.Execute(show)
else
show="SELECT * from schema WHERE Datum < Date() ORDER BY Datum,Avgang,Ankomst"
Set result = Connect.Execute(show)
...