Re: Sorting Various Sizes

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49661
interpreted = N
texte = You'd have to add another field to your database (say, 'ounces') to show how the various sizes relate to one another. Then do the sort on that field.SIZE OUNCES 4 oz 4 8 oz 8 16 oz 16 Quart ... (whatever it is, I only speak metric!)>I catalog of paints that come in various sizes. > >Here are my sizes: > >4 oz >8 oz >16 oz >Quart > >I would like to sort display my search results in the above order, but >I'm not sure how to use the sort feature. I currently have this: > > [search >db=products.txt&eqitemdatarq=[item]&colorsort=1&colorsdir=as&sizesort=2& >sizesdir=as&sizetype=num] > >This results in the following sorting: > >Quart >4 oz >8 oz >16 oz > >How can I move Quart to the top? Soon, I will have Gallon to >contend with as well. > >Thanks, >Kim > > >netSourcery >Voice: 423-336-1NET >Emergency: 423-618-1069 >Toll Free: 1-866-811-7087 >When you need more than a website... > > >------------------------------------------------------------- >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://webdna.smithmicro.com/ -- Daryl Mitchell E-Business Specialist, PrintWest / PW Group Ltd. Saskatoon, SK CANADA Tel: (306) 665-3557 Toll-free: (800) 291-9935 Fax: (306) 653-1255 E-Mail: d.mitchell@pwgroup.ca Web: http://www.pwgroup.ca/------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting Various Sizes (Daryl Mitchell 2003)
  2. Sorting Various Sizes (Kimberly D. Walls 2003)
You'd have to add another field to your database (say, 'ounces') to show how the various sizes relate to one another. Then do the sort on that field.SIZE OUNCES 4 oz 4 8 oz 8 16 oz 16 Quart ... (whatever it is, I only speak metric!)>I catalog of paints that come in various sizes. > >Here are my sizes: > >4 oz >8 oz >16 oz >Quart > >I would like to sort display my search results in the above order, but >I'm not sure how to use the sort feature. I currently have this: > > [search >db=products.txt&eqitemdatarq=[item]&colorsort=1&colorsdir=as&sizesort=2& >sizesdir=as&sizetype=num] > >This results in the following sorting: > >Quart >4 oz >8 oz >16 oz > >How can I move Quart to the top? Soon, I will have Gallon to >contend with as well. > >Thanks, >Kim > > >netSourcery >Voice: 423-336-1NET >Emergency: 423-618-1069 >Toll Free: 1-866-811-7087 >When you need more than a website... > > >------------------------------------------------------------- >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://webdna.smithmicro.com/ -- Daryl Mitchell E-Business Specialist, PrintWest / PW Group Ltd. Saskatoon, SK CANADA Tel: (306) 665-3557 Toll-free: (800) 291-9935 Fax: (306) 653-1255 E-Mail: d.mitchell@pwgroup.ca Web: http://www.pwgroup.ca/------------------------------------------------------------- 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://webdna.smithmicro.com/ Daryl Mitchell

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:

[format 40s]text[/format] doesn't work (1997) Fits with error message (2001) Intermitent problem using [referrer] (1997) Issues with the default db files ... (2003) Part Html part WebDNA (1997) Running 2 two WebCatalog.acgi's (1996) Re:WebCatalog/WebMerchant III (1998) no template caching (1997) Help name our technology! (1997) OT: Amazon Patents (2000) Document Contains No Data! (1997) Not really WebCat- (1997) Aaron kant add (or whatever it was) (2000) emailer setup (1997) Database Not Writing Fully to Disk (2007) problems with 2 tags (1997) Searching Relational Databases (2004) Limitations on fields? Server is crashing (1997) 2.0 Info (1997) Unable to open the demo file (1998)