Re: How to break a search ...
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41753
interpreted = N
texte = If this is a bug with the search context (which we will look into), then for now you will need to store the results in a temporary db and then sort that db.> -----Original Message----- > From: WebCatalog Talk > [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf > Of Kenneth Grome > Sent: Friday, July 19, 2002 11:12 PM > To: WebCatalog Talk > Subject: How to break a search ... > > > 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 2002 > > In 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/ ------------------------------------------------------------- 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:
If this is a bug with the search context (which we will look into), then for now you will need to store the results in a temporary db and then sort that db.> -----Original Message----- > From: WebCatalog Talk > [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf > Of Kenneth Grome > Sent: Friday, July 19, 2002 11:12 PM > To: WebCatalog Talk > Subject: How to break a search ... > > > 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 2002 > > In 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/ ------------------------------------------------------------- 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/
Scott Anderson
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:
date stamp (2003)
passing search criteria (1997)
RE: too many nested [xxx] (1997)
TcpConnect get files on ver. 5.x FIXED FIXED FIXED (2004)
Running 2 two WebCatalog.acgi's (1996)
(2000)
logout after authenticated (2002)
Shed some light on web delivery? (2000)
syntax question, not in online refernce (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Fwd: [WebDNA] special chars (2009)
[WebDNA] Convert Math Date in Excel (2010)
WebDNA maxing out processor (2008)
Quit revisited (1997)
Major Security Hole (1998)
Sum of [founditems] ? (2004)
Version f1 status (1997)
off-topic - printinglib 68K (1997)
RE: Remote administration (1998)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)