Like I said, this is what I'm using now, and no, it doesnt cause any
problems....in coldfusion
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
----- Original Message -----
From: "Gyrus" <[EMAIL PROTECTED]>
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]>
> > <cfquery name="delold" datasource="#request.maindsn#" dbtype="ODBC">
> > delete * from tbl_bb_newusers
> > where datejoined < #createodbcdatetime(dateadd("h", -24, now()))#
> > </cfquery>
> >
> > but do you know of a way to do exactly this with a sql statement alone,
no
> > cf vars
> >
> > ...for an access db
> ----------------------------
>
> Why no CF vars? I know it's a good idea in general to get the DB to handle
> all it can handle, but this works fine in Access, I can't imagine it
causes
> any real problems through using a CF var.
>
> Gyrus
> [EMAIL PROTECTED]
> work: http://www.tengai.co.uk
> play: http://norlonto.net
> PGP key available
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
