Re: ExpireDate Zero or Greater than Today

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67370
interpreted = N
texte = I thought this would work, but no luck. Does WebDNA interpret this as an "AND" or "OR" search? [search db=my.db &Group1field=EXPIREDATE &Group2field=EXPIREDATE &eqGroup1datarq=0 &geGroup2datarq=[math]{[date]}[/math] ] On 6/1/06 1:52 PM, "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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: ExpireDate Zero or Greater than Today ( Donovan Brooke 2006)
  2. Re: ExpireDate Zero or Greater than Today ( Clint Davis 2006)
  3. Re: ExpireDate Zero or Greater than Today ( Matthew Bohne 2006)
  4. Re: ExpireDate Zero or Greater than Today ( Donovan Brooke 2006)
  5. Re: ExpireDate Zero or Greater than Today ( Clint Davis 2006)
  6. Re: ExpireDate Zero or Greater than Today ( Clint Davis 2006)
  7. Re: ExpireDate Zero or Greater than Today ( Clint Davis 2006)
  8. Re: ExpireDate Zero or Greater than Today ( Matthew Bohne 2006)
  9. ExpireDate Zero or Greater than Today ( Clint Davis 2006)
I thought this would work, but no luck. Does WebDNA interpret this as an "AND" or "OR" search? [search db=my.db &Group1field=EXPIREDATE &Group2field=EXPIREDATE &eqGroup1datarq=0 &geGroup2datarq=[math]{[date]}[/math] ] On 6/1/06 1:52 PM, "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/ Clint Davis

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 serial numbers (1997) emailer 150 (1997) Copyright that puppy (1998) Two prices in shoppingcart? (1997) PC Auth Hub+Merchant (1998) Preventing Safari caching (2003) Shopping cart not being assigned (1999) Firesite and [referrer] atg broke (1997) WebCat/CyberStudio Compatibility (1998) RE: Problems with dbcatalog.exe (1997) OT - iHTML contact (2007) Include a big block of text (1997) Shipping charge question (2003) Multiple email troubles (2001) Help! WebCat2 bug (1997) f2 download problems (1997) European Convention (2004) searching with groups (1997) shipcost (1997) Dummy Credit Card Number for debug? (1997)