Problemer med Global.asa
Jeg får en fejl lydende således:Der opstod en Microsoft VBScript-kompileringsfejl fejl '800a0409'
Strengkonstanten er uafsluttet
global.asa, linje 25
SQL = SQL & "JavaApplets, ActiveXControls, AOL, Platform, VBScript)
-------------------------------------------------------------------^
Hvordan fixes det?
<Script Language=VBScript RUNAT="server">
Sub Session_OnStart
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("statistik.mdb")
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open strDSN
set BC = server.createobject("MSWC.BrowserType")
DateTimeEntrance = Now()
IPAddress = Request.ServerVariables ("remote_addr")
UserAgent = Request.ServerVariables ("HTTP_USER_AGENT")
Browser = BC.Browser & " " & BC.Version
DHTMLSupport = cstr(BC.dhtml)
FramesSupport = cstr(BC.frames)
TablesSupport = cstr(BC.tables)
CookiesSupport = cstr(BC.cookies)
BackgroundSounds = cstr(BC.backgrounds)
JavaScriptSupport = cstr(BC.javascript)
JavaAppletsSupport = cstr(BC.javaapplets)
ActiveXControlsSupport = cstr(BC.activexcontrols)
AOL = cstr(BC.aol)
Platform = cstr(BC.platform)
VBScritSupport = cstr(BC.vbscript)
SQL = SQL & "DHTML, Frames, Tables, Cookies, BackgroundSounds, Javascript, "
SQL = SQL & "JavaApplets, ActiveXControls, AOL, Platform, VBScript)
values ("
SQL = SQL & "'" & DateTimeEntrance & "', "
SQL = SQL & "'" & IPAddress & "', "
SQL = SQL & "'" & UserAgent & "', "
SQL = SQL & "'" & Browser & "', "
SQL = SQL & "'" & DHTMLSupport & "', "
SQL = SQL & "'" & FramesSupport & "', "
SQL = SQL & "'" & TablesSupport & "', "
SQL = SQL & "'" & CookiesSupport & "', "
SQL = SQL & "'" & BackgroundSounds & "', "
SQL = SQL & "'" & JavaScriptSupport & "', "
SQL = SQL & "'" & JavaAppletsSupport & "', "
SQL = SQL & "'" & ActiveXControlsSupport & "', "
SQL = SQL & "'" & AOL & "', "
SQL = SQL & "'" & Platform & "', "
SQL = SQL & "'" & VBScriptSupport & "')"
Conn.Execute SQL
SetRSRecordID = Conn.Execute("select RecordID from Visitors where DateTimeEntrance = '"_
& DateTimeEntrance & "'")
Session("RecordID") = clng(RSRecordID("RecordID"))
End Sub
Sub Session_OnEnd
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("statistik.mdb")
Set myConn = Server.CreateObject("ADODB.Connection")
myconn.execute "update Visitors set DateTimeExit = '" & Now() _
& "' where RecordID = " & Session("RecordID")
End Sub
</script>
