numero = 13136
interpreted = N
texte = 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 oneway. Create a second group field with the date field as well and search itthe 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.htmlJohn A. Hill Pacific Coast Software11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT *San Diego, CA 92128 http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
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 oneway. Create a second group field with the date field as well and search itthe 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.htmlJohn A. Hill Pacific Coast Software11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT *San Diego, CA 92128 http://www.smithmicro.com
John Hill
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...