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:
List archive status? (1999)
[WebDNA] inputed text getting scrambled up in DB (2012)
WebCatalog for guestbook ? (1997)
FREE Stuff .. (2003)
Re:Sizes and colors (1999)
DHTML Tag Feature (2000)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
RE: [WebDNA] How to valuate a domain name? (2010)
WebCatalog and Macromedia Flash (1998)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
WebCommerce: Folder organization ? (1997)
How flexible is Shipping? (1997)
WebCat2 Append problem (B14Macacgi) (1997)
best way to get 2 unique strings on the same page load? (2000)
Error:Too many nested [xxx] contexts (1997)
Where is f2? (1997)
autosensing lanague selection (1997)
Missing from Docs [folderName] (1997)
WCS Newbie question (1997)