Re: Sorting when searching with grouped fields
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43402
interpreted = N
texte = Alain,Thank you for the suggestion. I added the type definition to the searchstring but still get the same results. If I search the db with:SEARCH_STRING:db=proposal.db&eqSTATUSdatarq=ACTIVE&dePROPOSAL_DATEsort=1 the results are sorted correctly but this displays more records than Iwant. Any other ideas?Thanks,Myron> 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/
Associated Messages, from the most recent to the oldest:
Alain,Thank you for the suggestion. I added the type definition to the searchstring but still get the same results. If I search the db with:SEARCH_STRING:db=proposal.db&eqSTATUSdatarq=ACTIVE&dePROPOSAL_DATEsort=1 the results are sorted correctly but this displays more records than Iwant. Any other ideas?Thanks,Myron> 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/
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:
TCPConnect / TCPSend to Solaris NN Enterprise (2002)
flushdatabases (1997)
NY taxRates.db? (1997)
100% cpu load (2006)
In Digest Dijon (2000)
WebCatb15 Mac CGI -- [purchase] (1997)
Shopping Cart Problem (1998)
[OT] Startin' sumthin' again - Python, anyone tried it? (2006)
Bad creator codes which cause access denied error message (1997)
blank page from template (1997)
RE:DatabaseHelper (1997)
[SearchString] usage (1997)
trouble updating records in database (1998)
Replace context problem ... (1997)
Emailer choke (1997)
can WC render sites out? (1997)
Upgrading old WebCat Database Files (1997)
Shopping cart not being assigned (1999)
Re[2]: Problem with new formvariables (2000)
Replace/Commit not Replacing/Commiting (2000)