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:
RE: [sendmail]- bcc? (1998)
Whats going on with my SERIAL NUMBER??? (1998)
beta 5 - OS X install issue (2000)
[TaxableTotal] - not working with AOL and IE (1997)
[WebDNA] ONLY the FIRST continuous run of numeric chars? (2008)
How To question on setting up downloads (1997)
OT: Verisign buys Thawte (1999)
Searching for a Blank Field (2000)
Replace Statement (1997)
Just a thought - WebCat classes (1998)
creating writefile data from a nested search (1997)
WebDNA Solutions ... sorry! (1997)
SiteGuard Use Question (1997)
system crashes, event log (1997)
A two part question (1999)
[format xs] freeze (1997)
Help name our technology! I found it (1997)
WebCat2 - Getting to the browser's username/password data (1997)
WebDNA Forum(s) should = GUI (2002)
Help with nested search (1998)