Count Udtræk - Time oversigt
Hejsa,Hvordan laver jeg et count udtræk time for time ?
Jeg skal kunne udskrive en sådan liste:
Kl | Antal
----------------------
08 2
09 3
10 1
11 9
12 2
----------------------
Kan denne kode tilpasses:
sql_uhits_hour = "SELECT time,COUNT(id) AS antal FROM uhits GROUP BY time"
SET rs_uhits_hour = Conn.execute(sql_uhits_hour)
IF rs_uhits_hour.EOF THEN
Response.Write "Tom"
ELSE
DO UNTIL rs_uhits_hour.EOF
uhits_hour_antal = rs_uhits_hour("antal")
uhits_hour_time = rs_uhits_hour("time")
Response.Write uhits_hour_time & " - "& uhits_hour_antal &"<br/>"
rs_uhits_hour.MoveNext
LOOP
END IF
rs_uhits_hour.close
SET rs_uhits_hour = NOTHING
SET sql_uhits_hour = NOTHING
