numero = 13120
interpreted = N
texte = Why can't WebCat deal with two compatible search parameters for thesame database field?I have a database with a date field in it. I need a forms-basedsearch to have the following parameter so it won't retrieve anyrecords earlier than today's date, so I put this in the form:I also need a selection list on the form so users can select all therecords with an exact date (if that's what they choose to do). Thefollowing code creates a popup list with a blank first option. Therest of the options are dates which appear in the database as today'sdate or later:When I do NOT set a date in the popup, WebCat selects only the datesfrom today and later. That's what I would expect. But when I set thepopup to a specific date, WebCat should give me all the records withthat date - it should NOT give ne zero records.Why is it that WebCat cannot deal with this search when I try to setthe date with the popup?Any date I set with the popup is already restricted to the same rangeof dates defined in the hidden field. The popup should simply allowme to select a specific date - within the range of dates allowed bythe hidden field.But as soon as I try to use the hidden field to select a specificdate, I get zero matching records - which is impossible ... butthat's what I get.Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
Why can't WebCat deal with two compatible search parameters for thesame database field?I have a database with a date field in it. I need a forms-basedsearch to have the following parameter so it won't retrieve anyrecords earlier than today's date, so I put this in the form:[date]>I also need a selection list on the form so users can select all therecords with an exact date (if that's what they choose to do). Thefollowing code creates a popup list with a blank first option. Therest of the options are dates which appear in the database as today'sdate or later:When I do NOT set a date in the popup, WebCat selects only the datesfrom today and later. That's what I would expect. But when I set thepopup to a specific date, WebCat should give me all the records withthat date - it should NOT give ne zero records.Why is it that WebCat cannot deal with this search when I try to setthe date with the popup?Any date I set with the popup is already restricted to the same rangeof dates defined in the hidden field. The popup should simply allowme to select a specific date - within the range of dates allowed bythe hidden field.But as soon as I try to use the hidden field to select a specificdate, I get zero matching records - which is impossible ... butthat's what I get.Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
Kenneth Grome
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...