Grouping Fields

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67099
interpreted = N
texte = I have PRICE and SALEPRICE fields in my product database. I want to find every product in the database and sort based on those fields. If an item is on sale, the SALEPRICE field is populated with a real number, otherwise it's populated with zero. Group1Field=SALEPRICE+PRICE&neGroup1datarq=find_all&deGroup1sort=1&Group1typ e=num My DB looks like this: PRICESALEPRICE 13.990 14.9912.49 10.990 This should display as: 13.99 12.49 10.99 Can this be done with Grouping, or do I have to create a table to re-search and sort? ------------------------------------------------------------- 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: Grouping Fields ( Marko Bernyk 2006)
  2. Re: Grouping Fields ( Stuart Tremain 2006)
  3. Re: Grouping Fields ( Donovan Brooke 2006)
  4. Re: Grouping Fields ( Marko Bernyk 2006)
  5. Re: Grouping Fields ( Brian Fries 2006)
  6. Re: Grouping Fields ( Clint Davis 2006)
  7. Re: Grouping Fields ( Donovan Brooke 2006)
  8. Grouping Fields ( Clint Davis 2006)
  9. Re: Grouping fields help ( Gary Krockover 2004)
  10. Re: Grouping fields help ( Gary Krockover 2004)
  11. Re: Grouping fields help ( Gary Krockover 2004)
  12. Re: Grouping fields help ( Brian Fries 2004)
  13. Re: Grouping fields help ( Donovan Brooke 2004)
  14. Re: Grouping fields help ( Donovan Brooke 2004)
  15. Re: Grouping fields help ( Rob Marquardt 2004)
  16. Re: Grouping fields help ( Gary Krockover 2004)
  17. Re: Grouping fields help ( Gary Krockover 2004)
  18. Re: Grouping fields help ( Rob Marquardt 2004)
  19. Re: Grouping fields help ( Donovan Brooke 2004)
  20. Re: Grouping fields help ( Gary Krockover 2004)
  21. Re: Grouping fields help ( Donovan Brooke 2004)
  22. Grouping fields help ( Gary Krockover 2004)
  23. Re: Grouping Fields in Context (Josh Tiger 1999)
  24. Re: Grouping Fields in Context (John Hill 1999)
  25. Re: Grouping Fields in Context (Timothy W. Killian 1999)
  26. Re: Grouping Fields in Context (John Hill 1999)
  27. Re: grouping fields (Kenneth Grome 1999)
  28. Weighting of grouped results possible? (was: grouping fieldsquestion) (Dale Stokdyk 1998)
  29. Re: grouping fields question (Britt T. 1998)
  30. Re: Grouping fields problem (John Hill 1998)
  31. Re: Grouping fields problem (Dave MacLeay 1998)
  32. Re: Grouping fields problem (Britt T. 1998)
  33. Re: Grouping fields problem (Britt T. 1998)
I have PRICE and SALEPRICE fields in my product database. I want to find every product in the database and sort based on those fields. If an item is on sale, the SALEPRICE field is populated with a real number, otherwise it's populated with zero. Group1Field=SALEPRICE+PRICE&neGroup1datarq=find_all&deGroup1sort=1&Group1typ e=num My DB looks like this: PRICESALEPRICE 13.990 14.9912.49 10.990 This should display as: 13.99 12.49 10.99 Can this be done with Grouping, or do I have to create a table to re-search and sort? ------------------------------------------------------------- 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/ Clint Davis

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:

Calculating multiple shipping... (1997) Locking up with WebCatalog... (1997) WebCat2b12 forgets serial # (1997) Ok here is a question? (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) shownext problems (1998) FM PRO Compatibility Issue - Single Database w/o Conversions (1997) Help!!!! Purchases not going through! (1997) [WebDNA] small bug when searching tables in functions (2011) faxing orders (2000) suffix mapping, use of cache, etc. (1997) Plugin or CGI or both (1997) WC 2.0 frames feature (1997) Smith Micro - no competition (2000) Re:no [search] with NT (1997) WebCat, The Trend, & Consolidating... (1997) Cancel Subscription (1996) are we ready to fix random sort? - Or did that already happen? (2000) Email within tmpl ? (1997) Problems with totals (1997)