Re: Price and Formula.db
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45515
interpreted = N
texte = Did you copy/paste that formula? If so, you're missing some brackets onyour URL's:SKU&value=[URL[SKU][/URL&returnfield=PriceGK> I've tried everything I can think of, everything you guys suggested, andeverything I can find in the archives. I have to fall back on the there's abug in WC4.x Mac Classic and OS X that prevents Formulas.db from working.>> Here's the entire Formulas.db:> Name Formula> Price [Math][lookupdb=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+([lookupdb=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[lookupdb=Woods.db&lookinfield=Woods&value=[URL][Woods][/URL]&returnfield=ExtraCost])[/Math]> Taxable F> UNITSHIPCOST 0.00> SHIPCOST 0.00> TAXRATE 0.00>> Test 1- This formula will put 0.00 in the Price field of a ShoppingCarttemplate 100% of the time.>> Test 2- If I change the Price formula to:> [Math][lookupdb=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+10[/Math]>> it will add 10 to the price from the Products.db 100% of the time.>> Test 3- If I put> [Math=Show]X=[lookupdb=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+([lookupdb=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[lookupdb=Woods.db&lookinfield=Woods&value=[URL][Woods][/URL]&returnfield=ExtraCost])[/Math]>> into a template with the SKU and Woods variables carried from anothertemplate, it will show the correct value for X.>> Test 4- The lookups will also return the correct values if put into atemplate as two separate lookups.>> Test 5- If I put the individual lookups into the lineitems loop in theShoppingCart.tpl, it will they both return the correct values.>> SmithMicro, you created this mess. Although I don't expect you to respondto questions about your products, what do I tell the client and how do I getthe calculated price into a shopping cart based on the price of the itemplus the options?>> Using a password in the add command is insecure and therefore not anoption.>> Glenn-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Did you copy/paste that formula? If so, you're missing some brackets onyour URL's:SKU&value=[URL[SKU][/URL&returnfield=PriceGK> I've tried everything I can think of, everything you guys suggested, andeverything I can find in the archives. I have to fall back on the there's abug in WC4.x Mac Classic and OS X that prevents formulas.db from working.>> Here's the entire formulas.db:> Name Formula> Price [math][lookupdb=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+([lookupdb=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[lookupdb=Woods.db&lookinfield=Woods&value=[url][Woods][/URL]&returnfield=ExtraCost])[/Math]> Taxable F> UNITSHIPCOST 0.00> SHIPCOST 0.00> TAXRATE 0.00>> Test 1- This formula will put 0.00 in the Price field of a ShoppingCarttemplate 100% of the time.>> Test 2- If I change the Price formula to:> [math][lookupdb=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+10[/Math]>> it will add 10 to the price from the Products.db 100% of the time.>> Test 3- If I put> [Math=Show]X=[lookupdb=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+([lookupdb=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[lookupdb=Woods.db&lookinfield=Woods&value=[url][Woods][/URL]&returnfield=ExtraCost])[/Math]>> into a template with the SKU and Woods variables carried from anothertemplate, it will show the correct value for X.>> Test 4- The lookups will also return the correct values if put into atemplate as two separate lookups.>> Test 5- If I put the individual lookups into the lineitems loop in theShoppingCart.tpl, it will they both return the correct values.>> SmithMicro, you created this mess. Although I don't expect you to respondto questions about your products, what do I tell the client and how do I getthe calculated price into a shopping cart based on the price of the itemplus the options?>> Using a password in the add command is insecure and therefore not anoption.>> Glenn-------------------------------------------------------------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://search.smithmicro.com/
Gary Krockover
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:
how to use WebCat w. SSL & CyberCash (1998)
Log-in Scheme (2003)
(1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
WebCatalog vidoes (was: Prices Dropped) (1998)
Table Trouble... (2005)
Location of Webcat site in folder hierarchy (1997)
Bug Report in the docs or? Listfields WebDNA 4.5 (2002)
Math with Time (1997)
limitation found on group searching (1997)
default image if image in code not available (2003)
WC2b15 File Corruption (1997)
OT - SMSI complaint (2001)
Authorize net woes (2003)
WebDNA-Talk Digest mode broken (1997)
Trouble with Showif and Search (1998)
webcat NT (1998)
Error.html (1997)
Problem (1997)
Emailer (WebCat2) (1997)