Tal i database string
hey.!når jeg skriver følgende:
times = split("01,08,12,16,20", ",")
for each post in times
if post < 08 then
post2 = post + 7
sql = "select count(*) as timecount from visits where dato like '"& date &"' and hour between '"& post &"' and '"& post2 &"'"
else
post2 = post + 4
sql = "select count(*) as timecount from visits where dato like '"& date &"' and hour between '"& post &"' and '"& post2 &"'"
end if
set rs = conn.execute(sql)
next
så får jeg følgende fejlkode:
Fejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access-driver] Datatyperne stemmer ikke overens i kriterieudtrykket.
/stats/inc/day.asp, line 21
jeg fatter simpelthen ikk hvad der går galt ?
