Re: Quick Question About Sorting

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15436
interpreted = N
texte = >In order to sort by a field, are you required to search that field?No, but you *do* need to tell webCat in which direction you want the data sorted, or it will do it by using it's built-in 'ranking' instead of in any particular order you might prefer.>For example: >[Search db=database.db&geSKUdatarq=[SKU]&recordtitlesort=1] >This does not sort by RecordTitle.That's because recordtitlesort=1 is not telling WebCat to sort in ascending or descending order on that foeld, so you have to tell it what you want -- like this:[Search db=database.db&geSKUdatarq=[SKU]&recordtitlesort=1&recordtitlesdir=as]or like this:[Search db=database.db&geSKUdatarq=[SKU]&asrecordtitlesort=1]Sincerely, Ken Grome ken@iav.com WebDNA Solutions http://www.smithmicro.com/webdnasolutions/... Associated Messages, from the most recent to the oldest:

    
  1. Re: Quick Question About Sorting (Kenneth Grome 1997)
  2. Re: Quick Question About Sorting (John Hill 1997)
  3. Quick Question About Sorting (Trevor Crist 1997)
>In order to sort by a field, are you required to search that field?No, but you *do* need to tell webCat in which direction you want the data sorted, or it will do it by using it's built-in 'ranking' instead of in any particular order you might prefer.>For example: >[Search db=database.db&geSKUdatarq=[SKU]&recordtitlesort=1] >This does not sort by RecordTitle.That's because recordtitlesort=1 is not telling WebCat to sort in ascending or descending order on that foeld, so you have to tell it what you want -- like this:[Search db=database.db&geSKUdatarq=[SKU]&recordtitlesort=1&recordtitlesdir=as]or like this:[Search db=database.db&geSKUdatarq=[SKU]&asrecordtitlesort=1]Sincerely, Ken Grome ken@iav.com WebDNA Solutions http://www.smithmicro.com/webdnasolutions/... Kenneth Grome

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:

php vs WebCatalog (2000) Talk List Suggestions (1997) Nesting format tags (1997) Search Question (2003) How far do [showif]s go? (1997) RE: Multiple Stores and WebCatalog Prefs (1997) USPS Intergration (2001) [OT] Theiving B*****ds (2004) Example Search Form (1997) [WebDNA] encoding with webdna/JS, in context of various file encodings/charsets (2010) Email Newsletters (2003) [append] (1997) Multiple catalog databases and showcart (1997) creator code (1997) Locking up with WebCatalog... (1997) Frames and WebCat (1997) [OT] Unix question (2002) Online magazine- monthly updates and such (1999) [WebDNA] test (2011) Using Cookie for client specific info? (1997)