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 thedate was formated dd/mm/yyand 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 thatworks:ART-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On BehalfOf Glenn BusbinSent: Tuesday, July 02, 2002 4:24 PMTo: WebCatalog TalkSubject: 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 toWeb 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:
I was having a similar problem earlier.the reason I was having the problem was that the field that contained thedate was formated dd/mm/yyand 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 thatworks:ART-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On BehalfOf Glenn BusbinSent: Tuesday, July 02, 2002 4:24 PMTo: WebCatalog TalkSubject: 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 toWeb 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:
Generating Report Totals (1997)
WebDNA for Dummies (2004)
Frames and WebCat (1997)
New syntax feedback for 4.0 (2000)
Spawn doesn't work as advertised ... (2000)
bug in [SendMail] (1997)
WebCommerce: Folder organization ? (1997)
OFF TOPIC: help wanted (1997)
Spawn doesn't work as advertised ... (2000)
RE: Search (1997)
retain raw [cart] submitted value (2004)
Did you hear about this? (1997)
[Announce] WebCatalog 3.0 Beta Program (1998)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Database Options (1997)
Whats going on? (2000)
tiny Linux issue (1999)
unique ascending numbers (2003)
RE: Languages (1997)
[regexp] will be renamed to [grep] in next release (2000)