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:
New public beta available (1997)
Opinion: [input] should be called [output] ... (1997)
Re:PCS Customer submissions ? (1997)
[WebDNA] How to stop cutting a word (2008)
[OT] http list (2003)
Re:quit command on NT (1997)
Euro WebDNA Conference (2004)
Searching multiple Databases (1997)
Protecting a folder (2000)
RE: AccountAuthorizer doesn't seem to work (1997)
Images in WebCat (2000)
Referrer field to header field conversion (1997)
no global [username] or [password] displayed ... (1997)
updating with ProductEditor (1998)
Calendar Program (2004)
Overridding E-Mailer (1998)
Configuring E-mail (1997)
Frustration with formulas.db (1999)
Re2: AAgghh!! Help, please. SSL strikes again. (1997)
WebCatalog2 for NT Beta Request (1997)