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:
[writefile] (1997)
SMSI - MacWorld (2005)
move files (2000)
My slower response (1997)
How do I handle extra spaces? (2002)
Multiple Pulldowns (1997)
Input appreciated (2000)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Cart Number sequence (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
[date] formatting bug inside [orderfile]? (1998)
New servers and new inline cache (1997)
IRC Channel (2003)
RED QUESTION MARK (1999)
WebDNA-Talk Digest mode broken (1997)
Appending with +1 ... (1997)
email [title] (1997)
Nav. 4 probs with cart (1997)
PCS Frames (1997)
Multiple Pulldowns (1997)