Re: ExpireDate Zero or Greater than Today

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67372
interpreted = N
texte = Seems that WebDNA "AND"s these together because they each work apart from one another. On 6/1/06 2:30 PM, "Clint Davis" wrote: > 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)
Seems that WebDNA "AND"s these together because they each work apart from one another. On 6/1/06 2:30 PM, "Clint Davis" wrote: > 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:

Automated FTP from Shell (2004) Thanks for tips, more quest (1997) Dynamic Pop up menu? (1997) show all problem (1997) Mozilla/4. and Browser Info.txt (1997) Forms Search Questions (1997) Multiple catalog databases and showcart (1997) Help! WebCat2 bug (1997) Rumpus/Typhoon modules included in Typhoon ... (1997) Re:Emailer tracking (1997) Last Day of the Month (2005) RE: 2nd WebCatalog2 Feature Request (1996) Banners and sort of random display (1997) Separate SSL Server (1997) Field validation problem (1999) Searching (2000) New NT beta available (1997) Credit card processing - UK (1997) [LOOKUP] (1997) WebCat2b12--[searchstring] bug (1997)