Re: Date field search needs ...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17031
interpreted = N
texte = >>How can I search for a particular string of characters in a date field, and then sort the results as a date?>Search for your characters under the field name, and then create a group, with a date type attribute to do the sorting. I hope this helps. Thanks John,Your idea provides the conceptual basis for a solution -- with the following precautions:The last time I tried using a group field in the manner you're suggesting, by assigning it to the original field, it was NOT possible to use both the original field name and the new group field name in the same search.Using a group field name and the original field name as two separate search parameters ends up doing the same thing as using the original field name twice -- it does not work -- it produces the wrong results.In order to make WebCatalog behave properly, I had to create *two* group fields, using one for the first the search parameter and the other for the second search parameter. I could not use the original field name in the search without getting the wrong results.It seems WebCatalog does not accept the real field name when that field is also being used in the search parameters as a group field. Unless this behavior has been changed recently, users must create a group field name for EACH parameter in a search --just do NOT combine both a group field and the original field in a search.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>How can I search for a particular string of characters in a date field, and then sort the results as a date?>Search for your characters under the field name, and then create a group, with a date type attribute to do the sorting. I hope this helps. Thanks John,Your idea provides the conceptual basis for a solution -- with the following precautions:The last time I tried using a group field in the manner you're suggesting, by assigning it to the original field, it was NOT possible to use both the original field name and the new group field name in the same search.Using a group field name and the original field name as two separate search parameters ends up doing the same thing as using the original field name twice -- it does not work -- it produces the wrong results.In order to make WebCatalog behave properly, I had to create *two* group fields, using one for the first the search parameter and the other for the second search parameter. I could not use the original field name in the search without getting the wrong results.It seems WebCatalog does not accept the real field name when that field is also being used in the search parameters as a group field. Unless this behavior has been changed recently, users must create a group field name for EACH parameter in a search --just do NOT combine both a group field and the original field in a search.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
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:
WebCat2 beta 11 - new prefs ... (1997)
[WebDNA] Domain upgrade questions (2009)
Why this code works from some places and doesn't from others? (2000)
[SHOWIF AND/OR] (1997)
New Guestbook Source (1997)
WebCatalog2 Feature Feedback (1996)
Join us at MacWorld! (1998)
my SOS last week... (1996)
Country & Ship-to address & other fields ? (1997)
TRAINING videos - Prove IT. (1998)
AppleScript question (1997)
[showif],[refferer],[include] in errormessages.db (2002)
[ot] Raid Cards for RH ES (2004)
AOL Sux and Other Thoughts (2000)
HELP WITH DATES (1997)
Smith Micro & e Frontier (2008)
[append] vs. [appendfile] delta + question? (1997)
extended ASCII with middle command (1999)
Gremlins, huh? (2000)
bug in [SendMail] (1997)