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) OR I'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, Marko On Tuesday, 9 May 2006 7:31 AM, 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/ ------------------------------------------------------------- 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) OR I'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, Marko On Tuesday, 9 May 2006 7:31 AM, 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/ ------------------------------------------------------------- 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:
no global [username] or [password] displayed ... (1997)
autocommit problem (1998)
Webcatalog 3.0.8 on PWS (2000)
WebCat2b15MacPlugin - [protect] (1997)
How to Display text in empty fields (1997)
Forms Search Questions (1997)
Help! WebCat2 bug (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
[CART] inside a [LOOP] (1997)
drop down menu (2000)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Waitfor file (2000)
Text data with spaces in them... (1997)
Explorer 3.0/ Access Denied! (1997)
NT Version on IIS 4.0 (1997)
pc (1997)
Apache 2 (2002)
Multiple ShipTo Addresses (2003)
website hosters using webcat? (1999)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)