Re: Grouping Fields
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67100
interpreted = N
texte = 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:> PRICE
SALEPRICE> 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?I guess I would do the table route.Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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:
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?I guess I would do the table route.Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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/
Donovan Brooke
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:
HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
Forcing a NEWCART (1997)
Uploading Files (2000)
Type 11 errors setting up WebCAt 2 (1997)
Limiting user access to .tmpl files (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Another webcatalog site!! (1997)
[WebDNA] Still having problems (2008)
[WebDNA] TLS 1.2 and [tcpconnect] (2018)
[WebDNA] limit found per row (2011)
[OT] - See my site? (2004)
Date Help! (2003)
Help w/ Duplicating The General Store 5 times. (1997)
What if SSL server down? MAC (1997)
Setting a range in a search (1998)
country of origin from IPADDRESS??? (2001)
[dos] command and [math] (1998)
WebCatalog 4.0 has been released! (2000)
Max Record length restated as maybe bug (1997)
Separate SSL Server (1997)