statistik sidste 7 dage

Har du et dato felt på produkt_statistik??

ja - både dato og tid

set rs = conn.execute("... where datoTidKolonne >= dateadd('d',-7,now()) group by...")

... Det er Access syntax. Hvis du bruger en anden database er det måske anderledes.

bruger MySQL

melder fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.18-standard-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('d',-7,now()) group by product_id order by antal desc' at line

/admin/files/file_2.asp, line 86

----------------------------------------------------------------------------------------
Set rs = conn.Execute("select product_id, count(product_id) as antal from produkt_statistik where dato >= dateadd('d',-7,now()) group by product_id order by antal desc")                     
----------------------------------------------------------------------------------------

Mener MySQL syntaxen er:
dato >= date_add(now(), INTERVAL -7 DAY)

cool - ser ud til at virke :o)

.o) <-- One Eyed Jack