Re: Deleteing Based On Dates

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41165
interpreted = N
texte = I was having a similar problem earlier. the reason I was having the problem was that the field that contained the date was formated dd/mm/yy and the [math] comand produces a date formated dd/mm/yyyyalso it is easier for me to debug my code if I do this:[math date]mydate={[date]}-{00/07/0000}[/math] [delete db=[log]&leDTdatarq=[mydate]&DTtype=date] that way I am sure that I am producing mydate correctly.Also you can try hardcoding [mydate] with the right value, to see if that works: ART-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Glenn Busbin Sent: Tuesday, July 02, 2002 4:24 PM To: WebCatalog Talk Subject: Re: Deleteing Based On Dates >I want to delete all entries that are 7 days old: > >[delete db=[log]&leDTdatarq=[math >date]{[date]}-{00/07/0000}[/math]&DTtype=date] > >Deletes everything in the database (There are things in there from the 17th >of June) > >Ideas?You aren't using Date as a field name, are you?Glenn------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Deleteing Based On Dates (Jesse Williams-Proudman 2002)
  2. Re: Deleteing Based On Dates (Brian Fries 2002)
  3. Re: Deleteing Based On Dates (Arturo Vargas 2002)
  4. Re: Deleteing Based On Dates (Glenn Busbin 2002)
  5. Re: Deleteing Based On Dates (Jesse Williams-Proudman 2002)
  6. Re: Deleteing Based On Dates (Gary Krockover 2002)
  7. Deleteing Based On Dates (Jesse Williams-Proudman 2002)
I was having a similar problem earlier. the reason I was having the problem was that the field that contained the date was formated dd/mm/yy and the [math] comand produces a date formated dd/mm/yyyyalso it is easier for me to debug my code if I do this:[math date]mydate={[date]}-{00/07/0000}[/math] [delete db=[log]&leDTdatarq=[mydate]&DTtype=date] that way I am sure that I am producing mydate correctly.Also you can try hardcoding [mydate] with the right value, to see if that works: ART-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Glenn Busbin Sent: Tuesday, July 02, 2002 4:24 PM To: WebCatalog Talk Subject: Re: Deleteing Based On Dates >I want to delete all entries that are 7 days old: > >[delete db=[log]&leDTdatarq=[math >date]{[date]}-{00/07/0000}[/math]&DTtype=date] > >Deletes everything in the database (There are things in there from the 17th >of June) > >Ideas?You aren't using Date as a field name, are you?Glenn------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Arturo Vargas

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Need relative path explanation (1997) Sense/Disallow HTML tags during $Append (1997) FTP Problem (2005) service stop and restart (1997) using showpage and showcart commands (1996) Customizing WebDelivery.html (1998) Multiple prices (1997) Hummm .... (2002) Simple Database close connection (2001) Forms Search Questions (1997) international time (1997) Username for Admin Group (1997) can WC render sites out? (1997) calculate age (2003) WCS Newbie question (1997) Weird Problem (1997) DOS variable bug (was SandBox and ImageMagick) (2003) Multiple Newcarts (1996) FREE Web Server Monitor FREE (1997) Duplicate Cart ID (2001)