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:
Search String (2003)
Email Format (1998)
Purchase command error problem (1997)
Web Developer Product Awards (1997)
searches with dash, period etc. (2000)
Append again (1999)
Webcat run amuk (2002)
This message couldn't reach the list! (multi-column (1998)
Protecting databases (1999)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Associative lookup style? + bit more (1997)
Next X hits (1996)
WebCommerce: Folder organization ? (1997)
Major bug report on rootbeer (1997)
Re:Adding non-SKUs to cart (1998)
WebDNA 4.5.1 Now Available (2003)
Emailer port change (1997)
PSC recommends what date format yr 2000??? (1997)
WebCatalog can't find database (1997)
OT - SMSI complaint (2001)