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:
command requires that you specify a db errors (2000)
[WriteFile] problems (1997)
[searchString] (1997)
shell problems again... (2003)
OS Limitations (1998)
b12 cannot limit records returned and more. (1997)
Location of Browser Info.txt file (1997)
[CART] inside a [LOOP] (1997)
New Mac Emailer... (1997)
WCS Newbie question (1997)
mod_webcatalog2.so (2003)
many-to-one problem (1998)
Mozilla/4. and Browser Info.txt (1997)
PhotoMill -> PhotoMaster (1997)
Only charge card when product shipped ? (1997)
WebCat2 - [format thousands] (1997)
Setting up shop (1997)
Server Jumping and Web-networking (2000)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Suffix Mapping????? (1998)