begränsning i Access??

1 svar · 246 visningar · startad av Eclipse 15 jan. 2005

EclipseMedlem sedan juli 20003 825 inlägg

15 jan. 2005 16:31#1

' ## DELETE OLD POST IN HTTP_REFERER-LOG -- 42 DAYS = 6 WEEKS
SQL = "DELETE * FROM [http_referer] WHERE dteCreated <#" & dateAdd("d", -43, date()) & "#;"
Conn.Execute(SQL)
SQL = "DELETE * FROM [referer_log] WHERE dteCreated <#" & dateAdd("m", -43, date()) & "#;"
Conn.Execute(SQL)
SQL = "DELETE * FROM [active_meta] WHERE dteCreated <#" & dateAdd("m", -43, date()) & "#;"
Conn.Execute(SQL)

Finn fem fel...!! :-)

Datumet ska vara 2004-12-03 (gäller just idag).
http_referer = 2004-12-06, 4.344 poster
referer_log = 2004-09-29, 29.073 poster
active_meta = 2004-09-23, 916 poster

Varför raderas inte posterna!?

EclipseMedlem sedan juli 20003 825 inlägg

15 jan. 2005 16:38#2

' ## DELETE OLD POST IN HTTP_REFERER-LOG -- 42 DAYS = 6 WEEKS
SQL = "DELETE * FROM [http_referer] WHERE dteCreated <#" & dateAdd("d", -43, date()) & "#;"
Conn.Execute(SQL)
SQL = "DELETE * FROM [referer_log] WHERE dteCreated <#" & dateAdd([b]"m"[/b], -43, date()) & "#;"
Conn.Execute(SQL)
SQL = "DELETE * FROM [active_meta] WHERE dteCreated <#" & dateAdd([b]"m"[/b], -43, date()) & "#;"
Conn.Execute(SQL)

Byt "m" till "d"... och det behövs ett inlägg i forumet för att se det! Beklagligt, verkligen!