Re: ExpireDate Zero or Greater than Today
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67373
interpreted = N
texte = 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]] [search db=my.db&GROUP1fields=EXPIREDATE&geGROUP1data=[url][math]{[date]}[/math][/url]&GROUP2fields=EXPIREDATE&eqGROUP2data=0&GROUP1type=num&GROUP2type=num] Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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:
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]] [search db=my.db&GROUP1fields=EXPIREDATE&geGROUP1data=[url][math]{[date]}[/math][/url]&GROUP2fields=EXPIREDATE&eqGROUP2data=0&GROUP1type=num&GROUP2type=num] Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/
Donovan Brooke
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:
Multiple prices (1997)
WebDNA 5.0 Enterprise Edition (2003)
Cold Fusion Warm and Fuzzy? (1999)
Writing encrypted files causes errors ... (1998)
New Webcatalog for Mac (1997)
Help :( (2001)
select multiple 2 more cents (1997)
search problem (2002)
Web Catalog 2 demo (1997)
Don't tick me off :) [elaspedtime] (1997)
Looking for a Manual (1997)
Search design (1997)
[OT] ODBC between IIS and remote Access problem (2000)
Re1000002: Setting up shop (1997)
What am I missing (1997)
Languages (1997)
[include ...] behavior (1997)
Email troubles (2005)
SQL newbie (2002)
GoLive CyberStudio 1.0.1 (1997)