Re: Grouping Fields
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67116
interpreted = N
texte = Any other suggestions to sort on 2 numeric fields at once? I hate tobasically recreate my DB in a table just to sort.On 5/8/06 4:31 PM, "Clint Davis"
wrote:> 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:
Any other suggestions to sort on 2 numeric fields at once? I hate tobasically recreate my DB in a table just to sort.On 5/8/06 4:31 PM, "Clint Davis" wrote:> 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:
Is Typhoon 4 or Typhoon Pro a product? (2000)
New Command prefs ... (1997)
Showing unopened cart (1997)
Problem with [CART] number (1998)
SKU lookup (1997)
required fields (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[SHOWIF AND/OR] (1997)
Sorting error (1997)
Shell barcode generation (2006)
OFF TOPIC: help wanted (1997)
OT - those using fckeditor........ (2005)
RE: Template Not Found (1998)
Help name our technology! I found it (1997)
Using EIMS instead of Emailer (1998)
Timer Values on [redirect] (1998)
Webcat/Webmerchant part II (1998)
Templates for Customer Database? (1997)
2cd pair of eyes (2003)
[math] oddness .. (2002)