no, i couldn't get it to work in cf but im sure ill use it later. Thanks for
the insight.
- Original Message -
From: "Samuel R. Neff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 14, 2003 12:32 PM
Subject: Re: Delete re
At 12:12 PM 1/14/2003, you wrote:
>I was just curious as to rather or not there was a sql statement to do this
>with an access db like there is with sql server
Access is basically just a SQL engine and doesn't have the rich function
library that MSSQL has. Most of the function you use in Access
TED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 14, 2003 11:55 AM
Subject: Re: Delete records older than a certain time frame
> - Original Message -
> From: "Ewok" <[EMAIL PROTECTED]>
> >
> > delete * from tbl_bb_newus
t: 14 January 2003 16:56
To: CF-Talk
Subject: Re: Delete records older than a certain time frame
- Original Message -
From: "Ewok" <[EMAIL PROTECTED]>
>
> delete * from tbl_bb_newusers
> where datejoined < #createodbcdatetime(dateadd("h", -24, now
- Original Message -
From: "Ewok" <[EMAIL PROTECTED]>
>
> delete * from tbl_bb_newusers
> where datejoined < #createodbcdatetime(dateadd("h", -24, now()))#
>
>
> but do you know of a way to do exactly this with a sql statement alone, no
> cf vars
>
> ...for an access db
-
Original Message -
From: "Gyrus" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Txuesday, January 14, 2003 10:43 AM
Subject: Re: Delete records older than a certain time frame
> - Original Message -
> From: "Ewok" <[E
- Original Message -
From: "Ewok" <[EMAIL PROTECTED]>
> I've been trying to write a query to delete records older than 24 hours. I
> can do it with a loop and a var, but I'm sure there is a way to do it with
a
> single query statement.
How about:
DELETE FRO
Hllo everyone,
I've been trying to write a query to delete records older than 24 hours. I
can do it with a loop and a var, but I'm sure there is a way to do it with a
single query statement.
I have a field in the table that holds the date that the record was entered.
"DateJoined".
If i was using
8 matches
Mail list logo