Snabb sql

sql = "select count(*) as besokare from raknare, count(distinct ip) as unika from raknare"

asså vill ha: count(*) as besokare
o sen: unika som alla unika ip...

select count(*) as besokare,
          count(distinct ip) as unika 
  from raknare

flyttas från ASP.

select count(*) as besokare, count(distinct IP) as unika from raknare

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][Drivrutin för ODBC Microsoft Access] Syntaxfel (operator saknas) i frågeuttrycket 'count(distinct IP)'.
/alkisarna/Default.asp, line 679

kör access alltså ;)

Ja Access har en begränsning här

select count(*) as besokare, 
(select count(*) from
 (select distinct ip from raknare)) as unika 
from raknare

Tackar vi för
Funkar prima