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:
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)