Re: ExpireDate Zero or Greater than Today
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67369
interpreted = N
texte = [search db=my.db&geEXPIREDATEdatarq=[math]{[date]}[/math]&group1field=EXPIREDATE&eqgroup1datarq=0] Matthew Bohne Clint Davis wrote: > I have an EXPIREDATE field that will contain zero if the record does not > expire or days since the epoch if it does expire. I need to find all records > where the EXPIREDATE field is either zero or greater than today's date. The > below code obviously doesn't take into account records whose EXPIREDATE > field contains zero. Any tips? > > [search db=my.db&geEXPIREDATEdatarq=[math]{[date]}[/math]] > > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
[search db=my.db&geEXPIREDATEdatarq=[math]{[date]}[/math]&group1field=EXPIREDATE&eqgroup1datarq=0] Matthew Bohne Clint Davis wrote: > I have an EXPIREDATE field that will contain zero if the record does not > expire or days since the epoch if it does expire. I need to find all records > where the EXPIREDATE field is either zero or greater than today's date. The > below code obviously doesn't take into account records whose EXPIREDATE > field contains zero. Any tips? > > [search db=my.db&geEXPIREDATEdatarq=[math]{[date]}[/math]] > > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/
Matthew Bohne
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:
WebCatalog NT beta 18 now available (1997)
Date Math (2005)
Find one not all, code not working (2003)
building / customizing stores (2000)
WebCatalog can't find database (1997)
OT: Safari/Mac - frames and iframes acting weird (2007)
Searching multiple Databases (1997)
Stat analyzer (1997)
links to .db's ? (1999)
Searching an Email database (1997)
RE: Web*SSL and WebCatalog (1997)
FORM NONSENSE - WAS: How much is too much? (2002)
all records returned. (1997)
SKU's (2000)
auto adding SKUs w/DB helper (1998)
Setting Lineitems (2005)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
serial number generation (1997)
tcpconnect (1999)