Re: Delete records older than a certain time frame

2003-01-14 Thread Ewok
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

Re: Delete records older than a certain time frame

2003-01-14 Thread Samuel R. Neff
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

Re: Delete records older than a certain time frame

2003-01-14 Thread Ewok
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

RE: Delete records older than a certain time frame

2003-01-14 Thread Robertson-Ravo, Neil (RX)
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

Re: Delete records older than a certain time frame

2003-01-14 Thread Gyrus
- 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 -

Re: Delete records older than a certain time frame

2003-01-14 Thread Ewok
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

Re: Delete records older than a certain time frame

2003-01-14 Thread Gyrus
- 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

Delete records older than a certain time frame

2003-01-14 Thread Ewok
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