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:
Country & Ship-to address & other fields ? (1997)
The List is Changing (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
StoreBuilder (2002)
[WebDNA] checking for mixed case text (2009)
[OT] Indexing of dynamic web sites (2003)
Locking up with WebCatalog... (1997)
For those of you not on the WebCatalog Beta... (1997)
HTTP "host" header (2003)
OK, here goes... (1997)
[CART] (1997)
Problem displaying search result (1997)
any suggestions for creating a multi-lingual site? (1999)
[Webcat 2]Next (1997)
Daze to Dates (1998)
WebCatalog for guestbook ? (1997)
Banners (1997)
Cookie Problems (2000)
Re[2]: New syntax feedback for 4.0 (2000)
RequiredFields template (1997)