WHERE last < #DateAdd("n", "-1", now())# Adam.
> -----Original Message----- > From: Kris Pilles [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 09, 2002 12:12 PM > To: CF-Talk > Subject: Query Help? > > > I need to write some SQL that says > Delete from session where Last is 1 minute ago > > Delete > From Session > Where Last < __________________ > > > ??? > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists