Re: Deleteing Based On Dates

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41166
interpreted = N
texte = If you are on WC4.x, you can set the century break in WebCat preferences - if you set it to, say 50, then all 2-digit dates <= 50 will be assumed to be in the 2000's, while those >50 will be assumed to be in the 1900's.Execute this code: [math]{06/15/2002}[/math]
[math]{06/15/02}[/math]
They will be the same if WC thinks 02 is 2002. If they aren't, then adjust you're WC Preferences, then (hopefully) the delete will work for you.- brianAt 4:42 PM 7/2/02, Arturo Vargas wrote: >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/yyyy > >also 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/ -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.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)
If you are on WC4.x, you can set the century break in WebCat preferences - if you set it to, say 50, then all 2-digit dates <= 50 will be assumed to be in the 2000's, while those >50 will be assumed to be in the 1900's.Execute this code: [math]{06/15/2002}[/math]
[math]{06/15/02}[/math]
They will be the same if WC thinks 02 is 2002. If they aren't, then adjust you're WC Preferences, then (hopefully) the delete will work for you.- brianAt 4:42 PM 7/2/02, Arturo Vargas wrote: >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/yyyy > >also 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/ -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.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/ Brian Fries

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 a web cat programmer (2000) searching with if/then (2004) I'm new be kind (1997) Clear command and ShoppingCart.tmpl (1997) CDATA problems (2008) [Lookup] on secure page not returning anything (2000) Setting up shop (1997) WebCat2b13 Command Reference Doc error (1997) Progress !! WAS: Trouble with formula.db (1997) Heads up: WebCatalog 4 drops MacTCP, 68K (2000) WebStar Secure on other machine (1997) Upgrade to wsV (Email issue) (2004) DON'T use old cart file! (1997) cron script for housekeeping and running WebCatalog? (1999) Does anyone have a TCPconnect that does multiple sends... (2000) Simple counter - how? (1997) hiding hyperlink info in URL field (1999) AW: AW: Credit card processing - UK (1997) Problems with cybercash (2000) [WebDNA] [tcpconnect] timeout (2015)