Sorting when searching with grouped fields

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43400
interpreted = N
texte = 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 731469How 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/ 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)
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 731469How 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/ Myron Hintz

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:

automatic reload of frameset (1997) 2.0 Info (1997) Database field limit? (1998) full text search ? (2002) won't serve .tpl -not permissions- can't process .tpl (2000) repost: sending a down arrow (2000) NetSplat and WebCat2 (1997) [Summary] re: Emailer setup (1997) carts on MacOS X Server (2000) WebCat2b12 forgets serial # (1997) PCS Emailer's role ? (1997) [sendmail] and [formvariables] (1997) Separate SSL Server (1997) [protect admin] (1997) Upgrading old WebCat Database Files (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Firesite cache vs webcat cache (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) Creating a folder with WebCat? (2000) Clean Code: Rules for inserting keyboard returns? (1997)