----- 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:
<cfquery name="purge" datasource="#request.DB_DSN#"
dbtype="#request.DB_type#">
DELETE FROM tab
WHERE dateJoined < <cfqueryparam
value="#CreateODBCDateTime(DateAdd('h', -24, Now()))#"
cfsqltype="CF_SQL_DATE">
</cfquery>
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
