Re: Sorting when searching with grouped fields
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43403
interpreted = N
texte = The type is a good thing to add, though it should be num not number. (maybe number works? I've never tried it, but it's not documented that way.)But, I don't expect this will make any difference in this case, as all values shown (days since 0/0/00) will sort the same as text (at least for the next 624 years).But I don't see anything wrong with the sort order in the sample results - the PROPOSAL_DATE is sorted descending, as specified in the search.What is the problem?- brian At 10:41 AM 9/14/02, Alain Russell wrote: >You need to define the field for the sort .. > >&PROPOSAL_DATEtype=number > >Alain > >> I am trying to build a search which will find all records where the fields >> PROPOSAL_DATE or UPDATED fall in a range and then sort the results by >> PROPOSAL_DATE. The search string below finds all the correct records but >> they are sorted incorrectly: >> >> SEARCH_STRING:db=proposal.db&eqSTATUSdatarq=ACTIVE&GROUP1field=UPDATED+PROPO >> SAL_DATE&rnGROUP1datarq=731457 731471&dePROPOSAL_DATEsort=1 >> >> Results: >> PROPOSAL_DATE UPDATED >> 731471 731471 >> 731471 731471 >> 731470 731471 >> 731468 731469 >> 731465 731468 >> 731463 731464 >> 731471 >> 731467 >> 731463 >> 731463 >> 731463 >> 731462 >> 731462 >> 731457 >> 731457 >> 731457 >> 731454 731461 >> 731399 731462 >> 731218 731469 >> >> How can I build the search to get the results I want? >> >> Myron Hintz >> WebCatalog Plug in 3.0.8/MAC OS 9 >> >> >> ------------------------------------------------------------- >> 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/ ------------------------------------------------------------- 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:
The type is a good thing to add, though it should be num not number. (maybe number works? I've never tried it, but it's not documented that way.)But, I don't expect this will make any difference in this case, as all values shown (days since 0/0/00) will sort the same as text (at least for the next 624 years).But I don't see anything wrong with the sort order in the sample results - the PROPOSAL_DATE is sorted descending, as specified in the search.What is the problem?- brian At 10:41 AM 9/14/02, Alain Russell wrote: >You need to define the field for the sort .. > >&PROPOSAL_DATEtype=number > >Alain > >> I am trying to build a search which will find all records where the fields >> PROPOSAL_DATE or UPDATED fall in a range and then sort the results by >> PROPOSAL_DATE. The search string below finds all the correct records but >> they are sorted incorrectly: >> >> SEARCH_STRING:db=proposal.db&eqSTATUSdatarq=ACTIVE&GROUP1field=UPDATED+PROPO >> SAL_DATE&rnGROUP1datarq=731457 731471&dePROPOSAL_DATEsort=1 >> >> Results: >> PROPOSAL_DATE UPDATED >> 731471 731471 >> 731471 731471 >> 731470 731471 >> 731468 731469 >> 731465 731468 >> 731463 731464 >> 731471 >> 731467 >> 731463 >> 731463 >> 731463 >> 731462 >> 731462 >> 731457 >> 731457 >> 731457 >> 731454 731461 >> 731399 731462 >> 731218 731469 >> >> How can I build the search to get the results I want? >> >> Myron Hintz >> WebCatalog Plug in 3.0.8/MAC OS 9 >> >> >> ------------------------------------------------------------- >> 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/ ------------------------------------------------------------- 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/
Brian Fries
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:
Web Site (2000)
Extended [ConvertChars] (1997)
Limitations on fields? Server is crashing (1997)
2.0 Info (1997)
re: WebCat 3.0 (1998)
calendar (2001)
Apache 2.0 question (AddModule mod_webcatalog.cpp) (2008)
PCS Emailer's role ? (1997)
Has anyone accessed an LDAP server via Typhoon Pro? (2000)
b12 cannot limit records returned and more. (1997)
[WebDNA] Processor Maxing out (2010)
Generating Report Totals (1997)
Date Search Problem (1999)
[OT] Hacked IIS/FTP (2002)
Review comparison by PC Magazine: Open for On-line Business (1997)
Emailer (1997)
WebDNA Codes in Secure Mode (1997)
Digest for 4/18/97 (1997)
WC 4.0 (2000)
How to find 100 most recent additions. (1997)