Thanx Bud,
Yeah, I was going to include the snippet in the template which generates
each month's page. This should do the trick.
thanx again,
Chris
At 03:48 AM 11/29/00 -0500, you wrote:
>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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
