Re: Grouping Fields
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67132
interpreted = N
texte = You could add another field to your database - "SORTPRICE" - and set that field to the lesser non-zero value of PRICE an SALEPRICE. Then you can sort by SORTPRICE. WebDNA has no provision for grouping two columns for sorting purposes. Brian Fries BrainScan Software On May 9, 2006, at 5:30 AM, Clint Davis wrote: > Any other suggestions to sort on 2 numeric fields at once? I hate to > basically 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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:
You could add another field to your database - "SORTPRICE" - and set that field to the lesser non-zero value of PRICE an SALEPRICE. Then you can sort by SORTPRICE. WebDNA has no provision for grouping two columns for sorting purposes. Brian Fries BrainScan Software On May 9, 2006, at 5:30 AM, Clint Davis wrote: > Any other suggestions to sort on 2 numeric fields at once? I hate to > basically 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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/
Brian Fries
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:
RE: protect tag not working (1998)
WCS Newbie question (1997)
[input]?? (1998)
Summing a field full of numbers ... (1997)
Help formatting search results w/ table (1997)
WC2b15 File Corruption (1997)
OR-searching (2000)
Highlighting words found in a keyword search (2003)
WebCat b13 CGI -shownext- (1997)
What am I doing wrong? (2000)
Multi-Row Tables from a search. (1997)
Not really WebCat- (1997)
WebCatalog Upgrade Pricing? (1997)
Problem (1997)
WebCatalog for Dummies part 2 (2000)
Hiding HTML and page breaks (1997)
Non-technical messages ... (1997)
How to verify email address (1997)
Variable Prices (1998)
billing system (2003)