Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" &Server.MapPath("db/hhgsdb.mdb")
SQL = "Select Count(besoksid) AS iCount from besoksstatistik"
Set RecSet = [B]Connect[/B].execute(SQL)
Response.write RecSet("iCount")
Frågan#1
blir inte vis på detta:
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" &Server.MapPath("db/hhgsdb.mdb")
SQL = "Select Count(besoksid) AS iCount from besoksstatistik"
Set RecSet = databas.execute(SQL)
Response.write RecSet("iCount")
felmess:
Körningsfel i Microsoft VBScript (0x800A01A8)
Objekt krävs.: ''
/hhgspunktse/hhgs/hhgsadmin.asp, line 3859
rad 3859 är "Set RecSet = databas.execute(SQL)"