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:
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)