Re: Sorting when searching with grouped fields

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43401
interpreted = N
texte = You need to define the field for the sort ..&PROPOSAL_DATEtype=numberAlain> 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting when searching with grouped fields (Myron Hintz 2002)
  2. Re: Sorting when searching with grouped fields (Brian Fries 2002)
  3. Re: Sorting when searching with grouped fields (Myron Hintz 2002)
  4. Re: Sorting when searching with grouped fields (Brian Fries 2002)
  5. Re: Sorting when searching with grouped fields (Myron Hintz 2002)
  6. Re: Sorting when searching with grouped fields (Brian Fries 2002)
  7. Re: Sorting when searching with grouped fields (Myron Hintz 2002)
  8. Re: Sorting when searching with grouped fields (Alain Russell 2002)
  9. Sorting when searching with grouped fields (Myron Hintz 2002)
You need to define the field for the sort ..&PROPOSAL_DATEtype=numberAlain> 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/ Alain Russell

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:

WebCatalog Technical Reference (1997) turning every 5th line red (1998) Creating 404 Not Found pages (1999) OT: 128 bit Encryption (2003) Cleaning up all the shopping carts (2000) docs for WebCatalog2 (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Kaaaaahhhhhhhnnnnnnn! (1997) webdelivery not working (1998) [url] - question (2000) Attn: Bug in GeneralStore example b15 (1997) Multi shift click (1999) WC2b12: Yes, Formulas.db is for real (1997) .hdr files (2004) [ShowNext] feature in 2.0 (1997) shipcost (1997) Apoligy (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Credit Card not accepted (1998) Buying sans cart (1997)