numero = 13163
interpreted = N
texte = John,Why do I need to create two groups? Why can't I create one group on the date field and search that group field one way, then search the date field directly the second way?But more importantly, why doesn't group searching work for me? Whenever I define a group, nothing happens. Any group search parameters I use are ignored. It's as if WebCat doesn't understand that group1 is a search field - even after I have defined it properly - so it completely ignores that part of the search.What good are group searches when they don't work?>Ken: > >You can do this! However, you need to use the group concept. Basically, >create a group with one field in it: date. Search that group field in one >way. Create a second group field with the date field as well and search it >the second way. That scenario was one of the reasons for the group variable. > >John. > >>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 > > >John A. Hill Pacific Coast Software >11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT * >San Diego, CA 92128 http://www.smithmicro.com Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
John,Why do I need to create two groups? Why can't I create one group on the date field and search that group field one way, then search the date field directly the second way?But more importantly, why doesn't group searching work for me? Whenever I define a group, nothing happens. Any group search parameters I use are ignored. It's as if WebCat doesn't understand that group1 is a search field - even after I have defined it properly - so it completely ignores that part of the search.What good are group searches when they don't work?>Ken: > >You can do this! However, you need to use the group concept. Basically, >create a group with one field in it: date. Search that group field in one >way. Create a second group field with the date field as well and search it >the second way. That scenario was one of the reasons for the group variable. > >John. > >>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 > > >John A. Hill Pacific Coast Software >11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT * >San Diego, CA 92128 http://www.smithmicro.com Sincerely, Ken Grome WebDNA Solutions http://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...