Re: Exclude by date - multiple

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12030
interpreted = N
texte = >Can I nest the search in order to do multiple greater thans on the >same field (first search would be [date], second would be user-supplied??Yes, but you can also do a single search with multiple [founditems] contexts and [showif]'s to do the same thing. If you send a schematic of what you're trying to do, we can try to help figure out a method that will work for you ... :)>Is there a way to string together some math that would say something >like restrict my returns to only those records that have an ending date of >[date] or a user supplied date value - whichever is greater?You don't need any [math], just put this on the page that receives the input date from your users:
... then put this on your results.tmpl page ...[search db=XXX.db&eqendingDatadata=[date]&grendingDatedata=[inputDate]&endingdatetype=da te &inputDatetype=date] [founditems][/founditems] [/search]You'll have to fill in the rest yourself, but this will get you started ... :)Sincerely, Ken Grome WebDNA Solutions Associated Messages, from the most recent to the oldest:

    
  1. Re: Exclude by date - multiple (Kenneth Grome 1997)
  2. Re: Exclude by date - multiple (Marty Schmid 1997)
  3. Re: Exclude by date - multiple (grichter@panavise.com (Gary Richter) 1997)
  4. Exclude by date - multiple (Marty Schmid 1997)
>Can I nest the search in order to do multiple greater thans on the >same field (first search would be [date], second would be user-supplied??Yes, but you can also do a single search with multiple [founditems] contexts and [showif]'s to do the same thing. If you send a schematic of what you're trying to do, we can try to help figure out a method that will work for you ... :)>Is there a way to string together some math that would say something >like restrict my returns to only those records that have an ending date of >[date] or a user supplied date value - whichever is greater?You don't need any [math], just put this on the page that receives the input date from your users:
... then put this on your results.tmpl page ...[search db=XXX.db&eqendingDatadata=[date]&grendingDatedata=[inputDate]&endingdatetype=da te &inputDatetype=date] [founditems][/founditems] [/search]You'll have to fill in the rest yourself, but this will get you started ... :)Sincerely, Ken Grome WebDNA Solutions Kenneth Grome

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:

[WebDNA] Image resizing on the fly (2012) [replaceChars] would be nice ... (1997) taxTotal (1997) Searching Multiple DBs (1997) Up and running ... at last !! (1997) Authorize.net, SIM, tcpconnect and applescript (2003) inconsistent webcat calculation? (1997) Remove a Field from a DB (2007) WebCat2 - [include] tags (1997) RE: type 2 errors with ssl server (1997) [format 40s]text[/format] doesn't work (1997) [ShowNext] feature in 2.0 (1997) [sendmail] questions... (1997) [shell]? (2000) Another webcatalog site!! (1997) show all problem (1997) Opposite of Summ=T? (2000) webcat- multiple selection in input field (1997) Calculating Age from DB fields (2003) Grep Master Needed (2003)