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:

[shownext max=?] armed (1997) Help! WebCat2 bug (1997) [OT] (waaaay OT) (2004) Logical and or in [hideif] (1997) AW: AW: Credit card processing - UK (1997) [ShowIf] and empty fields (1997) possible, WebCat2.0 and checkboxes-restated (1997) Stopping bad HTML propagation ? (1997) tricky embedded[showifs/hideifs] (w/ code.. long) (2000) shipcost (1997) Sorting by date (1997) 2.0Beta Command Ref (can't find this instruction) (1997) ShowIf variables (1997) Emailer Chokes on bad address (1997) Fun with dates (1997) [WebDNA] WebDNA not running after 10.6.3 update (2010) WC2b12: Yes, Formulas.db is for real (1997) Make sure I understand this??? (1997) Re:2nd WebCatalog2 Feature Request (1996) Sort Order on a page search (1997)