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 ofwhat you're trying to do, we can try to help figure out a method that willwork 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 theinput date from your users:
... then put this on your results.tmpl page ...[searchdb=XXX.db&eqendingDatadata=[date]&grendingDatedata=[inputDate]&endingdatetype=date &inputDatetype=date][founditems][/founditems][/search]You'll have to fill in the rest yourself, but this will get you started ... :)Sincerely, Ken GromeWebDNA Solutions
Associated Messages, from the most recent to the oldest:
>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 ofwhat you're trying to do, we can try to help figure out a method that willwork 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 theinput date from your users:
... then put this on your results.tmpl page ...[searchdb=XXX.db&eqendingDatadata=
[date]&grendingDatedata=[inputDate]&endingdatetype=date &inputDatetype=date]
[founditems][/founditems][/search]You'll have to fill in the rest yourself, but this will get you started ... :)Sincerely, Ken GromeWebDNA 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)