On 11/28/00, Chris Geanious penned:
>I have a CF based events calendar I am modifying and need to delete events
>older than 30 days from the Access database. What would be the simplest
>way to set this up. Should be relatively simple but my brain is dim at the
>moment.
<cfset deletedate = dateadd('D', -30, now())>
<CFQUERY DATASOURCE="#attributes.DSN#">
DELETE FROM events
WHERE eventdate < #createodbcdate(deletedate)#
</CFQUERY>
As far as auto deleting it, you'll need to set up a cfschedule or
have it load every time someone accesses some page.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
