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:

duplicate cart numbers (2002) HELP WITH DATES (1997) [CART] inside a [LOOP] (1997) Banners and sort of random display (1997) Magic [text] shows and then no show (2000) writefile to create static pages (2003) [group] ? (1997) list problems (digest) (1998) Bug? (1997) [OT] UK webcat job vacancy (2003) Client-side Image Maps and WebCat? (1998) Saving Text Areas with Orders (1997) default error on NT? (1997) taxTotal, grandTotal (1997) A Show of Hands - Count WebCat Developers (2002) Newbie: ASIP vs WebTen? (2000) RE: Loss in form (1998) sendmail spaces (1997) %d/%m/%Y [math] and [date], [math date] problems (2003) [WebDNA] search limit using WO? (2012)