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 fromone 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:
Seems that WebDNA "AND"s these together because they each work apart fromone 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)