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:

Quit revisited (1997) %@#*& back button!!! (1999) RE: Ongoing group search problems ... (1997) The max=0 issue is a bug ... CALL TO ACTION (2000) Authorize.net setup (2002) Mac: LModelDirector bug fix (1997) the dreaded unitShipCost (2003) message forum question (2005) Misunderstanding?? (1997) [searchString] (1997) Thanks for tips, more quest (1997) [shownext max=?] armed (1997) Help formatting search results w/ table (1997) BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (1999) Crash Log Question (2006) WebCat2 Append problem (B14Macacgi) (1997) Calculating multiple shipping... (1997) RAM variables (1997) cart token (2000) [listfiles] problems (1997)