How to break a search ...
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41752
interpreted = N
texte = Did you know that when you want to do a bw or a wo search on a formatted date field and *also* sort the results by date, it is impossible? Or at least my tests seem to indicate that it is impossible ...I was trying to find all records that begin with 07 in the startDate field and contains 2002 in the endDate field. The dates in these two fields are formatted in the standard MM/DD/YYYY format.What I learned is that this search is possible only if I do *NOT* use the sort parameters that define these fields as date fields. Because as soon as I add the startDatetype=date or endDateType=date parameters, the search no longer finds the records that begin with 07 or contain 2002In other words, adding the sort parameters breaks the search.But if I do not add the sort parameters, I cannot sort my results properly. So how can I do the search I want to do while at the same time sort the results the way I want to?Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Did you know that when you want to do a bw or a wo search on a formatted date field and *also* sort the results by date, it is impossible? Or at least my tests seem to indicate that it is impossible ...I was trying to find all records that begin with 07 in the startDate field and contains 2002 in the endDate field. The dates in these two fields are formatted in the standard MM/DD/YYYY format.What I learned is that this search is possible only if I do *NOT* use the sort parameters that define these fields as date fields. Because as soon as I add the startDatetype=date or endDateType=date parameters, the search no longer finds the records that begin with 07 or contain 2002In other words, adding the sort parameters breaks the search.But if I do not add the sort parameters, I cannot sort my results properly. So how can I do the search I want to do while at the same time sort the results the way I want to?Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
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:
WebCat on 10.0.4 - iTools 6.0 (2001)
An Isnumeric function of some kind (2001)
BIG PROBLEMS with Checkboxes!!! (1998)
Beta 18 (1997)
Forcing Search w/ URL (1999)
Multiple prices (1997)
So [OT] it's not even funny (2003)
Sorting a summary (2000)
[OT] was WebDNA on a Raq4i (2003)
[OT] See QT? (Was Eaaaasy FTP...) (2003)
[WebDNA] feature request (2011)
listfiles-looking for slick solution (1997)
re-sorting founditems (2002)
Webcat & SIMS (1998)
show all problem (1997)
[SHOWIF AND/OR] (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Summing fields (1997)
WCS Newbie question (1997)
Re:Emailer setup (1997)