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:

Grep Search and Replace (2002) math/text variable limits per page (2001) Looking up two prices in database? (1997) Re:trouble (1997) Answer: WebDelivery downloads alias, not original ? (1997) Confused about QTY and QTY* price updating (1998) Serial Number Question (1997) text size limitation (1997) NetForms for email (1998) [Announce]: Web server security and password protection (1997) WebCat2 - [SendNews] (1997) [lookup] is case-sensitive, [lookup] is case sensitive... (2003) WC2.0 Memory Requirements (1997) System 8.5.1 question (1999) Beta 18 (1997) newbies to web, spaces in email address (1998) The Guru Speaks (1998) NT vs Mac (1997) New Install (2003) Summing fields (1997)