numero = 13128
interpreted = N
texte = Ken -I don't actually know why (I see more or less the same thing you are seeing), but I think there's a better way to approach this kind of search. By the way, it seems that you get more predictable results if you use ..&mrdatefielddata=[date].. since dates are essentially treated as numbers.Anyway, if your form is a variable collector rather than pointing to an actual search command, you can use an embedded search command and change the search depending on whether a data value was selected from the pop-up list or not. It may be easier to use separate fieldnames in the form, but something like[search db=your.db&[showif[selecteddate]=]mrdatefielddata=[date]&[/showif][hideif[selecteddate=]eqdatefielddata=[selecteddate]&[/hideif]....seems like it would work. This example may be a bit simplistic, but it's one way to achieve the results you're looking for.I hope this helps,Marc Eagle StarNine Technologies http://www.smithmicro.com/>From: WebDNA-Talk@smithmicro.com on Thu, Aug 21, 1997 6:49 PM >Subject: WebCat cannot handle compatible search parameters? >To: WebDNA-Talk@smithmicro.com > >Why can't WebCat deal with two compatible search parameters for the >same database field? > >I have a database with a date field in it. I need a forms-based >search to have the following parameter so it won't retrieve any >records 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 the >records with an exact date (if that's what they choose to do). The >following code creates a popup list with a blank first option. The >rest of the options are dates which appear in the database as today's >date or later: > > > >When I do NOT set a date in the popup, WebCat selects only the dates >from today and later. That's what I would expect. But when I set the >popup to a specific date, WebCat should give me all the records with >that date - it should NOT give ne zero records. > >Why is it that WebCat cannot deal with this search when I try to set >the date with the popup? > >Any date I set with the popup is already restricted to the same range >of dates defined in the hidden field. The popup should simply allow >me to select a specific date - within the range of dates allowed by >the hidden field. > >But as soon as I try to use the hidden field to select a specific >date, I get zero matching records - which is impossible ... but >that's what I get. > >Sincerely, Ken Grome >WebDNA Solutions >http://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
Ken -I don't actually know why (I see more or less the same thing you are seeing), but I think there's a better way to approach this kind of search. By the way, it seems that you get more predictable results if you use ..&mrdatefielddata=[date].. since dates are essentially treated as numbers.Anyway, if your form is a variable collector rather than pointing to an actual search command, you can use an embedded search command and change the search depending on whether a data value was selected from the pop-up list or not. It may be easier to use separate fieldnames in the form, but something like[search db=your.db&[showif[selecteddate]=]mrdatefielddata=[date]&[/showif][hideif[selecteddate=]eqdatefielddata=[selecteddate]&[/hideif]....seems like it would work. This example may be a bit simplistic, but it's one way to achieve the results you're looking for.I hope this helps,Marc Eagle StarNine Technologies http://www.smithmicro.com/>From: WebDNA-Talk@smithmicro.com on Thu, Aug 21, 1997 6:49 PM >Subject: WebCat cannot handle compatible search parameters? >To: WebDNA-Talk@smithmicro.com > >Why can't WebCat deal with two compatible search parameters for the >same database field? > >I have a database with a date field in it. I need a forms-based >search to have the following parameter so it won't retrieve any >records 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 the >records with an exact date (if that's what they choose to do). The >following code creates a popup list with a blank first option. The >rest of the options are dates which appear in the database as today's >date or later: > > > >When I do NOT set a date in the popup, WebCat selects only the dates >from today and later. That's what I would expect. But when I set the >popup to a specific date, WebCat should give me all the records with >that date - it should NOT give ne zero records. > >Why is it that WebCat cannot deal with this search when I try to set >the date with the popup? > >Any date I set with the popup is already restricted to the same range >of dates defined in the hidden field. The popup should simply allow >me to select a specific date - within the range of dates allowed by >the hidden field. > >But as soon as I try to use the hidden field to select a specific >date, I get zero matching records - which is impossible ... but >that's what I get. > >Sincerely, Ken Grome >WebDNA Solutions >http://www.hui.net/dna/webdna.html
Marc Eagle
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...