Re: Grouping Fields
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67133
interpreted = N
texte = I'd be either having a New field in the main db with a FINALPRICE, (that way you can do Was $$$ Now $$$ etc)ORI'd be doing it with a temp db like this:[search db=database.db&gePRICEdata=0][writefile temp.db]SHOWPRICE[/writefile][founditems][appendfile db=temp.db][showif [SALEPRICE]=0][PRICE][/showif][showif [SALEPRICE]>0][SALEPRICE][/showif][/append][/founditems][/search][search db=temp.db&geSHOWPRICEdata=0&SHOWPRICEsort=1&SHOWPRICEsdir=de&SHOWPRICEtype=num][founditems][SHOWPRICE][/founditems][/search][closedatabase temp.db][deletefile file=temp.db]-- Regards,MarkoOn Tuesday, 9 May 2006 7:31 AM, Clint Davis
wrote:I have PRICE and SALEPRICE fields in my product database. I want to findevery product in the database and sort based on those fields. If an item ison sale, the SALEPRICE field is populated with a real number, otherwise it'spopulated with zero.Group1Field=SALEPRICE+PRICE&neGroup1datarq=find_all&deGroup1sort=1&Group1type=numMy DB looks like this:PRICESALEPRICE13.99014.9912.4910.990This should display as:13.9912.4910.99Can this be done with Grouping, or do I have to create a table to re-searchand 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/-------------------------------------------------------------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:
I'd be either having a New field in the main db with a FINALPRICE, (that way you can do Was $$$ Now $$$ etc)ORI'd be doing it with a temp db like this:[search db=database.db&gePRICEdata=0][writefile temp.db]SHOWPRICE[/writefile][founditems][appendfile db=temp.db][showif [SALEPRICE]=0][PRICE][/showif][showif [SALEPRICE]>0][SALEPRICE][/showif][/append][/founditems][/search][search db=temp.db&geSHOWPRICEdata=0&SHOWPRICEsort=1&SHOWPRICEsdir=de&SHOWPRICEtype=num][founditems][SHOWPRICE][/founditems][/search][closedatabase temp.db][deletefile file=temp.db]-- Regards,MarkoOn Tuesday, 9 May 2006 7:31 AM, Clint Davis wrote:I have PRICE and SALEPRICE fields in my product database. I want to findevery product in the database and sort based on those fields. If an item ison sale, the SALEPRICE field is populated with a real number, otherwise it'spopulated with zero.Group1Field=SALEPRICE+PRICE&neGroup1datarq=find_all&deGroup1sort=1&Group1type=numMy DB looks like this:PRICESALEPRICE13.99014.9912.4910.990This should display as:13.9912.4910.99Can this be done with Grouping, or do I have to create a table to re-searchand 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/-------------------------------------------------------------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/
Marko Bernyk
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:
NT Manual (1997)
Sorting (1998)
New Plug-in and Type 11 errors (1997)
WebCat2 several catalogs? (1997)
[WebDNA] Text Variable in Search (2010)
Triggers and today's leap day? (2000)
Help!!!! (1997)
Need something like [listchars] ... (2000)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Problem (1997)
Sandboxes & Kitty Litter trays (2003)
Trouble with formula.db + more explanation (1997)
WebCat2.0 [format thousands .0f] no go (1997)
triggers.db (1999)
WebCat cannot handle compatible search parameters? (1997)
Email Problem (1997)
WebCat2b13MacPlugIn - [include] (1997)
Sorting LISTFILES (1997)
emailer w/F2 (1997)
More on the email templates (I like it) (1997)