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:

HomePage Caution (1997) more on quicktime test stuff (1997) Updating fields from different platforms (1998) [ShowNext] feature in 2.0 (1997) strange problem listfiles and movefile (2000) Snake Bites (1997) Format question WC Mac f3 (1997) carriage returns in data (1997) Execute Applescript (1997) Search in 2 or more catalogs (1997) Running 2 two WebCatalog.acgi's (1996) WebSite and *NO* Authentication Dialog Box!!? (1998) Math (1997) Caching [include] files ... (1997) WebCat2b12plugin - [search] is broken ... not! (1997) Filemaker Pro and [convertchars] (2000) RE: URL too Long? (1997) Email password -- was Classified Ads 4 Sale (1998) [TaxableTotal] - not working with AOL and IE (1997) Frames (1997)