Miles,

I may be mistaken, but I think there is a custom tag or script on the
gallery that can take care of this task for you.

Mark

-----Original Message-----
From: Miles Fawcett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 11:31 AM
To: CF-Talk
Subject: Purge cfVar db using SQL script


We are using CF5 in a clustered environment and would like to purge the
cfVar db (MS-SQL7) using SQL. the tables are simple enough but I am
interested in anyone has a script they know works are has any insight into
this approach.

We would like to purge all records older than 30 days.

Thanks,
Miles





Miles Fawcett, President
Interactive Applications Group (iapps)
tel 202.265.3700 x105 - fax 202.318.0237 - ICQ:1864271
Washington  *  New York  *  San Francisco  *  Boston


______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to